Solved

Sharepoint 2013 Online HTML as Calculated Column

Posted on 2014-11-18
1
576 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Suggested Solutions

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

733 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