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.
Convert answers in form to numbers without nested IF statements
+35At 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:
- Creating formula fields.
- Writing a custom Javascript.
- Using an automation tool like Integromat.
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:
- Creating formula fields.
- Writing a custom Javascript.
- 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.