Solved

Sharepoint 2013 Online HTML as Calculated Column

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SharePoint 2013 Search 2 19
Sharepoint to FTP? 3 48
Sharepoint workflow on list 6 30
SharePoint sub-site searching and results. 8 21
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…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

744 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

13 Experts available now in Live!

Get 1:1 Help Now