I'm trying to create a computed field to show a Google Map, following these instructions.
I 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?
Solved! Go to Solution.
Solved by Liz.Paton. Go to Solution.
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,
I don't get the error message any more, but I also don't get a map generated from the address.
Liz
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,
Hi Bastien,
I can get text to show up, but anything else returns blank.
Thanks,
Liz
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,
Hi Liz,
Are you testing the map in the Suppliers workspace? If not, please post your formula for review.
Regards,
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...
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&z=14&output=embed&iwloc"></iframe>'
Thanks for all your help!
Liz
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
Thank you Sara for pointing this online help issue. I have reported it to the relevant parties.
Regards,
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&z=14&output=embed&iwloc"></iframe>'
and here's the error. I have checked the field names are correct, so what am I missing ?
Thank you! I'd like to get this right as I have a number of map fields to redo.
Fiona
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&z=14&output=embed&iwloc"></iframe>'
If that doesn't work though, I've got no idea, sorry!
Cheers,
Liz
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
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
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
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
Hi Fiona,
If you were to create a new field and reuse the same formula there, would it still continue to fail?
Regards,
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&source=s_q&hl=en&q='
|| STREET || ',' || TOWN || ',' || COUNTRY || ';t=h&z=14&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&source=s_q&hl=en&q='
|| STREET || ',' || TOWN || ',' || COUNTY || ',' || POSTCODE || ';t=h&z=14&output=embed"></iframe>') END)