Add Hyperlink to Data Viewer Web Part
I had interest in the Data Viewer Web Part from a school who wanted to list the videos stored in their media server within their SharePoint portal. Their media server didn't have any native way of doing this, but they were familiar with the database structure so were interested in seeing if the web part could help them.
They really wanted to be able to display a link so that the users could click on it and then see the appropriate video. I thought that this sounded like a good idea and added a column formatting option so that a column could be turned into a hyperlink, optionally displaying another column as the hyperlink text. This worked perfectly for them and they are now using it to surface their videos in SharePoint.
The column formatting option only currently supports converting into hyperlinks and hiding a column (if being used for the text in the hyperlink), but I could easily extend it to support other types of formatting. However, most formatting could be done in the SQL statement already by using the built in SQL formatting.
Managing Director / Founder
Richard started SalamanderSoft in 2007 after a successful career as a software developer. Wanting to start his own company and with experience in integrating school systems he set out to build the best integration system for schools and to exceed customer expectations. He starting out on his own, doing all the coding, support and sales until finally the growing number of customers meant he needed to start growing the team. He is still heavily involved in coding the core Integration Suite product in addition to running the company and being the first point of contact for prospective customers.