Forum Discussion
Problems with current week views and next weeks views in list
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?