Skip to main content
cathy wp22010330
Participating Frequently
October 11, 2017
Question

Field calculations

  • October 11, 2017
  • 2 replies
  • 353 views

I have a form that asks questions with different possible answers to click on. Now when the answer is checked i need to have that field to equal a certain number. Then these totals would be added up for a complete total.

For example: 1 question is:

What is your age?

____ (1) 56 and over

____ (2) 46-55

____ (3) 36-45

____ (4) 20-35

So if you chose 56 and over then that would equal 1 but if you chose 46-55 then it would equal 2. This field needs to be a text field i believe or a button but then the totals can calculate to a Sub Total from all questions.

Help

This topic has been closed for replies.

2 replies

cathy wp22010330
Participating Frequently
October 12, 2017

Thank you for responding.

Ok i know how to do that but how do i get those check boxes or radio buttons to equal a number. For example if i put a check box/radio button for age 56 and over how does the form know that when that box is chosen to calculate (1). See what i'm saying.

try67
Community Expert
Community Expert
October 11, 2017

You should use check-boxes or radio-buttons for this. That way you could set their export values to the desired numbers and use them directly in a calculation, and you would also prevent someone from selecting two fields at the same time.

cathy wp22010330
Participating Frequently
October 12, 2017

Thank you for responding.

Ok i know how to do that but how do i get those check boxes or radio buttons to equal a number. For example if i put a check box/radio button for age 56 and over how does the form know that when that box is chosen to calculate (1). See what i'm saying.

try67
Community Expert
Community Expert
October 12, 2017

Go to the field's Properties, Options tab, and set the value as the Export value, like this:

It has a slightly different name for a radio-button field, something like Radio Button Choice, but it's pretty much the same thing.