Forum Discussion
replace text in field in json css
- Jan 22, 2020
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
Before replacement, I feel that JSON format optimization will be more conducive to operation 🙂
You can format your JSON first here https://www.jsonformatting.com