Two questions about Automations:
- I have a record in a table that is linked to multiple records in another table. I have a trigger set up that triggers when a record in table A matches a certain condition. This works fine.
As the action, I wish it to update all records that a linked to the triggering record. This works when only a single record is linked in table B but fails when there are multiple. How can this be resolved?
- I have an Automation set up to send a Slack message to a channel when a new record is added to a table. This works fine when the record is added via a form as all the data in the fields is added at the same time. However, when a new record is added in Grid view, the automation triggers as soon as I tab away from adding data in the first field of the record. This causes a Slack message to be sent with missing data. Eg: “A new invoice for “” has been added with the cost: “”.”, rather than something like “A new invoice for “McDonalds” has been added with the cost: “99p”.”.
I really hope there are solutions to both of these.