How do you suggest combining multiple fields for an address into a single field?

  • Karen otto
    Asked on January 30, 2020 at 9:06 PM

    How do you suggest combining multiple fields for an address into a single cell for importing? Is there a required delimiter for each section?

  • jherwin
    Replied on January 31, 2020 at 12:31 AM

    If your question is related to commas and address fields, yes you need to use a comma. Inside of mentioned guide Import-App-Easily-import-your-Excel-or-CSV-data-into-JotForm there is an example for address field:

    The address field might be imported with just one header for it, but your file might have several fields for the address data. The tool will replace these fields:

    "Street Address","Street Address Line 2","City","State / Province","Postal / Zip Code","Country"

    with just this one:

    "6_Address_address"

    *This would require that you not only change the headers but to apply the changes to the address data as well"

     Following this, we continue as previously mentioned, one field at a time. 

    If I did not understand you correctly please explain in more detail what are you trying to achieve.