Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 18, 2024 05:27 PM
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?
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 18, 2024 07:10 PM
Could you provide screenshots of your tables and automation setup? If you could provide access to an example base that'd be best, as that would let us help you troubleshoot easily without needing to create your setup!
