@NFGK I wrote a script that might solve your task of splitting jobs through work days.
//collect input
let Rec = input.config()
//load record
let table = base.getTable("Jobs")
let record = await table.selectRecordAsync(Rec.RecID)
//Declare variables
let start = new Date(Rec.start)
let end = new Date(Rec.end)
let job = Rec.job
let range = [] //keeps dates
let rangeDays = [] //keeps week days
let foundRange = 0 //length of current subrange
//Check if the range is correct
if(end >= start) {
//The loop to build an array of dates excluding Saturdays and Sundays
for(let d = start; d <= end; d.setDate(d.getDate() + 1)) {
if(d.getDay() == 6 || d.getDay() == 7) {
d.setDate(d.getDate() + 1)
continue
}
range.push(d.toISOString().substr(0,10))
rangeDays.push(d.getDay())
}
//Loop through the array, create new records, and splice
while(range.length !== 0) {
if(rangeDays.indexOf(5) !== -1) { //range has Friday
foundRange = rangeDays.indexOf(5)+1
console.warn(foundRange)
await table.createRecordAsync({
"Job": job,
"Start": range[0],
"End": range[range.slice(0, foundRange).length - 1],
})
} else { // range doesn't have Friday
foundRange = rangeDays.length
await table.createRecordAsync({
"Job": job,
"Start": range[0],
"End": range[range.length-1],
})
}
//splice ranges
range.splice(0, range.slice(0, foundRange).length)
rangeDays.splice(0, rangeDays.slice(0, foundRange).length)
}
//delete initial record
await table.deleteRecordAsync(Rec.RecID)
}
In my table I'm using 3 fields:
- Job - the name of the job,
- Start - starting date
- End - ending date
Script uses 4 variables: 3 reflecting the fields, and RecordID()
Hope this will be useful.
