From a view , how to update another table record?

[PG_MASS]

Hello All,

I have a table named “Table1” where i add new record (fields: SKU, photo, description). NO ISSUE

when a new record is created, i create a new record in a table named “log”. NO ISSUE

Additionnally, when i have a new record in “table1” i would like to update a specific record in a table named “table2”: for the given SKU (same as the new record in table1), i would like to update in “table2” the value of the fields “photo” and “description”

I’m struggling to perform the last step (update a existing record in table2). I’ve tried task, bot,… with no luck.

Can someone have an idea about how to do ?

Thanks for your great help

BR

PG

[Pooja2]

Try LOOKUP Expression in Initial value it will help you

[Steve]

help.appsheet.com

Virtual Columns

Check out how you can use virtual columns to add more information to your app.