Add same data to a different table

[edmund_chan]

I am trying to duplicate data updated in one (edits only) table to another table. From my limited knowledge, it seems that webhook is the way to do it. However, for the table that I need the data to be duplicated to, it seems that I need a key for this to work. But I don’t need the key for this table to work. The reason why I need to duplicate the data to this table is so that I contain the formulas related to the data all inside the same sheet. Hope the very responsive and on point AppSheet community can help in this

[Aleksi]

You can copy the record with an action as well. Please check the action option “Add a new row to another table using values from this row.”.

[edmund_chan]

Thank you Aleksi I have just tried it using Action and it works when I press the add data icon. However, I need it to be executed whenever the data is sync-ed. Tried to do this as an Events Action but there is no option for it (see screen print, circled in green). I am using Deck view, with quick edits and inline view for already. How can I automate the Action whenever data is sync-ed?

[edmund_chan · Accepted solution]

I managed to solve it through a workflow! thank you so much @Aleksi for helping on this

[Aleksi]

You’re welcome

[Aleksi]

The challenge is that when you modify the data directly from the detail view/quick edit, it doesn’t trigger the event action from the Form_View (the form view is not opened). Meaning… you need to trigger that action with the Workflow/Data change.