?
Solved

Sharepoint 2013 Online HTML as Calculated Column

Posted on 2014-11-18
1
Medium Priority
?
1,338 Views
Last Modified: 2014-11-19
I have a list of work orders from a production system in a Sharepoint List.
I wish to concat the work order to the URL of the production system site in order to render a clickable link directly from the Sharepoint list.
I see some have used the workaround as per http://sharepoint.rackspace.com/calculated-columns-tutorial
and http://sharepointhannah.wordpress.com/2014/06/11/adding-an-image-link-via-calculated-column-on-a-list-with-html-directory-list-solution/ but
cannot get the column to render after I have added the html tags.  Here is what the field setup looks like with just a static test URL.  Calculated Column Test HTML Markup.  And here is the result - no error, but no data returned as per the blogs I was able to find.  Result of Calculated Column Test Attempt
Thank you
0
Comment
Question by:LebIT
1 Comment
 

Accepted Solution

by:
LebIT earned 0 total points
ID: 40452963
Did get a resolution from the MS Office 365 Community as per this link.

http://community.office365.com/en-us/f/154/p/278604/851104.aspx#851104

To follow up final solution, my code was missing both the single quotes and a description between the tags.  For what its worth, here's the final logic I used in that column and it does exactly what we need, opening the link to another system in a new tab.

The final column (red arrow) "Work Order" with the link and a mouse-over 'tooltip' using the html title attribute with the work order.

Working Link
The code logic to only display a link when a work order id exists.

Code
The edit column final settings that work correctly.

Calculated Column Final Settings
And the new link opened from SharePoint Online to another system in a new tab.

External System Link
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…

594 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question