show the selected product in another non-payment field

  • Profile Image
    SpacePoint
    Asked 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
    BDAVID
    Answered 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.