Hey team! I posted this in another thread and thought I had found a solution, and in fact, it worked for a few days. However, today, it stopped working.

I made a product field set to “Calculation” and I want to use the following formula:

( ( {Birth Certificate:9} + **{Yes:39.2}** ) * {How many birth certificates do you want translated?:25} ) * {How urgent is the translation of the birth certificate?:57}

It is supposed to do the following:

- Take the price for 1 translation of 1 birth certificate (20 bucks)
- Add 7 bucks to that if the birth certificate comes with an apostil
- Multiply the sum of 1 and 2 by however many birth certificates one wants translated
- Multiply all of that with the urgency field, which has a dropdown with 2 values: 1. 1 Week, value 0 and 1 day, value 1. If the urgency is 1 week, then multiply by 0. If the urgency is 1 day, multiply by 1.

So the end result should be that the “Calculation” product adds up to the exact amount of the product and its options, and thus adds the full price of the thing to the order total, effectively doubling it.

The problem is, I can’t get the field I bolded in the formula above (the apostil one, step 2) to calculate. It’s an option field tied to the Birth Certificate product. It has 2 options, Yes (7 bucks) and No (0 bucks). It used to work up until this morning, now it doesn’t. I thought it was because I messed too much with other fields in the form, breaking dependencies and conditions, but I just spent 3 hours re-building the whole form from scratch and the problem is the same.

After dozens of hours trying to build this extremely complex and convoluted system, I am now at the end of my wits.

Here’s the WIP form. select “Geburtsurkunde gewünscht” in the “Geburtsurkunde” product field, then fill the subsequent fields until you get to the “Wie eilig haben Sie es?” section.

Here’s a video showing my problem in the back-end and front-end:

*(Please ignore the last moments, where the whole formula doesn’t work. I had a mistake in it that I have since corrected.)*

I really hope you can help me. The little remaining hair on my head depends on it

On another note, please consider conditional showing/hiding of choices in dropdown/radio etc. fields, and also please consider more than one condition for fields, like “show if field A is ‘Italian’ and field B is ‘Pasta’”. I know Gravity Wiz has something for this, but I tried it and it doesn’t work. Building this form has been a complete nightmare, not your fault, I understand, but these two features would have helped me incredibly.