Smartsheet Form - Hidden question

ktbsp
ktbsp ✭✭

Hello,

I would like to use a pre-filled URL that would select which school region question is shown (out of 4). I can get the first one fine, BUT the issue is that we have questions that say if they would like to add another child THEN ask that second school question. Because forms only offers OR statements, if I pre-fill the value as "Central", it will show the school for the second child regardless. Any assistance with hidden fields and multiple conditions from pre-filled urls?

This is how the form logic is set up β€” the pre-filled URL supplies the region for the hidden question

image.png

However, unless they select yes, I don't want them to see this part on the actual form.

image.png

Would love to hear all suggestions as the pre-filled urls would save us a ton of time but very disappointed about the lack of "and" logic in the forms.

Answers

  • SSFeatures
    SSFeatures ✭✭✭✭✭✭

    Hi @ktbsp, this is definitely a big limitation with forms at the moment.

    Would you be willing to up vote this feature request, and take a moment to post about this use case? This will help the Smartsheet team prioritize this feature higher.

    If it was possible to do an AND condition then your school forms would work perfectly.

    Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)

    SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: β€” Auto Sorting β€” Sorting with Filters β€” Report PDF Generation β€” Copy and Paste Conditional Formats β€” Copy and Paste Automation Workflows β€” Column Manager β€” and so many more.

  • ktbsp
    ktbsp ✭✭

    Darn, I was definitely hoping to find an AND originally! I have upvoted the request and appreciate your input.

  • SSFeatures
    SSFeatures ✭✭✭✭✭✭

    @ktbsp yea I really hope that they get to this one soon. There's a bunch of threads asking for "AND" conditions in the forms.

    You're welcome!

    Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)

    SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: β€” Auto Sorting β€” Sorting with Filters β€” Report PDF Generation β€” Copy and Paste Conditional Formats β€” Copy and Paste Automation Workflows β€” Column Manager β€” and so many more.