› Forums › SPJS Charts for SharePoint › Pattern Format
- This topic has 5 replies, 2 voices, and was last updated 9 years ago by Alexander Bautz.
-
AuthorPosts
-
-
March 24, 2015 at 16:54 #7304DCHParticipant
Alexander,
I’ve read and reread the Google instructions, and tried to format my value in many different ways, but I can’t get the PatternFormat to work for a Table Chart.
My setup page saves ok, but then I get “Syntax Error: Invalid Character” in a popup when the page reloads, and then “Error loading chart. Enter setup to recover the last good configuration.” once I click through the dialog.
I am trying to use the value in one column to build a hyperlink to a filtered list view that supports the count of those items. Can you help me with the correct syntax?
Thanks!
-
March 27, 2015 at 08:29 #7323Alexander BautzKeymaster
Try
<a href='{0}'>{1}</a>
Where column index 0 is the URL and index 1 is the text you want to show on the URL.
Alexander
-
March 27, 2015 at 16:49 #7328DCHParticipant
Awesome thanks, this gets me further than I’ve gotten before!
I’m not sure if this is a bug or something I still don’t understand, but the URL ends up like this:
https://sharepoint.com/sites/site/SitePages/’https://URLGeneratedByPatternFormat’
- This reply was modified 9 years, 1 month ago by DCH.
-
March 28, 2015 at 08:58 #7331Alexander BautzKeymaster
How does the URL you use in the calculation look like?
Alexander
-
March 30, 2015 at 16:59 #7335DCHParticipant
Here is the value in my PatternFormat field. And the URL below is what is in the ‘https://URLGeneratedByPatternFormat’ above (including the single quotes).
<a href='https://sharepoint/sites/site/Lists/List/View.aspx?View={9398E27A-31BE-4CFA-89B4-837F6F111E36}&FilterField1=Status&FilterValue1={0}' target='_blank'>{0}</a>
- This reply was modified 9 years, 1 month ago by DCH.
-
-
April 6, 2015 at 13:10 #7355Alexander BautzKeymaster
Sorry for the delay. I changed the quotes like this and it seems to be OK:
<a href=\"https://sharepoint/sites/site/Lists/List/View.aspx?View={9398E27A-31BE-4CFA-89B4-837F6F111E36}&FilterField1=Status&FilterValue1={0}\" target=\"_blank\">{0}</a>
Alexander
-
-
AuthorPosts
- You must be logged in to reply to this topic.