Hi i was creating a automation for notification when new row is added to a table. i have a column of status which is blank when new row is created. and i have used the following formula
- when > row changed > table name > any editable column
- then > notify > table.people > “text”
I get multiple notifications depending on number of rows in that table. There were 7 rows in the table and i got 7 notifications
Can anybody please advise me how do i make automation bot send only 1 notification. ( the automation is getting triggered only once but multiple notifications are sent. in the people column notification is turned off)