Forum Discussion
replace text in field in json css
Hi shawn_fielding,
For the next column, try use a calculated field.
Example:
Calculated Field Situation formula:
IF([Age]>=21;"Allowed drink beer";IF([Age]>=18;"Allowed in some countries";Cant' drink beer))
| Age | Situation |
| 10 | Cant' drink beer |
| 15 | Cant' drink beer |
| 18 | Allowed in some countries || 22 | Allowed drink beer |
https://support.office.com/en-us/article/examples-of-common-formulas-in-sharepoint-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3?ui=en-US&rs=en-US&ad=US
To use icons or images using JSON, start using the samples:
https://github.com/sharepoint/sp-dev-list-formatting/tree/master/column-samples
Hi shawn_fielding,
For the next column, try use a calculated field.
Example:
Calculated Field Situation formula:
IF([Age]>=21;"Allowed drink beer";IF([Age]>=18;"Allowed in some countries";Cant' drink beer))
| Age | Situation |
| 10 | Cant' drink beer |
| 15 | Cant' drink beer |
| 18 | Allowed in some countries |
| 22 | Allowed drink beer |
https://support.office.com/en-us/article/examples-of-common-formulas-in-sharepoint-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3?ui=en-US&rs=en-US&ad=US
To use icons or images using JSON, start using the samples:
https://github.com/sharepoint/sp-dev-list-formatting/tree/master/column-samples
Paulo Junior you are a genius! Thank you! Using calculated fields based off the text fields was exactly what I needed, but a little css to make it look pretty. Works beautifully!
