Discussions

Expand all | Collapse all

How to set up my app/tables for a complex survey

  • 1.  How to set up my app/tables for a complex survey

    Posted 03-14-2019 21:37
    Hi all,

    New to quickbase, though not to databases in general and I want to get started the right way.  My app is a series of four surveys.  Initially, I was assuming I would create each survey question as a field.  And a record would be a completed survey.  So each of my four tables would have survey question numbers as column headers and partner names as row headers.  Would this be the correct way to organize the data or is there something more effective?  If so, is there a way to create a report where I could select three partners and place those in three columns then the rows would be the question numbers and I could see the results vertically? I'm used to cross tab queries in access and haven't been able to make the paradigm shift yet, so any help would be greatly appreciated.


  • 2.  RE: How to set up my app/tables for a complex survey

    Posted 03-14-2019 21:52
    The problem with that approach is that it makes it more difficult to analyze the results by question.

    A better approach is to have each question be a child record to the survey and do the data entry in grid edit.

    The each discrete Question can be analyzed separately and for example easily ranked up by questions most happy or unhappy.

    The low tech way to get the child questions onto the Survey form is to use to create the 4 model Surveys each with its correct master Template questions.  Then use the wizard help to create a button to import those children into the survey.

    here is some help on how to do that.

    Then you can have 4 different buttons to import the 4 different sets of child records.  

    Then have a form rule to control which button to show depending on some drop down field of the survey type.  I also suggest hiding those buttons when there are already child records, so it does not get create automatically.

    It would also be possible to come up with a way to have the child records get auto created when the survey is first saved, but that's more advanced stuff. 




  • 3.  RE: How to set up my app/tables for a complex survey

    Posted 03-14-2019 22:00
    Thank you so much for your answer.  I think I see what you are saying. At one point you said "here is some help on how to do that" was there a link at that point?   For some reason, I am not seeing it.  Or perhaps I misunderstood?


  • 4.  RE: How to set up my app/tables for a complex survey



  • 5.  RE: How to set up my app/tables for a complex survey

    Posted 03-19-2019 16:03
    Hi!  I hope I can get a bit more help.   I'm stuck on this part: "data entry in grid edit" These surveys will be sent to our partners to characterize their sites, so I imagined data entry would be into a form that they would have access too via the web. I was happy how I was able to set this fairly complex form up from the initial table I described above but then came across your observation of it being "more difficult to analyze the results by question". If I "have each question be a child record to the survey" will I still be able to create my survey form for my partners?  This is the part I am working to figure out.  Any help or examples you can offer would be greatly appreciated.


  • 6.  RE: How to set up my app/tables for a complex survey

    Posted 03-19-2019 16:12


  • 7.  RE: How to set up my app/tables for a complex survey

    Posted 03-20-2019 00:34
    Well, there is a trade off here.

    If those filling out the survey are not familiar with Quick Base, then a traditional form may be best in your situation. Grid Edit is not as obvious and user friendly as a regular form.

    In addition, it does not sooid like your surveys have a lot of questions. That is also an argument for a traditional form.


  • 8.  RE: How to set up my app/tables for a complex survey

    Posted 03-20-2019 13:14
    But if I do a traditional form, what is the best way to create reports where I can filter, sort and create sums and averages for subsets of data, which are the reports that are being requested?


  • 9.  RE: How to set up my app/tables for a complex survey

    Posted 03-20-2019 13:53
    It depends how you want to slice your data. When you use a traditional form,, then each record is a survey and mot a discrete responses.

    I think that you should just build the traditional form , which is quick to do and enter some test data and see if you can get the reports that you want.

    You will be able to do summary reports which calculate averages of numeric values. If your questions do not have numeric rosiness, then you will need to use a formula for each response choice to convert it to some kind of score.

    It is also possible to create a process to push a button or perhaps on a schedule to copy the individual responses to a new table for more detail flexibility of analysis.


  • 10.  RE: How to set up my app/tables for a complex survey

    Posted 03-20-2019 13:58
    That last suggestion sounds really promising for me.  Would you happen to know if a sample app in the library that does something similar? Thank you so much for all your responses.  I really appreciate them.


  • 11.  RE: How to set up my app/tables for a complex survey

    Posted 03-20-2019 14:16
    I doubt there is an app in the exchange that breaks up a survey into its separate questions. But when you get to that point I can help you slowly on this forum or quickly on a one on one development session

    Mark Shnier
    QuickBaseCoach.com