User Profile
Rense620
Copper Contributor
Joined Aug 17, 2022
User Widgets
Recent Discussions
Re: JSON change color of row based on date column
I tried this code but it doesn't work. { "schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json", "additionalRowClass": "=if([$Modified] < @now && [$Modified] >= @now + 172800000, 'sp-field-severity--blocked', if([$Modified] < @now && [$Modified] >= @now - 86400000, 'sp-field-severity--warning' , ''))" } The color must be yellow from 190 day after the checked date. And after 200 days it must be red for ever till the document is checked and the date is changed.3.2KViews0likes2CommentsJSON change color of row based on date column
I am looking for a JSON code that changes de color of the ROW to red if it is 200 days after the date of a column. So the column says 10/12/2022 (dd/mm/jjjj) And if it today 200 days after that date, the color of the whole row must be read. I have searched a lot but cannot find some based on the date of a column. Please is there somebody who can help me? RenseSolved3.4KViews0likes3CommentsConditional form format with two conditions not working
Hopefully somebody can help me with this. I have a list, and a column named "type" with 3 choices. Early, Late, Weekend. I am trying to hide a field in the New Item form based on these three. The fieldname/column name to hide has the name "Working hours 1" I tried this, but it still shows the field "Working hours 1" if nothing is chosen. =if([$Soortdienst] == 'Early' || 'Weekend', 'true', 'false') What I want is that only the field is shown when the type Early OR Weekend is chosen. So nothing chosen yet, nothing wil be shown.Solved4.7KViews0likes5Comments
Recent Blog Articles
No content to show