I’m wondering if it’s possible in Make to setup dynamic field mapping to Airtable, based upon the incoming Field ID/Name? This would be instead of pre-mapping out every single field.
All of our fields in Jotform follow the format “<airtable_table>_<airtable_fieldname>”. We had custom code running in AWS doing the mapping, and have since moved it to Zapier. Now looking at using Make, but only if we could do it dynamically, without having to write and maintain custom javascript. I know we could do it that way in Zapier, but trying to build a simple solution that my client to maintain.
I didn’t see anything obvious, but thought I’d check.
This would be a little tricky to setup in Make, but you should be able to do it by custom-writing your own API call to Airtable with Make’s HTTP module.
But first, you’d have to first structure the proper JSON to put in the body of your API call.
Are all the fields coming in from JotForm as an array?
If so, you could use Make’s iterator module to loop through the array, which would break up each key-value pair for you to use.
Then, after that, you would have to create your own API call to Airtable that would use each key-value pair as the “variables” that you send to Airtable.