I have 2 tables. One called Booked jobs and one called Planning
I have a form from which a user can add one record at a time to the Booked jobs table.
Each booked job could be a service from a list of 3 services: Origin, Destination or Both.
For the Origin service there is a Start Date and an End Date.
For the Destination service there is a Start Date and an End Date.
For the Both service there is a Start Date Origin, End Date Origin, Start Date Destination and End Date Destination.
For each date in one of the ranges mentioned above a new record would need to be created in the Planning table with the respective date and some other details from the Booked job.
What I have until now is the following:
let table = base.getTable('Booked jobs');
let query = await table.selectRecordsAsync();
let destination = base.getTable('Planning');
let prev = input.config();
let typeService = prev.typeService;
let startOS = prev.StartOS;
let endOS = prev.EndOS;
let startDS = prev.StartDS;
let endDS = prev.EndDS;
const _MS_PER_DAY = 1000 * 60 * 60 * 24;
// a and b are javascript Date objects
function dateDiffInDays(a, b) {
// Discard the time and time-zone information.
const utc1 = Date.UTC(a.getFullYear(), a.getMonth(), a.getDate());
const utc2 = Date.UTC(b.getFullYear(), b.getMonth(), b.getDate());
return Math.floor((utc2 - utc1) / _MS_PER_DAY);
}
switch (typeService) {
case 'Origin':
let os = [];
let diff = dateDiffInDays(startOS,endOS);
for (let i = 0; i < diff; i++) {
let startDate = new Date(startOS);
let newDate = new Date(startDate.setDate(startDate.getDate() +i));
os.push(newDate.toISOString().substring(0,10));
}
console.log('Origin Case');
if (os) {
for (let day of os) {
let recordId = await destination.createRecordAsync(
{
'2.Jobs': [{id: table.id}],
'Start Address': `address 1`,
},
)
console.log("Sucess!");
}
}
break;
case 'Destination':
console.log('Destination');
break;
case 'Both':
console.log('Both');
break;
default:
console.log(`Sorry, we are out of ${typeService}.`);
}
I keep getting stuck somewhere.
How can I achieve this?
