I have been troubleshooting this for hours. This is an automation that used to work and suddenly it no longer does.
I have an automation, triggered by a button, It’s a simple form submission and the button triggers the creation of various new records in different tables. Many of these records are linked. The Links are written by the automation.
All of this works great. But for the last of the records, that is supposed to be created, it does not. The records IS created, however the linked records are not connected. I am linking to records that were created in earlier steps. And linking these records in the earlier steps was no problem.
I do not get error messages or anything. The link simply does not get written.
If you want to link to a record by record name, the name needs to be the same. What’s the primary field in the table you’re linking to? Is it maybe calculated (aka a formula field)?
Why don’t you just pass the record id of the record in an earlier step?
In this example, the record passed was also created in a step before and I simply took the record id.
All in all, my guess is that you’re passing a name that doesn’t exist in the table you’re referencing.
RECORD NAME is the primary field of the table.
I am doing the exact same thing all over the place. In an earlier step I am doing the exact same thing with the exact same CONTACTS table. I am writing the RECORD NAME field to the CONTACT RECORD link field. This exact same scenario is working in at least 3 dozen automations but all of a sudden it isn’t working here.
Other ideas I would have and try to troubleshoot:
Are you testing your entire automation? If you’re only testing partially, the record from earlier might not exist anymore (as you might have deleted the record since it was only created for testing purposes).
For me it feels dangerous to pass a formula field as a primary field identifier. I’m usually working in Airtable scripts and I would always go for record ids as they’re definitely unique (whereas you could have two people with the same name for instance). So that is something I would look into as well. There is no reason to pass the name here, you could simply take the record id from the earlier step.
My guess is that you’re not testing the entire automation from start to finish (so whatever you’re referencing here doesn’t exist anymore).
Either the record doesn’t exist at all or the name simply doesn’t match (please check what you’re searching for and see whether it exists as a name).
Please also see an earlier thread on this exact error message: Automation Giving Error "Could not find matching rows for string" and also not pulling all fields sp...
I am. From head to toe. And it also does not work, when actually running the automation.
I hear all of your answers but they still make no sense to me as EXACTLY the same scenario works without problems in at least a dozen different automations across my bases.
The other ERROR MESSAGE I got before is that the field can not accept the data provided. This happens when I try to write the Record ID instead of the NAME.