I have a series of check boxes which have value that totals into a text field. I need several of these check boxes to have an On Value that is calculated based on what is entered by a user in a different text field. I want the check box On Value to be the sum of a different text field rather than an established/unchangeable value. Is this possible?
For instance, one of my checkboxes is miscunitsG
I would like its On Value to be the sum of unitsG (a text box)
I tried entering "sum (unitsG)" into the On Value under the Binding tab for miscunitsG, but that does not work.
I also need it to be possible for unitsG to have value but that my checkbox, miscunitsG, does not have any value unless it is checked on by the user.
Thanks for your help!
I'm not sure if this was the most efficient way to go about solving it, but it works in this form.