What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

    show the selected product in another non-payment field

    Asked by SpacePoint on June 23, 2016 at 09:56 AM

    I am using Zapier to send form data to Excel. However, JotForm sends all information from the Payment section in one concatenated string. I then have to parse all of this in another app to extract just the Product SKU. Is it possible to have a hidden field on the form that calculates the selected Product? Only one item can be selected from the dropdown product list. I need to only pull out "1266" from the Payment section.

    Example of Payment data sent to Excel:

    {"product":["Fee (Amount: 0.01 USD, Class: 1266 - Preventive Controls for Human Foods)"],"currency":"USD","total":"0.01","firstname":"Jon","lastname":"Fisher","email":"jxxx@xxxxx.org","transactionid":"65057530J07374724","shiptoname":"Jim Davis","addr":"121 SR 16","city":"Portland","state":"OR","postal":"97007","country":"United States"}

  • Profile Image
    JotForm Support

    Answered by BDAVID on June 23, 2016 at 11:22 AM

    I would recommend you separating your products into native fields, like the Drop Down field, then you can assign a value to each option: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value 

    Then perform a calculation using the Form Calculation widget: https://www.jotform.com/help/259-How-to-Perform-Calculation-in-the-Form 

    And finally, pass the total to the payment field: https://www.jotform.com/help/275-How-to-pass-a-calculation-to-a-payment-field 

    Let us know if you have more questions, we will be glad to assist you.