JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Is there a way to access individual address sub-fields within JotForm and Zapier Xero integrationAsked by daveoreardon on September 20, 2014 at 12:18 AM
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?
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.
Btw, I have created a separate thread for the other question here http://www.jotform.com/answers/431847
We will attend to it separately.