Thanks Mary. I was able to get this to work fairly easy with just adding Slack notifications to Airtable then creating a channel for each of my status, then use the Slack connection with Integromat for the instant trigger.
However, now I face a new problem. My triggers (record status single select column in Airtable) get changed a lot and multiple at a time (copy & paste) to instigate the triggers and Integromats sends one record in view at a time (most recent) or all of them in the view (duplicates) on each trigger (depending what my max records setting is per trigger)
.
So far I believe the only real work around is to add another step to my status (ie. choose “Send Email” to initiate trigger in view, then choose “Email sent Pending Response” to remove from view).
I have tried to create a column in Airtable with number of seconds since last updated status change vs now(), then create filter in view which remove anything over 10 seconds old. However Airtable didn’t refresh fast enough and the last updated status time would be after now() time creating negative seconds :slightly_smiling_face:
Basically what i am trying to do is update the Airtable status (trigger) at anytime & multiple at a time (using copy & paste in Airtable), then send one email for each status changed. It is probably just a simple formula in integromat i need to add to send just the updated records in the view, but i cant figure it out :frowning:
