How to assign calculation values to a dropdown field?

  • Profile Image
    mitnworb
    Asked on March 14, 2018 at 01: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.

  • Profile Image
    Victoria_K
    Answered on March 14, 2018 at 01: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.

  • Profile Image
    mitnworb
    Answered on March 14, 2018 at 02: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
  • Profile Image
    Kiran
    Answered on March 14, 2018 at 02: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!