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 21, 2018

README.md

Traffic Light (Red-Yellow-Green) Status Indicator

Summary

This sample displays a traffic light style (Red-Yellow-Green) status indicator based on the value of a choice/text column (to use a lookup column, switch all occurrences of @currentField to @currentField.lookupValue).

screenshot of the sample

The text values for the column are expected to be Red, Yellow, or Green. Any other values won't be shown.

View requirements

  • This format can be applied to a text/choice column and expects the values to be Green, Yellow, Red, or anything else

Sample

Solution Author(s)
text-ryg-status-indicator.json Travis Lingenfelder

Version history

Version Date Comments
1.0 November 27, 2017 Initial release
1.1 March 22, 2018 Simplified logic
1.2 August 20, 2018 Updated to use Excel-style expressions and theme classes

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

For more information on using this custom formatting see the article SharePoint Modern List Traffic Light (Red-Yellow-Green) Status Indicator Column

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