How to format and import JotForm address data into Halo using Zapier?

  • 8 April 2024
  • 4 replies

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

I’ve tried and Tried and found the AI useless in formatting the Address in the Right way.


I have this expression coming in from Jotform

We mostly get Unit addresses, but some times it is a standalone house.

So I need to extract both using 

Example With A Unit Address:
Street name: xxxxxx Unit/Street Number: Unit x/xx City: xxxxxx State: xxx Postal code: xxxx Country: xxxxxxxx

Example Without A Unit Address:
Street name: xxxxxxxxtUnit/Street Number: xx City: xxxxxxx State: xxx Postal code: xxxx Country: xxxxxxxx

I want to import it into Halo which has 4x Address fields & a Postcode field.

I want to output like this

Address 1: Unit xxxxx xxxxxx xxxxx (if it is a Unit)

Address 1: xx xxxxxx xxxxx (if Not a unit)

Address 2: xxxxxx
Address 3: xxx
Address 4: xxxxxxx
Address 5: xxxx

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 7
Badge +14

Hi @communitymember01 

One option is to use a Code step to parse out the data points:

Sorry I am the OP.

Thanks Troy, 


I’m not familiar with Pytohn or Java programing.

I thought it was possible wiht the AI Thingy:

Isn’t that is what it is for???


I don’t understand what I’m supposed to put in here???


Userlevel 7
Badge +14


Help articles for using Code:


This is to name an input variable that is then reference within the Code.