Extracting data from google maps

[Aussie John]

Hello

I have calculation to show a google route map in a web viewer container. From this I extract the distance using GetLayoutObjectAttribute. A couple of issues:

1. Is there any way I can freeze the result, as each time I go to record the web page refreshes. 

2. The distance only calculates if the object is visible making it unusable in another calculation or a different layout.

 

In both instances I probably doing something wrong with storage but if I store the result, the calculation stays empty. Any thoughts?

thanks

[comment]

A stored calculation will recalculate only when one of the referenced fields is modified. You didn't post your calculation, and I am guessing it does not reference any fields. Perhaps you would be better served by a Number field, populated by a script?

[Aussie John]

Hi Comment

As usual I think you are right. - the calculation is referring to the URL 

anyway here is the calculation I am using.

 

GPOcode is the object with the "address of the web viewer" 

 

Let([A=GetLayoutObjectAttribute ( "GPOcode" ; "content");

 

A=Substitute(A;

[Char(13);""];

[Char(10);""]);

 

A=Substitute(A;

["<div class="altroute-rcol altroute-info"> <span>";"¶"];

["</span>,<span>";"¶"]);

A=GetValue(A;2);

A=Substitute(A;"<";"¶")];

GetValue(A;1)

)