The Community forums are being phased out in favor of a new Slack group.
Add your email address below to get an invitation to join the community slack group
Spreadsheet-like customization of a form
We need to create a form that behaves like a spreadsheet with =SUM() between rows and columns. A nutritionist is sending this form to their client.
Here's an example, and you'll also find a screenshot attached.
Client’s questionnaire:
Questions 1 (choice between 0, 1, 2, or 3): 2
Question 2 (choice between 0, 1, 2, or 3): 3
Question 3 (choice between 0, 1, 2, or 3): 0
Question 4 (choice between 0, 1, 2, or 3): 1
Nutritionist’s report (totals below):
A: 2
B: 4
C: 0
D: 3
E: 1
What is happening in the background:
A B C D E
Q1: 2 X X 2 X
Q2: X 3 X X X
Q3: 0 0 0 X X
Q4: X 1 X 1 1
Totals: 2 4 0 3 1
About the attachment:
The first tab contains a list of symptoms (copied into column A here). People rank the occurrence of these symptoms from 0 to 3. This result is copied into columns B to K. Black boxes don’t contain any numbers.
Then, the spreadsheet calculates the totals for the columns B to K (simple =SUM() operation). Each column corresponds to a system within the body (see A72-76 and beyond). The results indicate which bodily system need the most work.
To sum it up, a client rates symptoms on a scale from 0 to 3, and the nutritionist receives the body system results once the form is submitted.
Please let me know if these are calculations that Formidable can accomplish!!
Discussion closed.