Hi,
I’ve checked your form, and your form includes many fields but the equation used is simply:
fieldname2*2
If you want to create an equation that display the calories of all fields selected, you should make some corrections in your form:
First, all check box should contain numbers as values, currently the value of fields are texts. Similar with the drop-down fields, if an option’s text is 100g, the option’s value should be simply 100.
Second the equation should be the sum of drop-down fields multiplied by the corresponding checkboxes,
For example, I will take one section of your form, you should complete the equation to include all sections of your form:
The field “Almoço – Peso Carboidrato” is the fieldname27, and the corresponding checkboxes fieldname23, so the following operation fieldname27*fieldname23 is part of your equation, so your equation would be:
fieldname27*fieldname23+……
The sum of all sections
Hello!
Many thanks. Worked like a charm.
The only thing that I don´t know how to do is the following: this form is for people making their own weekly diet. Therefore, he/she may choose from day 1 to 7. The thing is, when we choose day 2, for example, all the sum from day 1 becames 0 and it stard summing day 2. It does not give the result for day 1 + day 2 + ….
Is it possible to make that possible?
Best,
Flávia
Hi,
In the Calculated Fields Form, the dependent fields are removed from the equation when are not active, so if the fields of DAY 1 are hidden when select DAY 2…, the fields related to the DAY 1 are removed from the equation.
My recommendation in your case is modify your form to be multipage, where each page represent one day (If you want to create a multipage form, only need insert fields page break)
Thanks a lot!
It worked so fine!
Congratulations again for this amazing plugin. Will definitely buy the premium version.
Best,
– Flávia
