Copy Google Maps address and paste into FileMaker go

[Randy Bennett]

I am trying to input address into FileMaker Go from Google Maps (all from iPhone).

My thinking is this:

1. I drop a pin in Google Maps
2. Click on 'Share'
3. Hit 'Copy'
4. Go to FileMaker GO
5. Paste the address

However, when I do this - it will paste too much information - a) Name of location/business, b) address and c) https://goo.gl/maps...... URL

Is there a way to only copy / paste the address OR URL (but not both at the same time)?

Maybe I'm going about this all wrong (probably) - but I just need a simple way to copy and paste an address into FileMaker Go. and then later click on that address and view back in Google Maps.

Any suggestions?

Edited April 23, 2019 by Randy Bennett
Wasn't finished typing everything - :(

[Aussie John]

Without seeing the text you will be able to parse the required info .

using pseudo code (sorry on iPad)

Let([text=google string,

Text= substitute(text, “http”,paragraph symbol & “http”)],

getvalue(text,2)

)

[Randy Bennett]

Aussie John - I am so grateful that you have responded - but I'm afraid I need a little more hand holding regarding your answer. 

If possible, can you go please into a little more detail - and walk me thru the process a bit more? (like I'm a beginner.. cause I am. )

 

If I need to show you any pic or info - just let me know

Edited April 24, 2019 by Randy Bennett

[Aussie John]

Randy - Can you give me an example of the Google string?

Also you might like to tell us what your database is recording and what you are trying to do with the information

[Randy Bennett]

Aussie John - thanks again for responding - I somehow missed the email notice.  You are an ambassador to your country! HA!

A year or so back, I bought an (Australian made!) metal detector - My son and I go doing and treasure hunting around various parks, beaches and locations. 

I am trying to build a database that records information about our treasure hunting finds. I record the date when we found the treasure, what type it is, a couple of picture fields - etc. 

I also want to record the location of where we found the treasure. I have no clue how to go about the Google Maps API thing.. (not that smart) - So, I thought I would just go to Google maps - drop a pin where we were and then copy and paste that info into my Filemaker Go database. 

I can get it working, however I have to manually delete the first information you see here in red and only leave the "http" info. If I do that, then my container field under will work (it simply displays the map website) - Later, if we want to go back to that location, I can simply click on my button "Open Map Location" and it will open Google maps to that exact location. 

I hope I am explaining myself clearly enough. Thanks again - Any thoughts?

Edited June 12, 2019 by Randy Bennett

[Aussie John]

Based on what I can see you can just use Getvalue(text,3) but this assumes the string has just 2 line breaks. If this is not true then you will need to use a series of calculations ( or a LET statement)

Let ([

text=your_https_string,

len=length(text) ,

pos=Position ( text ; "https" ; 1 ; 1 )],

Right ( text ; len-pos+1)

)

[Randy Bennett]

Dude - you are a gem! - The Getvalue worked! Whoohoo!

Edited June 12, 2019 by Randy Bennett

[comment]

Assuming that the URL is the last paragraph in the text, you can extract it simply as =

GetValue ( text ; ValueCount ( text ) )

 

Another option is =

RightValues ( text ; 1 )

Note that this leaves a trailing carriage return  - but that's not a problem when using the result in Open URL..