update table

AppSheet AppSheet Q&A
1

I have a data entry form with a column “status” at the end “pass” & “fail” buttons.

i have a bot & actions so that if the data is “pass” it auto copies row to Table ‘Master’ and if its recorded as “fail” it auto copies to table ‘Defect’. (Master & Defect are Menu views)

How do i make an action/bot to auto update the ‘defect’ table and remove the entry from this table only if the original entry is changed to “pass”. It auto adds to the Master table but have to manually remove it from Defect.

thanks in advance

2

You don’t need to copy the rows to other tables nor have a Bot.

You can simply create Slices - which are subsets of a table. Create a Slice for “Passed” rows and a second for “Failed” rows. Then create views for these Slices. Whenever the Status is set or changed, the row will move to the proper Slice and show in the associated view.

I hope this helps!

1 Like