Pattern Format

[DCH]

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!

[Alexander Bautz]

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

[DCH]

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, 9 months ago by DCH.

[Alexander Bautz]

How does the URL you use in the calculation look like?

Alexander

[DCH]

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, 9 months ago by DCH.

[Alexander Bautz]

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

[Author]

Posts