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

  • Profile Image
    TFGUSA
    Asked on April 21, 2019 at 05: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

  • Profile Image
    Alan_D
    Answered on April 21, 2019 at 06: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.
    15558858232.pngI 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.
    15558864781.pngThis is how you can create the condition.
    1555886537bandicam20190422013941460.gifFinally, the condition will look like that.
    15558865842.pngAnd see the result!
    1555886682bandicam2.gifPlease specify your request if it won't help you.
    You can find more information about conditions here.
    Conditional Logic for Online Forms

  • Profile Image
    TFGUSA
    Answered on April 21, 2019 at 08: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?


  • Profile Image
    AndrewHag
    Answered 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.png

    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.png

    This is how it looks:

    1555908129chrome_TCsvuVVlj9.png