From a view , how to update another table record?

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

Try LOOKUP Expression in Initial value it will help you

2 Likes
1 Like