Find file History
thechriskent Expression updates (#78)
* Updated number-quiz-smiley to use Excel-style expression

* Updated text-isbn-image to use Excel-style expression

* Updated text-wrap-format schema

* Updated generic-staticmap to use Excel-style expressions

* Updated generic-svgicon-format to use Excel-style expressions

* Updated generic-hyperlink-values to use Excel-style expressions

* Updated generic-hyperlink-thumbnail to use Excel-style expressions

* Updated number-conditional-format to use Excel-style expressions

* Updated number-piechart to use Excel-style expressions and theme classes

* Updated picture-roundimage-format schema

* Updated text-conditional-format to use Excel-style expressions, theme color, and fixed an issue

* Updated yesno-checkmark to use Excel-style expressions

* Updated yesno-checkmark-format to use Excel-style expressions

* Updated person-roundimage-format to use Excel-style expressions

* Updated text-ryg-status-indicator to use Excel-style expressions and theme classes

* Updated date-range-rag to use Excel-style expressions, theme colors, and simplified calculations

* Updated currecy-symbol-concatenation to use Excel-style expressions

* Updated generic-project-management to use Excel-style expressions and theme color classes

* Updated number-trending-icon to use Excel-style expressions

* Additional cleanup
Latest commit f3d1f28 Aug 20, 2018

README.md

Turn field values into hyperlinks

Summary

This example shows how to turn a text field that contains stock ticker symbols into a hyperlink that targets the Yahoo Finance real-time quotes page for that stock ticker. The example uses a + operator that appends the current field value to the static hyperlink http://finance.yahoo.com/quote/. You can extend this pattern to any scenario in which you want users to view contextual information related to an item, or you want to start a business process on the current item, as long as the information or process can be accessed via a hyperlink parameterized with values from the list item.

screenshot of the sample

View requirements

  • This format can be applied to any column type

Sample

Solution Author(s)
generic-hyperlink-values.json SharePoint Team

Version history

Version Date Comments
1.0 November 2, 2017 Initial release
1.1 August 20, 2018 Switched to Excel-style expressions

Disclaimer

THIS CODE IS PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.


Additional notes

This sample is also covered in the main documentation around Column Formatting

An additional version using Abstract Tree Syntax (AST) is also provided for environments where the Excel-style expressions are not supported.