Use Javescript to do a Zip Code LookUp and return county


1 comment

  • Rainer Grabowski (FVM)

    Hi Scott,

    I assume in your Counties app each county is an own item with the 2 fields zip code and county name. A calculation field can get data only from those items which are connected to the item where the calculation field is in. To get the wished county into your Leads app via a calculation field you would have to connect the Lead to the County.

    I see 2 possible ways:
    Create a relationship field in Leads to Counties. Than you have to set the relationship for every Lead to the County manually. To find the county with the right Zip code just type the Lead's zip code into the relation field and it gets the county. The advantage of this solution is, that you can filter on counties in the Lead app and you don't need a calculation field cause you see the county in the relationship ship field. If you want to have the county name in a calculation field too, use : @all of NameOfTheFieldWithCounty.join()

    Use the Podio extension GlobiFlow . There you can create a flow like: When a new lead is created (or updated), search in app County for the Zip Code of the Lead and set a relation to the County item with this zip code.


    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk