Trigger when a row is created... and filled

1

Hi guys,
I’m lost with something that it should be trivial.

I need to send a Slack notification when a new row is created. The notification test will include 2 row fields. (es.: “new request from customer : ”).
But, as Coda creates the row the moment we click on “new”, the notification sent is incomplete because aren’t filled in yet.
I tried to solve adding a column “trigger” that is filled via formula when the 2 fields are populated, but the automation can’t use a column with formula as trigger:
“Formula changes, edits to canvas columns, and comments will not trigger automations.”

What’s the best way to achieve this?

Thanks
Daniele

2

Hey @Daniele_B ,

  1. I use a form to create new rows - you can trigger the automation on new form submitted.
  2. Use your trigger column and have it set to true upon creating a new row. Then, run a time based automation to do the notifications for all rows with a true trigger and reset the trigger to false when done.

Sub 1) always works, Sub 2) can fail when the time based automation runs right around the time a new row is made and the two cells aren’t filled yet. You can solve that by skipping the rows where these two fields don’t have any content yet - it will trigger the next round.

For me, I don’t like work arounds, so I go for a form entry for new rows whenever I can. These forms can be embedded on a page in your doc and for me, that works OK. Of course, most forms are not embedded and they work fine.

3 Likes