Jan 22 2020 07:16 AM - edited Jan 22 2020 08:18 AM
Hi all,
I am trying to replace the text in a list field depending on the content in the next column. I don't even know if I am close, but I am struggling to figure out how to do it. See my json below.
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "@currentField",
"style": {
"font-weight": "=if([$Level_x0020_2_x0020_Term] !='','','bolder')",
"font-size": "=if([$Level_x0020_2_x0020_Term] !='','12px','16px')",
"font-style":
"=if([$Level_x0020_2_x0020_Term] !='','italic','')",
"display": "=if([$Level_x0020_2_x0020_Term] !='','none','')"
"content": "=if([$Level_x0020_2_x0020_Term] !='','↳','')"
}
}
If this is not possible, I would be fine with just replacing the text with an image I have as well.
Jan 22 2020 09:46 AM - edited Jan 22 2020 09:47 AM
SolutionHi @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 |
See more about SharePoint calculated fields formulas
To use icons or images using JSON, start using the samples:
https://github.com/sharepoint/sp-dev-list-formatting/tree/master/column-samples
Jan 23 2020 07:58 AM
@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!
Dec 20 2020 07:30 PM
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
Jan 22 2020 09:46 AM - edited Jan 22 2020 09:47 AM
SolutionHi @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 |
See more about SharePoint calculated fields formulas
To use icons or images using JSON, start using the samples:
https://github.com/sharepoint/sp-dev-list-formatting/tree/master/column-samples