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

Slack Signup
Newsletter Optin
Help Desk

Spreadsheet-like customization of a form

Labels

This Discussion is public

Notifications

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!!


Attachment:

Discussion closed.