Hi, I found the way to update rows of antother table based on an action. However I don’t find how to add multiple rows in another table based on an action. To give you an exemple:
https://docs.google.com/spreadsheets/d/1gn42DI0WkABROJdl6FQgXbYzJkCmvlbIw9raK5ypqrE/edit#gid=0
When I add a record in the Company table, I want that it adds as many rows as we have different editors in the Editor Tabs (meaning 2 rows, one for each editor)
How can I realise that please?
Thank you
Not possible from the app itself.
@Pierre_Marceau i would experiment a little bit with webhooks + Zapier / Integromat. I think it’s possible with a bit of work.
When a new record is added it would trigger a workflow in those systems that could in hand “add” the necessary rows.
Just a thought - maybe there’s a better solution out there.
Too bad, thank you for your answers. I will try to create a lot of entries in advance with a linked formula and in fact let the users edit the values instead of create them through an action.
You can also achieve this with a webhook and google apps script.
@Pierre_Marceau
This feature should be available by Q1/2019.