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. Zapier or Integromat).
Also, as Airtable doesn’t support webhooks, I am doing the following:
- Turned on Slack notifications and am sending change notifications to a dedicated Slack channel
- Created a Zapier Zap to use a Slack notification as trigger
- I then have an Airtable Find action to find the relevant Airtable record using info from the Slack notification
- I then have an Airtable update action where I am concatenating two fields into 1 linked field, separated by a dash. “Field A-Field B” I am reading this info using a search value from the Airtable find action step.
It’s working fine with one issue. 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.
From my tests in the zap, everything before this last step looks fine. I see the text value vs the actual ID value. But the update itself puts the record id into the field, which generates an error.
Any help much appreciated!