Hi community. I really need some guidance on my data structure please.
I'm building an app to do a health assessment. I have a legacy paper form full of check boxes. It is 3 pages long, comprising 28 categories with anywhere from 3 to 12 check boxes in each category. Multiple check boxes can be selected in each category.
What I want to do is record an assessment to cover all these check boxes. Currently I also want to record the person's name, date of the assessment, and their email address.
In a seperate table I want to associate detail related to each check box in the form. A title, short summary, long detail text, and an image.
With this data I want to be able to see the results of the assessment, showing either an on screen report or a PDF showing the results from the items that were "Checked" and the resulting detail.
I started creating the assessment form, manually creating the categories and using an enum list, but I didn't know how to connect those results to my details table, and hence generate the report.
Anyone fancy giving me a few pointers please?
Cheers - Kev
Solved! Go to Solution.
You probably need a new table as a child table that references the main table, where the user would create a new record per checkbox.
https://help.appsheet.com/en/articles/961426-references-between-tables
You probably need a new table as a child table that references the main table, where the user would create a new record per checkbox.
https://help.appsheet.com/en/articles/961426-references-between-tables
User | Count |
---|---|
32 | |
30 | |
30 | |
18 | |
16 |