Expand my Community achievements bar.

SOLVED

How do I add values from multiple fields

Avatar

Level 3

I would think this is simple but I'm not seeing how to do it. I have 5 or 6 different user entered dollar values that I need to calculate a total for.

Example

1 Cleaning Fee  $10.00

2 Security Deposit  $10.00

3 Pet Deposit $10.00

4 Total Rent $70.00

5 Total $100.00

So a user would enter values for 1 -4 and it would calculate the total in field 5. It would awesome if a user left a field blank if it would assume $0.00. I am assuming script somehow but am looking for a little guidance? Thanks all...

1 Accepted Solution

Avatar

Correct answer by
Level 3

Greetings,

Place this inside the calculate event of the total field option using FormCal

yourfieldname + yourfieldname + yourfieldname + yourfieldname

Here is a link to a form that has an example of the addition:

http://www.shingleme.com/AdditionTest.pdf

Justin

View solution in original post

2 Replies

Avatar

Correct answer by
Level 3

Greetings,

Place this inside the calculate event of the total field option using FormCal

yourfieldname + yourfieldname + yourfieldname + yourfieldname

Here is a link to a form that has an example of the addition:

http://www.shingleme.com/AdditionTest.pdf

Justin

Avatar

Level 3

Awesome, worked like magic, thanks!