Skip to main content
Solved

Removing "Other" free form survey responses from multi-select field

  • February 4, 2022
  • 4 replies
  • 39 views
D
Forum|alt.badge.img+5

Hello!

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.

Best answer by Devan_Kreitzer

I don’t know of a way to do it natively in Airtable, but maybe others do! My guess is that it would involve scripting and accessing the metadata API.


Thanks for your help! Actually got everyone onboard to just use a separate Other field, so all worked out lol

4 replies

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • February 5, 2022

2025 Update:

This is possible with Fillout’s advanced forms for Airtable.

Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, display Airtable lookup fields on forms, control access to a form via SSO or email domains, perform math or other live calculations on your forms, accept payments on forms, collect signatures on a form, create multi-page forms with conditional paths, create new linked records on a form, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

kuovonne
D
Forum|alt.badge.img+5
  • Devan_Kreitzer
  • Author
  • Inspiring
  • February 5, 2022

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.


I can propose it, but I have a strong feeling it’d be pushed against since we’ve already gone through coordinator approvals and translations.

Any suggestions on how I might be able to do what I need in Airtable? Honestly, thanks so much for the help!!

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • February 5, 2022

2025 Update:

Airtable now offers conditional visibility on forms, if you have a Business Plan or higher.

- ScottWorld, Expert Airtable Consultant

D
Forum|alt.badge.img+5
  • Devan_Kreitzer
  • Author
  • Inspiring
  • Answer
  • February 11, 2022

I don’t know of a way to do it natively in Airtable, but maybe others do! My guess is that it would involve scripting and accessing the metadata API.


Thanks for your help! Actually got everyone onboard to just use a separate Other field, so all worked out lol

kuovonne
Terms & ConditionsAccessibility statement