Using logic to calculate total

Hi there,

I've got a problem that I think should be solvable. My non-profit wants to calculate membership costs in pricing fields based on the user's response to two questions. But we don't want the user to see how this works behind the scenes, so we don't want any prices to appear before the total amount.

Here are the 2 questions that determine cost:

1. Please select the industry group that best describes your business*

Commercial Products/Services
Construction
Consumer Products
Education, Non-Profit & Government Entities
Financial & Insurance Services
Healthcare
Information Technology
Manufacturing
Professional
Transportation

2. Number of employees in U.S.*

1 – 750
751 – 1,000
1,001 – 1,500
More than 1,500

And here's the logic we want to implement:

- IF the answer question 1 is "Education, non-profit & government," THEN total is $950.00

- IF the answer to question 1 is NOT "Education, non-profit & government," AND answer to question 2 is...
"1 – 750" then total is $950.00
"751 – 1,000" then total is $1,875.00
"1,001 – 1,500" then total is $3,125.00
"More than 1,500" then total is $4,500.00

Thanks in advance for your help!

-Ben

Thanks David, I appreciate your help. But now I'm having a related issue.

That method works for me in the preview form, but not on my actual theme. The newly created conditional product fields are not appearing when the correct criteria are selected. This is weird because I have another conditional field elsewhere (file upload field) on this same form, and that one works just fine.

Do you have any known issues with the Envision Theme from Themefuse?

Thanks,
Ben

I wanted to follow-up on this, even though it has been 6 months since my first post and I am now using a different theme.

I followed David's instructions regarding my use of conditional logic within my product fields and they were spot-on. The form works properly in Preview mode -- all four pricing options display based on the way a user answers those two questions I mentioned above.

However, the pricing form does not work properly on my live site. For some odd reason, only the FIRST product field displays on my live site when the appropriate conditions are met in the 2 key fields. If I change the answers to those 2 key questions, I don't see any corresponding product fields at all.

Does this make sense? I hope someone can help.

You can view the problem here:
https://www.minoritysupplier.org/membership/corporate-membership/apply-for-membership/