I’m running into an issue while trying to set up an Airtable automation that links records across two synced tables, but I’m getting the following error
Invalid filter on field A (Invalid filter value: [ { "linkedRecordId": "rec0hJCM2U7BBdWWa", "value": { "id": "recvaxWZ99uQ8cYia", "name": "12345678" } } ])
I'm trying to locate a field value in Table 1 with Table 2 using Find Records, and then link the records via the Automation.
Setup Trigger (Table 2) > Find Record (Table 1) > Update Record (Table 2)
I have done almost the same type of Automation in another base (which is working fine) and the only difference is I am now working with 2 synced tables in Find Records - in the previous one i created it was comparing synced with source/original table
I've tried adjusting field setups (in source as well) for both tables: Sync linked, string fields, lookups, used Trim function
I continue to get filter errors
I can only assume it's because Airtable doesn't like that both tables are synced?
I have done almost the same type of Automation in another base (which is working fine) and the only difference is I am now working with 2 synced tables in Find Records - in the previous one i created it was comparing synced with source/original table
I've tried adjusting field setups (in source as well) for both tables: Sync linked, string fields, lookups, used Trim function
I continue to get filter errors
I can only assume it's because Airtable doesn't like that both tables are synced?
Am I possibly missing something key to get this working?
