![zapier airtable slack integrations zapier airtable slack integrations](https://i0.wp.com/www.alphr.com/wp-content/uploads/2022/05/Zapier-and-Slack-Integration.png)
Check out Zapier's full list of supported apps. Using the Zapier ShipEngine integration, you can connect ShipEngine to apps like Slack, Airtable, Google Drive, Shopify, and more. You can automate data from one app to another and build powerful workflows without needing to know code or requesting time from your IT department. This now gives me access to the Record ID for the right “to be linked” record from the linking table.įor my final step (which is the Update), I used the linked table Record ID to populate the third linked field.Zapier is a workflow automation tool that allows you to connect thousands of apps together. I then added a new Zap step to search my linked table and used a Search Formula to find the right linked record using concatenated values from my prior step. Not sure if I really needed this or not, but I did it anyway lol. Created a new formula field that read from the Table’s primary field in a nice, text field that Zapier can use in a Find.Created a new formula field set to return Record ID.You have to pass it the actual Record ID from the linked table. Issue #2: Trying to Use these Values to Update the Third Linked FieldĪpparently, you can’t just put a text value into a linked field via an update. I named these with a “Zapier” prefix to easily distinguish from the original fields. To work around this, I created two new formula fields and set the formula to pull in the values from the Linked fields. When I tried to use these fields in the Zap, it became clear Airtable was passing the Linked Record ID versus the actual Field value. My first issue was reading in Linked Fields. I’m using the Slack notifications feature as an initial trigger and then wanted a Zap to go find and update the record that initiated the Slack notification. My scenario is that I was trying to take two linked fields, concatenate these together, and then use this calculated value to update a third linked field. It turns out I was doing multiple things wrong. I was able to figure this out and thought I would share my trials here so others can learn from my mistakes. But the update itself puts the record id into the field, which generates an error. I see the text value vs the actual ID value. When the Update step tries to update the Airtable record it’s putting the linked field id in the field vs the text value of the linked record.įrom my tests in the zap, everything before this last step looks fine. “Field A-Field B” I am reading this info using a search value from the Airtable find action step. I then have an Airtable update action where I am concatenating two fields into 1 linked field, separated by a dash.
![zapier airtable slack integrations zapier airtable slack integrations](https://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/4404129799447zapieraddtrigger.png)
I then have an Airtable Find action to find the relevant Airtable record using info from the Slack notification.Created a Zapier Zap to use a Slack notification as trigger.Turned on Slack notifications and am sending change notifications to a dedicated Slack channel.Zapier or Integromat).Īlso, as Airtable doesn’t support webhooks, I am doing the following: I am looking to update a linked field in an Airtable table automatically and recognize this can only be done via 3rd party integration currently (i.e.