conditional multi-line update in appsheet

AppSheet AppSheet Q&A
1

Hello everyone,

I am having the following problem, I want to create a button to bulk update data in cell [number], if [line] equals 2. Like the example picture below. At the moment I still don’t know how to do it and the idea, you have done or have any ideas can you let me know thank you very much for that.

nhatphan_0-1671761497899.png
nhatphan_0-1671761497899.png499×372 7.57 KB

2
  1. Create an action, Data: Set the values of some columns in this row and set [number] = 0
  2. Create an action, Data: Execute an action on a set of rows
    • Referenced Table: Own table
    • Referenced Rows: FILTER(“Own table”, [line] = 2)
    • Referenced Action: the Action created in step 1
2 Likes
3

thanks for your reply.

i try now.

1 Like
4

sorry for asking more but below part.

the edit is table number1. Do I have to create a new one?

nhatphan_0-1671765110440.png
nhatphan_0-1671765110440.png794×484 29.1 KB

5

i did i really thank you so much

1 Like