I figured out how to set a drop down box with captions and values. However, I can't figure out how to add the values together.
For example:
Registration
Type: Text
List Of Values: Member - $25|25;Non-Member - $50|50;Student - $0|0
Drop-down list
Lunch
Type: Text
List of Values: No lunch - $0|0;Vegetarian - $10|10;Chicken - $10|10;Beef - $12|12
Drop-down list
Now, let's say I want a column with Total Due.
For example, the calculated column for someone who selects Member and Vegetarian should have a total of $35
Someone who selects Student and Beef should have a total of $12
I've tried numerous combinations of hidden columns but can't get anything to work.
My questions are:
1. How do I add up [Registration].value+[Lunch].value? I've tried [Registration+_UDT_Value] and [Registration]+_UDT_Value and [Registration_UDT_Value] and various other combinations but can't seem to get the right syntax. Any help with syntax?
2. When I have a Value defined, the form shows the caption, but the list shows the value after an item has been submitted. If both the chicken lunch and the vegetarian lunch cost the same... how do I know which is which? Can I only use the hidden columns for the calculated column, and display the caption in the list?
3. As noted in #2 above, the values are actually displayed in the list rather than the captions. The captions would be the desired display. Youo would think this would make it easier to add up the columns. However, when I add up [Registration]+[Lunch] in a calculated column... even if integer is selected.. I get the 2 sets of numbers in a string; rather than the sum. For example, Member ($25) plus Beef ($12) results as $2512 rather than $37
Thanks for any help with syntax and setup!