How to assign calculation values to a dropdown field?

  • mitnworb
    Asked on March 14, 2018 at 1:23 PM

    Can you give me some ideas on how I can recreate my excel spreadsheet.  It has a dropdown list that I have to pull from and then calculate the total.  And then have the customer electronic sign it.  What is the best way to line up the fields like in my spreadsheet.  Thanks.

    Page URL: https://www.dropbox.com/s/orvtsnd7hrtuo6d/2018%20Order%20Form.xltx?dl=0
  • Victoria_K
    Replied on March 14, 2018 at 1:57 PM

    From what I can see on the sheet you shared, I suggest to use a dropdown field for this purpose. There is an option to assign calculation values and to perform any calculation you might need. Here is the guide which might be of help:

    How-to-Assign-Calculation-Value

    Also, you might find useful a Form Calculation widget to add afterwards:

    How-to-Perform-Form-Calculation-Using-a-Widget

    Hope this information helps! But, get back to us if you need further assistance.

  • mitnworb
    Replied on March 14, 2018 at 2:05 PM

    Thanks for the quick reply. 

    How about lining up the fields like those on my form.  Is there an easier way to line the fields up without them being tied to the columns, kind of like freeform placement
  • Kiran Support Team Lead
    Replied on March 14, 2018 at 2:29 PM

    The other question is moved to a separate thread and shall be addressed there shortly. Please follow the link below:

    https://www.jotform.com/answers/1415111

    Thank you!