-
b370nAsked on December 10, 2019 at 9:56 AM
I'm running a swiftlet nest business, we buy supplies every week and the number of grams are always different, and the price is also always different depends on the supplier, how do I auto calculate my purchase price
-
John Support Team LeadReplied on December 10, 2019 at 11:27 AM
Instead of using conditions to calculate the purchase price, you may add a Form Calculation widget to your form. You only need to add the fields to be computed along with the formula in this widget and it will automatically display the calculated value.
And to achieve the requirement you mentioned, I believe you need to use another 2 fields for that. One for the Number of Grams and the other's for the Price per Gram.
I have created a demo form to better illustrate the idea. Here's a link for you to try:
https://form.jotform.com/193434131706958
Here's what it looks like in the Form Builder: