-
SpacePointAsked on June 23, 2016 at 9: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"}
-
David JotForm Support ManagerReplied 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.