Hello all.

I have a sharepoint list of “changes” made at my workplace. Currently, I made a view which displays the changes for the current week, as well as a view displaying changes for the next week. This is based on the week number of the changes, not within a set 7 day time frame as this would maybe miss out changes of the coming monday if you were to look at the view on Friday.

I calculated the week number of each change by using the “FROM” field of the change i;e “Date_Start”. I then compared this to another varible called week current which calculates the week number we are presently in so it changes by itself, ie doesnt use a static value; if they are equal this the change is displayed in the view. I did the same thing basically for the nex week view except I added 1 as it would be the week number + 1. 

The problem arises now that each time we enter a new week, the changes from the previous week are carried through and the list doesn’t update unless I make a manual change/ edit to refresh things. I found out its because “FROM” is static so never auto updates, or calculated values don’t auto update that is. Does anyone know how I can achieve what i did below using JSON, so that I dont need to manually refresh? 

​Hello all. I have a sharepoint list of “changes” made at my workplace. Currently, I made a view which displays the changes for the current week, as well as a view displaying changes for the next week. This is based on the week number of the changes, not within a set 7 day time frame as this would maybe miss out changes of the coming monday if you were to look at the view on Friday. I calculated the week number of each change by using the “FROM” field of the change i;e “Date_Start”. I then compared this to another varible called week current which calculates the week number we are presently in so it changes by itself, ie doesnt use a static value; if they are equal this the change is displayed in the view. I did the same thing basically for the nex week view except I added 1 as it would be the week number + 1.  The problem arises now that each time we enter a new week, the changes from the previous week are carried through and the list doesn’t update unless I make a manual change/ edit to refresh things. I found out its because “FROM” is static so never auto updates, or calculated values don’t auto update that is. Does anyone know how I can achieve what i did below using JSON, so that I dont need to manually refresh?       Read More

​