My form has fields for purchasers to tell me how long they do an activity each day and then has tiered pricing based on the number of hours of activity they do each week. Right now I have the purchaser complete the daily activity fields and then choose the pricing option that matches to their weekly hours (so they have to do the calculation themselves). Is there a way to instead attach values to the daily activity fields, which would then calculate the weekly amount, and put the purchaser into the correct pricing tier automatically?
Example: Purchaser chooses Monday: 1hr (value = 1), Tuesday: 30min (value = 0.5), Wednesday 90min (value = 1.5), Thursday 2hrs (value = 2), Nothing Friday, Saturday, Sunday, This would calculate to 5 and would put the purchaser in the pricing tier of 5-7.
Thanks!
Alex