Pattern Format

Forums SPJS Charts for SharePoint Pattern Format

Viewing 4 reply threads
  • Author
    Posts
    • #7304
      DCH
      Participant

      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!

    • #7323
      Alexander Bautz
      Keymaster

      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

    • #7328
      DCH
      Participant

      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&#8217;

      • This reply was modified 9 years ago by DCH.
    • #7331
      Alexander Bautz
      Keymaster

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

      Alexander

      • #7335
        DCH
        Participant

        Here is the value in my PatternFormat field. And the URL below is what is in the ‘https://URLGeneratedByPatternFormat&#8217; 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 ago by DCH.
    • #7355
      Alexander Bautz
      Keymaster

      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

Viewing 4 reply threads
  • You must be logged in to reply to this topic.