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

    Is there a way to access individual address sub-fields within JotForm and Zapier Xero integration

    Asked by daveoreardon on September 20, 2014 at 12:18 AM

    Hi.

    I have been trying to use Zapier to create a Contact in Xero from details entered in Jotform. The Zap needs me to map individual address fields from Jotform to individual address fields in Xero.  Unfortunately, Zapier only lets me map the single Quick Tool Address field from my form, not the sub-fields.  This forces me to match a whole address in Jotform tp Address Line 1 in Xero.

    So, I thought a good workaround would be to create some hidden fields on my form, eg. Add1, Add2, ZIP, Country etc and use Jotform's conditional logic (Update Form Field Value) to load these hidden fields from each sub-field of the Quick Tool Address field. I thought I'd then be able to map those hidden fields to the individual address fields in Xero.

    However, in Jotform's Conditions Wizard there doesn't seem to be a way to refer to the sub-fields of the QuickTools Address field, so I am unable to load the hidden fields the way I expected, e.g. like this:

    HiddenAdd1 = QuickToolsAddress.Address Line 1

    HiddenAdd2 = QuickToolsAddress.Address Line 2

    HiddenZIP = QuickToolsAddress.ZIP

     

    Here's the Zapier mapping, which shows where I'd like to be able to match the individual sub-fields of address and name, rather than the whole field.

     

    Is there a way to do this?

    Thanks!

    Page URL:
    http://www.test.ciopulse.com.au/signup.html

    JotForm address field hidden form field zapier xero full address
  • Profile Image

    Answered by daveoreardon on September 20, 2014 at 03:19 AM

    My question also applies to the name field. I have a combined name field, which works well with the Campaign Monitor integration (it wants a single field with the contact's full name in), but Zapier wants a separate first name and last name.
  • Profile Image
    JotForm Support

    Answered by jonathan on September 20, 2014 at 08:57 AM

    Hi,

    I was able to see what you meant on the field mapping limitation when using the compound field like Full Address field when setting the configuration of JotForm to Zapier Xero.

    It seems there is no procedure available to break-down the Full address field into multiple sub-fields during the integration process.

    So, the only option available is to not use the Full Address field from Quick tools if you need to mapped separate address details in the integration.

    Use instead individual Textboxes for the address fields. When you do this you can then easily mapped each address field to the Zapier available fields.

    Hope this help. Inform us if you need further assistance.

    Thanks.

     

     

     

  • Profile Image
    JotForm Support

    Answered by jonathan on September 20, 2014 at 08:59 AM

    Btw, I have created a separate thread for the other question here http://www.jotform.com/answers/431847

    We will attend to it separately.

    Thanks.