I am working on a registration form and need to apply a discount if two particular checkboxes are selected.
Checkbox #1 – Early registration = $1595
Checkbox #2 – Standard registration = $1795
Checkbox #3 – Special rate = $495
Checkbox #4 – Optional workshop = $395
Numeric Field – Total Payment Due
If the user selects checkbox #1 (early) or #2 (standard), they have to pay the $395 for the optional workshop.
Total box =
sum (EarlyReg, StandardReg, SpecReg, WorkshopReg) <-- THIS WORKS
If the user selects BOTH checkbox #3 (special registration rate) AND checkbox #4 (optional workshop), they do not pay for the workshop.
So instead of $890, they will pay $495.
Total box =
?????
I welcome any ideas you may have and would love to hear if you think I'm going at this in the wrong direction.
I am new to this...would appreciate a step-by-step with syntax. Thanks!
Solved! Go to Solution.
Views
Replies
Total Likes
TundraSteve, Thanks for the reply.
Your suggestion got me on the right path. Here's what worked using FormCalc on the TotalDue field:
if (SpecReg + WorkshopReg == 890) then
SpecReg
else
sum (EarlyReg, StandardReg, SpecReg, WorkshopReg)
endif
Thanks again!
Views
Replies
Total Likes
It would be something like this, hope this at least gives you some direction....
if ((SpecReg == "1") & (WorkshopReg == "1")) then
Total = sum (EarlyReg, StandardReg, 495)
endif
Views
Replies
Total Likes
TundraSteve, Thanks for the reply.
Your suggestion got me on the right path. Here's what worked using FormCalc on the TotalDue field:
if (SpecReg + WorkshopReg == 890) then
SpecReg
else
sum (EarlyReg, StandardReg, SpecReg, WorkshopReg)
endif
Thanks again!
Views
Replies
Total Likes
Views
Likes
Replies