Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Sharepoint 2013 Online HTML as Calculated Column

Posted on 2014-11-18
1
Medium Priority
?
1,118 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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
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…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

721 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