Conditional branching without google forms?

Since I am not using google forms or google sheets is there another way to conditionally branch my form? For my company I am collection information on equipment, and need to skip a few questions and ask a few additional questions if the equipment is used on the road. I could do two different forms and tables I suppose but then I’d need to merge them at some point.

0 2 1,047
2 REPLIES 2

No need for two forms. Use the “Show_If” property in the fields that conditionally show. Then tie those to the result of “Used on Road?”.

For the fields to show when Not used on the road, the “Show_If” expression might be something like "[Used on Road?] = “FALSE” or you could also use “NOT([Used on Road])”.

Fields that are required when used on road would have an expression in Show_If that is opposite.

A couple notes:

  1. Yes/No type columns ALWAYS record the values “TRUE”/“FALSE” as the result in the data BUT you can test using “Yes”/“No” or “True”/“False”, etc.
  2. A Yes/No field with no value is treated as “FALSE”.

Hope this helps!

Thanks, that helps a lot! I tried it on both regular columns and “Page” definition columns and it works on both.

Top Labels in this Space