There is a meeting that occurs every week, but has a rotating list of members. So one person from each department goes one week, and the next week it is a different person from each department, and so on.
Right now I have 2 SharePoint lists set up, one for the current week’s schedule (which has a column for each department, and one name in each column), and another that has the complete list of names (where each column is a department, and in those columns are the names of the people in that department).
Checks if the current schedule is out of date (it’s an if statement that will evaluate true every Monday morning.)
- If the current schedule is out of date, then it takes the names in the current (now outdated) schedule, finds them in the second list which contains all the names, gets the next name for each department, and updates the list items in the current schedule with the new names. This is all done using the SharePoint REST API (it makes AJAX calls for creating and deleting list items)
- This ends the “if” statement, and the rest of the code runs as usual
If schedule is up to date, it then takes the names in the current schedule and looks them up in the second list with all the names. It then populates a table that goes 14 weeks into the future with what the schedule will be for each week.