Showing or hiding repeats using conditional statements

Question

Hi,

My questions should be simple. However, I'm not the best at formulas. I'm building simple map gallery contest form.

Some people submit two or more submissions under one name. Therefore, the behavior I'm looking for is if the participant answers:

Do you have more than one submission?

Yes

No

If 'yes' then show repeats as many times as necessary.

If 'no' then just show repeat once.

Or, maybe there is a better way to show repeats. I'm welcoming any suggestion @JamesTedrick ,  @IsmaelChivite , and other GIS Super Heroes.

Thanks everyone - Jen

2022 GIA Map Gallery Submission.xlsx

KClarkDev_GIS · Accepted Answer

Hi Jen,

I took a look at your survey, and what I think would be the best thing to do is just have a set of dependent questions for each option (Yes/No). So your current repeat (rows 16-29) would have a dependency of ${more_than_one_submission} = 'yes'. Then you'd have the same questions, but not in a repeat. And all of those would have a dependency of ${more_than_one_submission} = 'no'.

Does that make sense/would that work for you regarding backend data processing?

Best,

Katherine

Jen_Zumbado-Hannibal · Accepted Answer

Sorry for the delay. This worked perfect! Thanks so much.