Insert data into mysql autoincrement field

Hi @garybrett17 

For us to have more context, we would need to see screenshots of the encountered error along with how your Zap steps are outlined and configured in EDIT mode to see the field types and field descriptions.

Hi @Troy Tessalone,

I dived into this a bit deeper and it may not actually be the field I assumed. It now appears the issue is with how Zapier are creating the json file. (according to Sprintful)

In my Sprintful form, I have a custom field called ‘PostCode’, when I check the steps in Zapier, the data its collecting seems to be a merge of all data as below. This means I am unable to extract the custom field data from Sprintful. The NW7 2QD from below is the value it should collect and pass to mysql but it tries to insert all this data which is where the error lies.

test.user@rbht.nhs.uk,testuser,NW7 2QD,Yes,true,true,inline,google-ads,nhs-workers,first homes scheme nhs,1*14qvjeu*_up*MQ..,EAIaIQobChMIse6gp53OhQMVaZRQBh1ZKgSuEAAYASAAEgJ8LvD_BwE

 

@garybrett17 

Check this related guide for how to convert the Q&A arrays to individual fields that you can map.

• GUIDE: Parse Calendly Questions & Answers (Line Items) with Formatter and Code to Use as Custom Variables