Jump to content

Recommended Posts

A small, big problem.

We have a field to enter the 4-digit zipcode in the address, and we wanted to introduce only the code by entering the full address, I give some examples:

When entering the zip: 78130-2037 he wrote the address in the address field "SUNGATE DR", he wrote in the city field "NEW BRAUNFELS", he wrote in the state field "TX" and finally in the country field he wrote "USA"

We would only have to enter the zip and then enter the house number.

Is it possible?

Link to post
Share on other sites

If I understand you correctly you want to enter just the zipcode + 4 and have the rest of the address info populated automatically so that the user only needs to then enter the house number?

If so, look for an address API that does just that.  It's a perfect use case for using an external service and FM is extremely good at calling such services and working with the Json data they return.

Link to post
Share on other sites

First you need to do some homework by finding the API service that does exactly what you want at the cost you are willing to pay for it.  Most of these APIs are not free but usually do not cost a lot either.

Once you have have picked the service you want we can then help you get started with how you call their APIs and working with their responses.

Link to post
Share on other sites

I'm doing my homework.

I have a friend who works for USPS and he manages to make available in filemaker format the database of all ZIP +4 in the USA and I thought instead of going to get the internet, could I go to get this external database?

Link to post
Share on other sites

Sure, somewhat depends on whether you can import that into FM.

One thing to note though: these zip code change over time.  One of the benefits of working with a service is that you do not have to worry about these changes.

Link to post
Share on other sites

Sure, but it's not ideal since it uses XML and not Json.  FM does not have native tools for XML constructing and parsing and it is entirely doable and some developers here are very proficient with XML and can certainly help you there.

Personally I would tend to look for a service that uses a REST API.

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Similar Content

    • By dancer5678
      I am using Filemaker Server 18 on Windows Server 2012 R2
      Been using it for years with no issues
      Currently when I log in to the console it is very sluggish.
      When I get to the Dashboard it shows No databases, then it auto refreshes and the database list appears.
      Within 15 seconds of scrolling the database list to open files the screen refreshes. This situations is happening over and over in a loop.
      Any Thoughts on what is causing this issue?
    • By stevaroni
      I get an error 3 when using a script to Export Records via WebDirect. Using FileMaker Server 18 and have tried both Safari and Chrome both with same results. I have tried using the temporary path, desktop path, and documents path. I have tried using with the automatically open and not. I have tried writing a tab delimited and comma delimited file. Does anyone have ideas I haven't yet tried?
    • By cheerfulzebra
      Hi All
      I am hoping some one can help!
      I have a table called TPM, in that table is a field "Next Due Date" Which is auto generated by creating a new record. You input the date you did the service and then it adds 3 months to that date and that appears in the Next Due Date Field.. All working...
      What I am trying to do is when the database loads it runs a script to see if there are any outstanding TPM Services to do...
      Here is the script
      Show Customer Dialog
      Message: If ( TPM::TPM Next Due Date < Get (CurrentDate ) ; "You have outstanding TPM services" ; "You have no outstanding services")
      I thought it would be that simple. So I created a TPM Due date Less that Current date and ran the script...."You have outstanding TPM Services"...GREAT! Then I deleted that record and ran the script again...""You have outstanding TPM Services" Oh!!! That isnt true!
    • By Kitesurfer
      Can someone please explain why Leftwords function is not properly working when importing an excell sheet.
      For example the name John Doe LeftWords ( Client ; 1 ) should show "John" only.
      When typing John Doe it works fine but not when importing ????
      Looking forward to a reply.
      Kind regards
    • By Pio Soto
      My issue is that my customer layout has a script trigger on LayOutEnter that sorts my customers portal list by "Active" customers,
      but when I do a go to related record from another table say from quotes or any other the customer layout does not load that customer
      or show my related customer because the OnLayoutEnter script trigger changes it, I would like it to go to the related customer and also sort it by "Active"
      on the list.
      Hope someone can help me with this.

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.