Hi, I found the way to update rows of antothe...

(Pierre Marceau) #1

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

(Steven Coile) #2

Not possible from the app itself.

(Jon Simmons) #3

@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.

(Pierre Marceau) #4

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.

(Bellave Jayaram) #5

You can also achieve this with a webhook and google apps script.

(Aleksi Alkio) #6

@Pierre_Marceau

This feature should be available by Q1/2019.