James Hauge
MIS
I need to make a Calendar list that has multiple start/stop dates (no need times) that skips weekends...
The thing is, this is for scheduling construction crews. Sometimes they will have a week on a job site at a time sometimes a day here and a day there. I have no idea how many date ranges will be needed so i can't just make date ranges for all options...
My first thought was with database design, having a one to many table design where the main info is on one table and the dates are all on another table with a one to many relationship based on job number...
Any thoughts to get me going in the right direction would be helpful!
btw, we're using sharepoint online as part of Office 365 for business...
Thanks!
The thing is, this is for scheduling construction crews. Sometimes they will have a week on a job site at a time sometimes a day here and a day there. I have no idea how many date ranges will be needed so i can't just make date ranges for all options...
My first thought was with database design, having a one to many table design where the main info is on one table and the dates are all on another table with a one to many relationship based on job number...
Any thoughts to get me going in the right direction would be helpful!
btw, we're using sharepoint online as part of Office 365 for business...
Thanks!
