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