Gyrodude

Thanks guys, I've been doing some research into this and determined that it would probably be best to leave this to the professionals. I've contacted a 3rd party that can take the SDK and write a custom function into FileMaker for me.

I've been working with FM for awhile, but completely new on the programming front with any other language. I have a 3rd party vendor who provides routing and distance data, much like Google API, but uses PHP or SOAP as their main protocol. The output from any query is in XML or KML. Is there a simple way to connect FM 13 to this vendor or will I need to hire a developer to build the plugin? Thanks, Thomas Hatton

Answered my own question with a workaround. The agreement is that the data captured from the API must be used in a MAP but it doesn't specify how that data gets to the map. So I created a Web Viewer object and via a script, I represent the same query via Googles standard map display: "https://www.google.com/maps/dir/" & <Table>::MAP_City_Start & "+" & <Table>::MAP_ST_Start & "/" & <Table>::MAP_City_End & "+" & <Table>::MAP_ST_End Since the data returned via the JSON is identical to the data via google/maps in a web viewer, it's legally represented. Thanks

I keep finding responses telling us that the Google Distance API must be displayed in a Map for licensing purposes, but not how to accomplish this in FileMaker. I'm writing an application that pulls the API information into a text field so I can get the distance value (JSON) but I haven't figured out how to get this to the web viewer for displaying the route. Can someone please post an example of how this works? Thanks

Thanks Guys, your comments were a great help! I'm sorry if I was somewhat vague, EOS, your example worked perfectly. I am working with a single table and two fields, trying to compare the contents when one field has comma delimited data and the second filed has CR delimited data. So the "Compare two CR-delimited lists" worked perfectly with no partial matches. Thanks again, and thanks for the quick responses!

I know there must be a simple way to do this, but I'm just not seeing it and I was wondering if anyone could help me. I have a source field that will contain known values in any combination. Example: VANS = "VAN,53VN,VANL,VANV". Then I have a checkbox field that I'm attempting to match against the first, containing all the various types of vans (VanTypes). I need to get an exact match of one of the values without matching partials. For instance, if VANS = "VAN,53VN, 48VN, REFR" and VanTypes has "REFR" checked, then I expect to get a match count. If VanTypes has "VANL" checked, then no match and no partial match to "VAN". The source (VANS) field is imported and can have any number of van types listed, usually from 1 to 4, but always using the "," delimiter if more than one. I've tried different functions, but I either get a partial match (i.e. with PatternCount) or they don't see the delimiter and tries to match the entire string. Thanks,