I have a Jotform survey automatically going into Airtable. Some of the questions have “Check all that apply” with an “Other” response that prompts a free form answer. These free form responses are being added as multi-select option in Airtable (rightfully so). I’m trying to do an Airtable Interface on the survey responses but, obviously, those free form responses are being considered.
In a column, I want the options and replacing the free form response with “Other”. Then in a separate column track the free form response (just so that data isn’t lost). Any ideas?
This is essentially what I’m trying to do:
The “Name” and “Q1 Answers” field is the only thing imported with survey responses.
Solved! Go to Solution.
I would probably tackle this on the JotForm side.
Instead of using JotForm’s “Other” functionality, I would type in the actual word “Other” for that question.
Then, create a completely separate field in JotForm that asks people to type in their other answer there. That could even be a conditional field that only shows up if “Other” is selected.
Then you’ll have all the information separated properly before it even gets to Airtable.