Creating a form with calculations

  • ncoxdoterra
    Asked on June 9, 2020 at 11:14 AM

    Good afternoon 

    I am wanting to crate a form for internal staff product orders.

    I am trying to create something where by there is a list of times to choose from (can select more than one item at a time) where they can select how many of those items they want. This is then calculated into points which there is a maximum of points that can be used. Example of an existing spreadsheet currently be used is below:

    Is there a way this can be implemented in a jot form? Also so the points are then added up and calculated not in a currency value (e.g. $= total) 

     

    It would also b great if i could do this but separate the products into different sections, i.e. body, face, accessories but the total is then calculated as an over all, not section by section?

     

    If you can help with any of this, it would be hugely appreciated as I am not sure/ don't understand how to do the conditions in the background.

     

    Thank you

    Example of current form:

     1591715713Capture Screenshot 10

  • Welvin Support Team Lead
    Replied on June 9, 2020 at 1:34 PM

    We do not have this table in the form, but I think you can do this with our payment tools. If there's no need for actual payment, use our Purchase Order tool.

    https://www.jotform.com/help/460-How-to-Create-Payment-Form-with-Purchase-Order

    I've created a demo form here https://form.jotform.com/201605368915053.

    For Product Categories, please refer to this guide: https://www.jotform.com/help/733-How-to-Add-Product-Categories-to-Payment-Fields.

    If there's a need to choose a month, I would suggest doing this with another product option.

    https://www.jotform.com/help/225-How-to-Add-Options-to-Payment-Forms

    Lastly, since there is no option you can disable the currency, I would suggest hiding it with custom CSS codes. You can see, I don't have the currency in the demo form above. There's still the decimal places tho.

    Please check and let me know your thoughts.

  • ncoxdoterra
    Replied on June 10, 2020 at 10:28 AM
    Thank you for your help on this! This is exactly what I was after!
    I’m not very familiar with CSS coding, Are you able to explain how you got rid of the GBP part?
    Kind Regards
    Nicola Cox
    [signature_567437365]
    Nicola Cox
    Junior Logistics Coordinator
    E: ncox@doterra.com
    T: +44 (0)1908 088541
    W: doterra.com
    Altius House, 1 North Fourth Street,
    Milton Keynes, MK9 1DG, UK
    ...
  • Welvin Support Team Lead
    Replied on June 10, 2020 at 11:39 AM

    I have injected the following custom CSS codes:

    .form-product-details {

        visibility: hidden;

    }

    .form-product-details span span {

        visibility: visible;

    }

    .form-payment-price {

        visibility: hidden;

    }

    .form-payment-price span span {

        visibility: visible;

    }

    Guide to inject: https://www.jotform.com/help/117-How-to-Inject-Custom-CSS-Codes

    Note that the currency will still get displayed in the email and reports. You can't get rid of it on the backend side of the form.