show the selected product in another non-payment field

  • Profile Image
    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":"","transactionid":"65057530J07374724","shiptoname":"Jim Davis","addr":"121 SR 16","city":"Portland","state":"OR","postal":"97007","country":"United States"}

  • Profile Image
    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: 

    Then perform a calculation using the Form Calculation widget: 

    And finally, pass the total to the payment field: 

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