Follow me on Twitter: @eusp

Jul

9

SharePoint Multi-Media Center: Dynamically generate a URL string

Original Publication Date: Thursday, July 9, 2009
Filed Under: Calculated Column, Mark Miller, Workshops

 

One of the annoyances of trying to use a file name in a calculated column is that the “Name” column can not be used in a calculation. This limits the ability to create a dynamically generated link when trying to trigger LyteBox or build a URL string.

In this screencast, I’ll show a manual way to handle this when entering the metadata information for an item. Tomorrow, I’ll show a technique for using workflow to generate the column entry so there will be less chance of error.

“Create a SharePoint Multi-Media Resource Center” is a live, hands-on workshop for those needing a media center on their site. Please join us for the next scheduled workshop. You can read more information about the content of the workshop or register below.

Embed this screencast on your site.

<object name="Video" classid="clsid:6BF52A52-394A-11D3-B153-00C04F79FAA6" codebase="http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=6,4,5,715" standby="Loading Microsoft Windows Media Player components..." type="application/x-oleobject"  width="528" height="429"> <param name="url" value="http://content.screencast.com/users/EndUserSharePoint/folders/SharePoint%20-%20Workshop%20Demos/media/417d3382-4aef-46f7-a0b3-7200b3e9544f/2009-07-21-MediaCenter.wmv"></param> <param name="AutoStart" value="0"></param> <param name="ShowControls" value="true"></param> <param name="uiMode" value="full"></param> <param name="playCount" value="1"></param> <param name="CurrentPosition" value="0"></param> <embed name="Video" type="application/x-mplayer2" src="http://content.screencast.com/users/EndUserSharePoint/folders/SharePoint%20-%20Workshop%20Demos/media/417d3382-4aef-46f7-a0b3-7200b3e9544f/2009-07-21-MediaCenter.wmv" autoStart="0" showcontrols="1" uimode="full" playcount="1" currentposition="0" width="528" height="429"></embed> </object>

Code from Calculated Column

="<DIV><a href='../"&[File Name]&"' rel='lyteframe' title='EndUserSharePoint.com' rev='width"&":"&"900px"&";"&" height"&":"&"500px"&";"&"' ><img src='../../ResourcesMediaCenter/playbtn-icon.gif' border='0' width='24' height='24' alt='Click to View the Screencast' /></a></DIV>"


Spread the word...
  • Digg
  • Facebook
  • StumbleUpon
  • Google Bookmarks
  • LinkedIn
  • Reddit

Articles in this series

Notify me of comments to this article:

Comments

6 Responses to “SharePoint Multi-Media Center: Dynamically generate a URL string”

  1. SharePoint Daily on July 10th, 2009 8:05 am

    Office 2010: The Movie, Chrome OS May Hurt Android, Will Microsoft Unveil Office Web Apps at WPC?…

    Top News Stories Report: Microsoft To Unveil Office Web Apps (Channel Web) Microsoft will unveil the…

  2. SharePoint Multi-Media Center: Content Architecture | End User SharePoint on July 14th, 2009 3:00 am

    [...] SharePoint Multi-Media Center: Dynamically generate a URL string [...]

  3. Alison on July 28th, 2009 11:52 am

    Hi, unless I’ve missed it, I couldn’t find the demo with the dynamic link created via a workflow.

    Is it available ?

    Thanks a lot
    Alison

  4. EndUserSharePoint on July 28th, 2009 4:23 pm

    Alison – Not sure what you are referring to. — Mark

  5. Alison on July 30th, 2009 4:58 am

    Hi, thanks for your reply.
    At the end of this webcast (3 mins 20), you say watch tomorrow to see how to automatically generate the file name using a workflow. Maybe I’m looking in the wrong place ?

    Thanks very much
    Alison

  6. EndUserSharePoint on July 31st, 2009 6:09 am

    Hi Alison – We’ve worked out an even better solution using jQuery that I’ll be posting next week. — Mark

Leave a Reply