I want to make conditional questions in my ap...

(Joshua Giles) #1

I want to make conditional questions in my app. Meaning if someone answers “Yes” to question 1, an extra question (lets call it 1.5) would come up as a result that wouldn’t otherwise be there.

For example:

1.) Do you have a dog? Yes or No (User selects Yes)

1.5) What kind of dog do you have? (This question shouldn’t appear on the app if they answered no to the previous question)

2.) Do you have a cat? Yes or No (User selects No)

3.) Do you have a different kind of pet? (User selects Yes)

3.5.) What kind of pet do you have?

I’m working with Microsoft Excel as my source of the data.

(Jesse Prud'Homme) #2

You’ll want to use the “showif” field in your column structure.

Let’s assume question 1 column header is called “dog” and question 1.5 column header is called “dog type,” the showif formula for your “dog type” column would be: [dog]=“yes”

(Jesse Prud'Homme) #3

I edited the above reply - added a bit more detail.