How to make one field populate a number based on another field saying yes or no?

Question

I am currently in a pickle. I have a field that someone writes either "yes" or "no". I want to be able to have another field populate with a number based on the yes or no field. For example:

"Field1" is the field where someone types "yes" or "no". if someone puts "yes", I would like to have "Field2" populate with a number 1. If they say no, I want "Field2" to populate with a 0.

gkaiseril · Answer

Forms require some planning. What if the person enters :Yes", "No", "YES", or "NO"?

How are you going to handle misspellings?

What if there has been no entry?

I would use a drop down list and that would only allow for a given set of values to chose from. Also you can set the value of the drop down field by the optional value for the item selected.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded