Solved

Sharepoint 2013 Online HTML as Calculated Column

Posted on 2014-11-18
1
470 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

867 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now