Forum Discussion

RyanWhitener's avatar
RyanWhitener
Qrew Cadet
7 years ago

Webhooks to take you directly to another table based on your response in a table.

I am a new users and looking to create what I think is a difficult app. But struggling on where to start.... I am trying to create a safety questionnaire app.  The questionnaire has about 30 questions. But some questions, depending on how they are answered may require a second set of questions to be filled out. Meaning total I have could have around 10 "sets" of questions to be be answered. I will also have to include a spot for signature and some relationships based on employees and job numbers, but I think I can figure that out. 

What I am most worried about is do I create (1) LARGE table that has all sets of questions involved and hide headers based on how the question was answered? OR do I need to setup all of these "sets" of questions as different tables? If this is the case, how to I have a questions redirect you to a different table to be filled out, completed, and then return you back to the 1st table to finish the questions.

Again, I am a new user and might be overthinking this whole thing.

Thank for the help
App builders
Forms
Formulas and functions
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Based on your description and the fact that you will not know how the user will answer the questions until they answer them I suggest the straight forward brute force method. 

    Each question will be a separate field and you will use Dynamic Form rules to show or hide Sections or possibly Tabs.
  • EvanMartinez's avatar
    EvanMartinez
    Quickbase Staff
    7 years ago
    Hi Ryan,

    Based on your question I would agree with Mark that a lot of builders accomplish what you are looking for by making use of Form Rules. They allow you to set up logic on your form so that fields are shown or hidden based upon other decisions. Rules like if "Review Needed" is checked then show "Reviewer Request" section with several fields to indicate who needs to review the record that would otherwise remain hidden if no review was needed can be set up using Form rules. As a new builder you may want to check out our help documentation on Form Rules to get you started here. 

    Our University also has a lesson on Building User Friendly Forms that includes a section on creating form rules that you can be found here. 

    I hope these resources are helpful Ryan and thank you very much for time today.
  • RyanWhitener's avatar
    RyanWhitener
    Qrew Cadet
    7 years ago
    Thanks, yes I have watch/complete most of the QB university videos. Like I saw I was just having difficulties wrapping my mind around if each of those needed to be tables or if it should all be wrapped up in one. Again thanks for yals help. I do have another question about relationships/look up fields, I will post it as a separate topic though.