I have a zap setup that searches an address field and creates a new record if the address doesn’t exist. It works perfectly, unless there is a comma in the address text field.
For example, I currently have a new record with a street address of: 555 Street, Apt 5b
Here is the error I receive in Zapier when I try to run the zap for this record:
There was an error with Airtable: The app returned “Value “555 Street” 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”. This can occur if the information entered into a field is not in the correct format. Double-check that you are using the correct format for entering values into a field. We made a request to api.airtable. com and received (422) Unprocessable Entity.
Why does this happen and how do I fix this?