I have a base and different tables. I am working on scenario in Make.com. the logic is watch records ( rsvp table), get a record from ( rsvp table), get a record from presentation Topic, search records( Summit speaker), update Summit Speakers, zoho email, search records( affiliate interest) and then update affiliate interest. When I use id it gives me 200 but no field updated it is clear but when I map data from watch records and get a record (rsvp) to update affiliate interest I get an error 422 it says can not fine such collum. But all collums are there, cache was cleaned, reconnecting was done, tried upsert module. Nothing helps I think problem somewhere in Airtable but where? Will be glad to hear any suggestions? Thanks for help.
Question
error 422
+2
+9Hi
Hard to say without seeing your tables but if the 422 says the field to update can’t be found but you say it’s there are you updating the correct table?
+2Thanks. I have checked double times. I get data from form submissions to rsvp table and want to update affiliate interest table. The same base different tables. When I taste with id from rsvp it is 200 but it doesn’t matter what collum I should update name email etc. I get 422 collum not found have tried to do everything possible but something is wrong.
+9And you can’t use an automation instead?
+2To my regret no because it is for a client there are some modules from convertkit so I need to find out what is wrong. I contacted make support they checked everything and tolme that something wrong in airtable
+9Sorry mate. It’s hard for me to help without being able to see stuff. Have you tried running a test with the Make scenario in a simple setup just to make sure you can write to Airtable? Even create a test table with one field
+2That is the problem I have created one test name collum and trying to map a name it gives an error. Can it be because wrong linking or primary fields. Get stuck in it
+9Do you use Google chat? Or Teams? My email is j@jameshuggins.uk Drip me a line just so we can use a better comms system :)
+2Where are you from? Can we do in the evening because I am not at home and writing you from phone. I can send you a scenario for you to take a look if you want and have time. Thanks
+9Based in the UK. Sure thing. Happy to take a look.
+31Ha I’ve had this issue before. For me it was because I was trying to update a record that didn’t exist; Airtable returns ‘field not found’ instead of ‘record not found’, so that was very confusing
No idea if you’re having the same issue but figured I’d let you know!
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.