But you don't need any script to do it, actually. All you need to do is apply a numeric "export value" to your check-boxes and then you could use the built-in Sum calculation option in your text field to sum them all up.
To apply this export value right-click a check-box (in Form Edit mode) and select Properties - Options and you'll see it there.
Then go to the total field's Properties - Calculation and select "Value is the (sum) of..." and then select the check-boxes (or text fields) from the list.
That should do it, pretty much.
See, I told you in the title that this was "for dummies!" Thank you for your help! I'm going to give that a try and let you know but it seems easy enough to do. Thank you for your help!!!
Okay, try67 I tried to do what you asked, but this is what I see in the "options" tab in the checkbox properties:
From here it just gives me options to choose which kind of check I want in the box. There are no calculation options like there are in the textbox areas. am I looking at the wrong thing?
The calculation options are in the text field. In this screen you only need to set the Export Value to the amount this check-box represents.
Okay, I get it now. Whew...it's tough dealing with noobs (me). I'm sorry. Thank you for your help! I think that worked!
Okay, so the calculation works, however, it does not calculate based on what is checked, it just adds up the value of the checkboxes and stays that way (regardless if they are checked or unchecked.)
I'm thinking that simple isn't going to work for what I want, much to my chagrin.
Here is a breakdown of what I need exactly (another problem added since working on this...sorry):
When the customer selects the checkbox, that value is added to other selected checkbox values in the "Rental fee balance due" box. this box should calculate all of those values and subtract (I know, curveball) the "Deposit" box above it from the total. The total rental at the bottom should calculate the Deposit, Rental fee Balance, Additional services, and Cleaning fee boxes. (that part I can do).
Sorry to keep going back and forth, but as soon as I think something works, then it doesn't again... thanks for your help!
Okay, after further review it does work in the calculations. Now I just need to figure out how to subtract the deposit amount...But everything else worked as you said!! Thank you!!
Okay, here is how I accomplished my task in a simple way with try67's help:
I placed a value on each checkbox as needed. Then I used the "Value is - sum" calculation to add up all that was selected for the RentalFee text box. I hid that box. I placed another text box over the RentalFee box and labled it BalminusDep. I used the Simplified Field Notation to Subtract the RentalFee box value with the Deposit value and then set the calculation order to "RentalFee/BalminusDep/Rentaltotal" to total up all the fees. The Rental total box just adds up all of the fees. It now works exactly how I wanted it! Thank you try67!! I really appreciate your help!!!