- ftpirolaAsked on December 10, 2017 at 11:13 PM
I have a jotform for taking orders.
I have your standard 'Name' field with prefix selected. I also have address field with street 1, street 2, City, Zip, State, Country
I need to zap the data to Ontraport and Xero.
Both need the name to be separated into 3 fields - prefix, first, last.
Both need the address to be separated.
Zapier has recommended I insert a 'formatter' step to convert the data, but this is complicated and prone to error (eg if the person has a two word first or second name (like Mary Ann Van Dyke --> first =Mary, last = Ann).
Short of redoing the form with separate fields for each element of the multifield, it would be easier if the data just outputted in separate fields like Gravity Forms.
Can you set the output data to do this so that I can select the individual field rather than the aggregated field data.
- JotForm Supportashwin_dAnswered on December 11, 2017 at 05:00 AM
Please note that it is currently not possible to separate the data of name or address field to be displayed in separate columns in submission page.
The best way to achieve your requirement is by adding separate fields in form for first name and last name. You also need to add separate short text entry for all address fields. Please check the screenshot below:
I have cloned your form to add name & address field separately. I will get back to you with the form URL which you can use.
- JotForm Supportashwin_dAnswered on December 11, 2017 at 05:48 AM
Please take a look at the following cloned form where I have made the changes and see if it fits into your requirement: https://form.jotform.com/73441995277974
Feel free to clone this form for a closer look. The following guide should help you in form cloning: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL
Hope this helps.
Do get back to us if you need any other changes.