How to calculate the value of a field based on another field
I am creating a fairly basic registration form. Users can select multiple sessions throughout the week. What I need to do is allow them to select their sessions, and then have the form display the total cost. In Excel I can have the users enter an "X" in the appropriate cell, then create another cell that says "if A1 = "X", then A2 = $500. I then hide A2 and have another cell display the total of A2, B2, C2, etc.
In Adobe, it seems that I can have a text field with the value of $500 for each session which the user can select, and then have a total field that addes up all the session fields to display the total cost. This works, but is not pretty to look at. It would be better/nicer to have a check box for each session and then have a total field that displayed the amount based on the number of check boxes that were checked.
It seems like this is something that has been done before, but I can't find a good solution. Any and all help is appreciated!
