Auto compute the Purchase Price

  • Profile Image
    Asked on December 10, 2019 at 09: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

    This is a re-post of a comment on How to Insert Text or Calculation into a Field Using Conditional Logic

  • Profile Image
    Answered 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:

    Here's what it looks like in the Form Builder: