Smart Notification Tools Option - Excel ONLY

 3 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
Carl Gifford
Basic Member
Posts: 11
Basic Member
    I would like to include the link on the bottom of the Smart Note that has the option to export to a spreadsheet.  I know that this can be done by updating the template to inlcude the [tools] token; however I ONLY want to include the options

    View as an Excel Spreadsheet
    View as an Microsoft Excel spreadsheet with no formatting

    Is this possible? If so how?
    Matthew Nye
    Veteran Member
    Posts: 514
    Veteran Member
      Carl,

      Theres no straight forward way to use do this. Theres a lot of information embedded in those template tokens that you cant segregate. Couple things you can do:

      1. Those links seem to be based on the ID of the Notification
      http://socbslbit3.sharp.c...5184&xls=1&objtype=3
      http://socbslbit3.sharp.c...n.ifx.render.MSExcel
      Theoretically you could put this link in the footer of your template and plug in the current Notification ID instead of leaving it static. You will have to use JavaScript to get this value from the URL as well. Im not positive this will work as Ive never tried it myself. Make sure that objid does actually corresponds with the Notification ID.

      2. Its not the simplest but its the most reliable solution. Using JavaScript you can pass the HTML value of [tools] into a string reader and pull out only the elements you want and then assign them to HTML elements in your template for display.

      hth
      Matt
      If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
      Carl Gifford
      Basic Member
      Posts: 11
      Basic Member
        I am trying to go with Option 1 above and it appears to work; however I cannot seem to find the token template for the current notification id.  Does this exist?
        Matthew Nye
        Veteran Member
        Posts: 514
        Veteran Member
          No theres no token for this, however using javascript you can get the URL of the page, then parse that URL for the ID and concat it with the rest of the link. window.location will get you the current location. Assign that to a variable and search that variable for the first 4 digits following "id=".

          hth
          matt
          If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/