I have a form I'm trying to create and I'm trying to figure out a piece of conditional logic. If answer A = Yes, Go to Section 2 If answer A = No, Submit form. Within Section 2, if they get there, there are questions that are required, so, I marked them as required. Problem I'm running into is if they answer No. Since I marked the questions in Section 2 as required, it is still requiring them to answer those questions. How can I force them to answer questions in Section 2 if they answered Yes to the initial question, but, allow them to submit the form without answering those questions in Section 2 if they answered No?
Doesn't have to be a first world problem. Do you plan on getting soup at the local homeless shelter? If no, cool. If yes, do you promise not to sue if you choke on a chicken bone? If the answer is no, they shouldn't be presented with the question of whether or not they promise not to sue. If the answer is yes, then they have to answer yes or no.
Just add "Does Not Apply" as an option in section 2 geezus h krist do I have to do everything around here??
I over simplified it for the example. There will be 15 additional questions that will need to be answered if they go to section 2 and then have to acknowledge a bunch of terms and conditions. Trying to get them to not have to check 'Does not apply' 16 times.
Google Forms is really a third world option in a first world business environment, so that works. You should just pay for Smartsheets so you can have that lack of functionality with a smug sense of satisfaction from paying extra for it. Sorry, I hate G Suite. I'm sure someone can explain how to do it, but in my environment, we have to have special IT permission to use scripting, and they won't give it to me.
Here’s an eye dear “If No, then ‘DNA’ questions 1-15 sheet two”, make DNA a hidden field and go drink a beer?
I don't know how to link to a different sheet...only to a different section. If you have questions marked 'required', then they are required regardless of what section you go to.
Well I’m beyond my pay grade now. Been a lotta years since I futzed with FileMaker Pro, the unrelational database