Seeking some assistance or clarification on the Airtable to slack integration. I’ve setup a view in Airtable that is supposed to push messages to a channel in slack when a record in that view is updated. I use the slack message to trigger a scenario in Integromat.
In that watched view, I have a Lookup field which references my main table. That field is populated when certain conditions in the main table are met. However, the Lookup field becoming populated in the watched view doesn’t appear to trigger the slack message. I tried adding a formula field in the watched view that is equal to the Lookup field and is also populated when the required conditions are met in my main table. Again, though, the formula field becoming automatically populated does not appear to be an ‘update’ that triggers the slack message integration.
So, is it only manual updates that trigger the Airtable to slack notification? Am I missing something?
Many thanks for any comments.
For those that might be interested, after a fair bit of testing, it seems Airtable to slack notifications are not triggered by updates to computed fields (like formula, lookup, count, and rollup). Accordingly, only manually updated, non-computed fields will trigger the slack notification. If anyone finds otherwise, please let me know.
It might be that you’re experiencing the same issues I had with the records visible in a view trigger. Only manual updates trigger slack notifications. If your slack triggering ‘view’ only has computed fields e.g. a lookup to another table, then changes in the other table do not trigger slack notifications in the view even though the lookup field for a particular record changes.
In my scenario, I wanted to auto trigger generation of an email when a lookup field of a record in a view changed upon changing of the corresponding record in another table. In the end, my workaround was to add a new checkbox field in the view being monitored for slack notifications so that when I mark the checkbox to generate the email this is registered as a manual update that triggers the slack notification which then triggers my integromat scenario.
Hope that makes sense and/or helps.