FileMaker Google Address Module

Solis Digital
Sep 12, 2017 · 2 min read
Image for post
Image for post

The world’s most valuable resource is no longer oil, but data! Though data is only valuable if it’s valid and reliable.

As a consultant finding the balance between capturing such data and the time it takes to enter that data is a constant battle.

Most off the shelf CRMs provide functionality that allows a user to enter reliable, valid and accurate data — quickly. This improves the efficiency of data capture, whilst providing the company with the data it needs. The most simple example of this is an address lookup.

During a recent project, the development team at Solis Digital have produced an Address Lookup Module utilising Google, that can be plugged into any file with 3 simple steps.

Download the example file here.

Steps to implement:

  1. Add the AddressLookup.fmp12 file as an external datasource in your file named “AddressLookup”.
JSONSetElement ( "{}" ;

[ "street_number" ; "FieldName" ; JSONString ];
[ "route" ; "FieldName" ; JSONString ];
[ "postal_town" ; "FieldName" ; JSONString ];
[ "postal_code" ; "FieldName" ; JSONString ];
[ "country" ; "FieldName" ; JSONString ];
[ "administrative_area_level_1" ; "FieldName" ; JSONString ];
[ "administrative_area_level_2" ; "FieldName" ; JSONString ];
[ "administrative_area_level_3" ; "FieldName" ; JSONString ];
[ "locality" ; "FieldName" ; JSONString ];
[ "sublocality" ; "FieldName" ; JSONString ]

)

Dependancies:

  • Requires FileMaker 16 or higher.

If you have any problems, questions or suggestions for improvements to this file, please do not hesitate to get in contact via email — hello@solisdigital.com.

For more information on delivering custom applications or if you just fancy a chat you can always find us at solisdigital.com.

*Special thanks to John Renfrew for providing the techniques used in the module.

Solis Digital

See your business in a whole new light — We are problem…

Solis Digital

Written by

See your business in a whole new light — We are problem solvers helping businesses to work smarter through automation and digital transformation.

Solis Digital

See your business in a whole new light — We are problem solvers helping businesses to work smarter through automation and digital transformation.

Solis Digital

Written by

See your business in a whole new light — We are problem solvers helping businesses to work smarter through automation and digital transformation.

Solis Digital

See your business in a whole new light — We are problem solvers helping businesses to work smarter through automation and digital transformation.

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store