The input table that has dollars and weights and does calculations?

  • TFGUSA
    Asked on April 21, 2019 at 5:47 PM

    Can I have an input table that is some fields with $(price) and some fields kg(weight) and do a simple calculation for each at the end?  Seems like a basic thing but I am just getting started and I believe this tool can solve my needs because it seems powerful but I have no idea if its achievable?


    This is VERY generic, but this is sort of the idea I want.

    I have a lot more questions but this table would get me started in the right direction.

    Look

  • Alan_D
    Replied on April 21, 2019 at 6:47 PM

    Please try our conditions! You can make calculations between input table elements. Let me show a sample. 
    This is the clone of your form.
    The input table that has dollars and weights and does calculations? Image 10I will find that;
    (Raw forging/casting weight)x(Raw forging/casting price)+(Raw Material price)+(Machining price)=(Total price)
    Let's create your first condition.
    The input table that has dollars and weights and does calculations? Image 21This is how you can create the condition.
    1555886537bandicam20190422013941460 Screenshot 32Finally, the condition will look like that.
    The input table that has dollars and weights and does calculations? Image 43And see the result!
    1555886682bandicam2 Screenshot 54Please specify your request if it won't help you.
    You can find more information about conditions here.
    Conditional Logic for Online Forms

  • TFGUSA
    Replied on April 21, 2019 at 8:20 PM

    pretty cool.  ill have to play more but i get the basics.  is there a way to add a kg, and  $ so its easily observed as a weight or dollar value?


  • AndrewHag
    Replied on April 22, 2019 at 12:43 AM

    You can add the $ sign to the total price by just adding the $ before the field in the condition, see the screenshot below: 

    1555907356chrome g12qWPZGnI Screenshot 10

    It is not possible to add the kg automatically in the weight field and $ in the remaining price fields. You may mention it on the column header.

    1555908212chrome 5fF7bXeulh Screenshot 21

    This is how it looks:

    1555908129chrome TCsvuVVlj9 Screenshot 32