Question

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

  • 8 April 2024
  • 4 replies
  • 17 views

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: https://zapier.com/apps/code/help

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

@Nathan-Alpha 

Help articles for using Code: https://zapier.com/apps/code/help

 

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