Failed to find or create a record in Airtable

Hi @Alan Rooney 

For us to have more context about the error, post screenshots showing how your Zap steps are outlined and configured in EDIT mode.

Sure thing is this what you need?
 

@Alan Rooney

For Airtable, if the primary key field is a formula, then a mapped variable value must exactly match an existing value.

https://support.airtable.com/docs/the-primary-field

https://support.airtable.com/docs/using-formulas-in-airtables-primary-field

‘’Failed to find or create a record in Airtable The app returned "Value "test@gmail.com" is not a valid record ID. Could not find record with matching name and we can not create linked records because their primary field is computed".

Thanks for your answer Troy. I’m a bit of a noob when it comes to airtable. Can you let me know what I need to do in zapier to fix this issue?

Thanks so much. 

-Alan

@Alan Rooney 

Post screenshots from Airtable showing the left most field (primary key) in the Table being used, so we can see the Field label and field type (icon).

Hey @Alan Rooney 👋

Just wanted to check in here to see how you’re getting on. Were you since able to get this sorted?

If so we’d love it if you could share details of how you fixed that error so that others in the Community can benefit from your experience! 🙂

And if not, just send over a screenshot showing the primary key in Airtable as Troy mentioned we’ll be happy to assist further.

Thanks, looking forward to your reply!