Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Convert answers in form to numbers without nested IF statements

Topic Labels: Formulas
1036 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Richie_Siegel
5 - Automation Enthusiast
5 - Automation Enthusiast

I have an Airtable form that has a number of yes/no questions on it. I want to convert the Yes’s to 1s and no to 0s.

Is there an easy way to declare Yes=1 without having to write as many IF statements as I have questions?

Appreciate your help.

2 Replies 2

At the form level (before the form is submitted), this is only possible with JotForm:

Otherwise, you could also accomplish this after the form is submitted in Airtable by:

  1. Creating formula fields.
  2. Writing a custom Javascript.
  3. Using an automation tool like Integromat.

@ScottWorld Thanks for your help. I was able to write 12 nested IF statements to do this but that is clunky. I assume I could write a script in the future that does this.