I am looking to gather supplemental information as part of the Form entry process.
When the user answers yes to a certain control-question, they need to answer 10 more questions.
Although I could use conditional logic, to present the subsequent 10 questions, in this case and I do not want to clutter the main form, or main sheet with this information as it is used only a small percentage of the time.
Plus when I send alerts or update requests, these 10 extra columns would show (short of duplicating all of the Automations and building logic to send versions without the extra 10 questions, most of the time)
Was thinking instead to:
- Via helpful text, or by imbedding an (intranet) URL in a column, direct them to the (intranet) URL when they answered yes to the control-question.
- Once on the (intranet) URL site they would find instructions on how to download an excel or word object. That (excel) object would have the extra 10 questions.
- They would answer the 10 questions, save the questionnaire, return to the main Form and attach it to the main Form before they finish the Submission.
I know it's a round-about solution, so if there are better suggestions, I am very grateful to hear them.
Regards,
Dave