Getting Error - "Invalid item in array cell: foreign record is invalid: foreignTableId is incorrect"

[vince_forte25]

I have three tables - deals, project, and a join table that connects deals and project. The deals table is connected to the project table through a linked field, creating a 1:1 relationship. I am trying to link the join table to the project table based on the linked field in the deals table. I am using the Airtable ID for the linked record from the deals table and inputting it into the "link to project" field in the join table, but I am encountering an error.

"Error: Field "fldxxxxxxxxx" cannot accept the provided value: invalid item in array cell: foreign record is invalid: foreignTableId is incorrect."

I'm getting the correct id for projectID field as I've double checked but still it is not getting linked to the "Link to projects" field. Please do let me know if more detail is required or if anyone has any solution to this?

[TheTimeSavingCo]

If you could provide a read-only invite link to a duplicated copy of your base with some example data I could take a look at this for you! https://support.airtable.com/docs/adding-a-base-collaborator#adding-a-base-collaborator-in-airtable

Seeing your tables and field setups as well as the automation trigger etc will be really helpful in trying to help you, and having the automation + code to work with directly will allow me to try to troubleshoot this directly and solve it without guesswork

[kuovonne]

Here are some troubleshooting tips for situations like this. 

- Use console.log() to display the values of the variables. Sometimes the right panel does not clearly show when values are arrays versus strings. 

- Try creating the new record with only one field value to identify which field/record ID is causing issues. 

- Search for the record IDs in the actual table itself. You may need to create a formula field that shows the record ID. Sometimes the record ID actually does not exist in the table, either because the record was deleted or because the record ID belongs in a different table.