Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
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.
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.
LisaSchibley
7 years agoQrew Cadet
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.