Fusion Manage Forum
Welcome to Autodesk’s Fusion Manage (formerly Fusion 360 Manage) Forum. Share your knowledge, ask questions, and explore popular Fusion Manage topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Computed Field Google Maps Error

18 REPLIES 18
SOLVED
Reply
Message 1 of 19
Liz.Paton
1264 Views, 18 Replies

Computed Field Google Maps Error

I'm trying to create a computed field to show a Google Map, following these instructions.

 

think I have entered all the required data correctly.  When I hit save on the Edit Field dialog, I get an error message: "There has been an error in processing your request.  Please use your browser's back button and try again or contact your system adinistrator." 

 

Any Ideas on what I'm doing wrong?

18 REPLIES 18
Message 2 of 19
bastien.mazeran
in reply to: Liz.Paton

Hi Liz,

Could you please try replacing the concatenation symbol + with the following symbols ||  in your computed field formula and let me know if that resolves your issue?

Regards,



Bastien Mazeran

Technical Support Specialist

Message 3 of 19
Liz.Paton
in reply to: bastien.mazeran

I don't get the error message any more, but I also don't get a map generated from the address.

 

Liz

Message 4 of 19
bastien.mazeran
in reply to: Liz.Paton

Hi Liz,

Could you create a new computed field where you only store the http URL to see if you can browse to it and display a map in a new tab?

Regards,



Bastien Mazeran

Technical Support Specialist

Message 5 of 19
Liz.Paton
in reply to: bastien.mazeran

Hi Bastien,

 

I can get text to show up, but anything else returns blank.

 

Thanks,

Liz

Message 6 of 19
bastien.mazeran
in reply to: Liz.Paton

Hi Liz,

Please try to paste the URL text to a new tab in your web browser and confirm you can see the map correctly there.

What browser are you using by the way?

Regards,



Bastien Mazeran

Technical Support Specialist

Message 7 of 19

Hi Liz,

Are you testing the map in the Suppliers workspace? If not, please post your formula for review.

Regards,



Bastien Mazeran

Technical Support Specialist

Message 8 of 19
Liz.Paton
in reply to: bastien.mazeran

Hi Bastien,

 

I did some Googling and some playing around and I have got it  to work now!  Must be something about the difference between Friday afternoon and Monday morning... Smiley Happy

 

I'm not exactly sure exactly what I am doing differently today that wasn't working last week, but I do know that  the code shown on the Computed Fields WikiHelp article was part of the problem -- perhaps that should be corrected/updated.

 

Another issue  that I found, which from doing further Googling seems to be a Google Maps issue not a PLM 360 issue, is that the map doesn't centre on the pin if the section is set to default to collapsed -- it only shows centred if the section is not collapsed when you open the page.  Might be a good thing to point out to other users if they are running into this problem.

 

FYI, I have been using Google Chrome and and working in a new Workspace that I created.

 

The formula that I got to work is:

 

'<iframe width="425" height="350" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="https://maps.google.ca/maps?q= '||STREET||','||CITY||','||PROVINCE||';t=h&amp;z=14&amp;output=embed&iwloc"></iframe>'

 

Thanks for all your help!

 

Liz

Message 9 of 19
bastien.mazeran
in reply to: Liz.Paton

Hi Liz,

We are aware of this documentation issue and have plans to correct this in near future. For your information, the new help system can be accessed here.

Regards,



Bastien Mazeran

Technical Support Specialist

Message 10 of 19

Hi Bastien,

 

I also had the same problem as Liz, and her formula that she wrote above works for me. However, in the Help link that you provided, the formula is turned into a Google map so people cannot see what the syntax of the formula is. Please fix!

 

Thanks,

Sara Murray

Message 11 of 19
bastien.mazeran
in reply to: Liz.Paton

Thank you Sara for pointing this online help issue. I have reported it to the relevant parties.

Regards,



Bastien Mazeran

Technical Support Specialist

Message 12 of 19
fhmurray
in reply to: sara.murray

HI,

 

I have used Liz's formula to redo the Suppliers' map, but can't get it to save - it just says that the formula is invalid.  

 

Here's my code:

'<iframe width="425" height="350" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="https://maps.google.ca/maps?q= '||SUPP_ADD1||','||SUPP_POST_TOWN||','||SUPP_POSTCODE||','||SUPP_COUNTRY||’;t=h&amp;z=14&amp;output=embed&iwloc"></iframe>'

 

and here's the error.  I have checked the field names are correct, so what am I missing ?

 

2013-11-18_Supplier_map_formula_invalid.JPG

 

 

Thank you!  I'd like to get this right as I have a number of map fields to redo.

 

Fiona

Message 13 of 19
Liz.Paton
in reply to: fhmurray

Hi Fiona,

 

The only difference I can see is that I don't have a space between the q= and the ' at the end of the google maps address.  If I recall, that was the easiest way to keep the text from doing some funky snipping of the hyperlink text and breaking the formula.  

 

Try this: 

 

'<iframe width="425" height="350" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="https://maps.google.ca/maps?q='||SUPP_ADD1||','||SUPP_POST_TOWN||','||SUPP_POSTCODE||','||SUPP_COUNTRY||’;t=h&amp;z=14&amp;output=embed&iwloc"></iframe>'

If that doesn't work though, I've got no idea, sorry!

 

Cheers,

Liz

 

Message 14 of 19
fhmurray
in reply to: Liz.Paton

Ah, thanks Liz.  I tried your suggestion, but it's still retunring the invalid formula message.  Fingers crossed that some (other!) smart cookie on here can see what's wrong!

 

Fiona

Message 15 of 19
sara.murray
in reply to: fhmurray

Hi Fiona,

 

The part in your formula where there is a line return in the middle of SUPP_POSTCODE could be problematic. Good luck!

 

Sara

Message 16 of 19
fhmurray
in reply to: sara.murray

Thanks Sara - turns out that is just how it has come out on screen here - it doesn't actually exist in the code, but thanks for the suggestion as it was worth double-checking!

 

Fiona

Message 17 of 19
fhmurray
in reply to: fhmurray

Just bumping this up to see if anyone can help.  Still got blanks where all my maps should be, despite having them working several weeks ago.

 

Thanks for any help,

 

Fiona

Message 18 of 19
bastien.mazeran
in reply to: fhmurray

Hi Fiona,

If you were to create a new field and reuse the same formula there, would it still continue to fail?

Regards,



Bastien Mazeran

Technical Support Specialist

Message 19 of 19
jpiggee
in reply to: bastien.mazeran

Fiona,

 

If you are still having problems, can you try this instead: (you might need to adjust the fields to match your own)

 

(CASE  WHEN TOWN IS NULL THEN

 ('<iframe width="425" height="350" frameborder="0" scrolling="no" marginheight="0" marginwidth="0"

   src="http://maps.google.com/maps?f=q&amp;source=s_q&amp;hl=en&amp;q='

   || STREET || ',' || TOWN || ',' || COUNTRY || ';t=h&amp;z=14&amp;output=embed"></iframe>')

ELSE

 ('<iframe width="425" height="350" frameborder="0" scrolling="no" marginheight="0" marginwidth="0"

   src="http://maps.google.com/maps?f=q&amp;source=s_q&amp;hl=en&amp;q='

   || STREET || ',' || TOWN || ',' || COUNTY || ',' || POSTCODE || ';t=h&amp;z=14&amp;output=embed"></iframe>')  END)

Joseph Piggee
Fusion 360 Administrator
TPI Composites
jpiggee@tpicomposites.com

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report