Automation based on new rows

Just the solution I need.

Do you mind walking through how you set up the “IsNewRow” column? How do you actually get it to be true when creating a new row?

To me it seems like a catch 22, since that is the exact thing we want to achieve. So am I missing a ‘secret’ trick somehow?

Thanks a lot in advance!

Hello @Maja_Overgard

Once you now, it is super easy:
image

In hindsight I would use a checkbox, but I implemented this when I was fairly new to Coda. The concept would be the same:

image
And the automation looks something like this:

The automation triggers only if the IsNewRow checkbox changes, which is only upon creation (because it is automatically filled upon creation and later this column is never used, so it never changes any more). It is advisable to hide this column, because it prevents mistakes (and for the automation it makes no difference).

Don’t forget to turn on your automation once you are done :slight_smile:
Success,
Greetings, Joost

3 Likes

Ahh of course!

Thank you so much @joost_mineur - much appreciated.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.