Here’s what I have. You have to go into the code to update the name of the table you want to add records to (line 37), dates/times of the time slots (which are in arrays starting at line 39 where the ‘deepDiveDays’ array uses days of the week in numbers. i.e. if you had Mon, Tue, Wed, it would be [1,2,3]), and there is a spot for a field you’d want to customize on line 105 as well. Sorry it isn’t more user friendly at the moment. I’m working on a version that doesn’t rely on updating the code to make it work for other tables.
// Author: Andrew Heine
// SETTINGS ———————
const config = input.config({
title: 'Calendar signup slot generator',
description: 'A script to automatically generate preset weekly time slots for people to sign up for.',
// items: [
// input.config.select('deepDiveDaysConfig', {
// label: 'Days available',
// description: 'Days that we will have Deep Dive slots available',
// options: [
// {label: 'Mon', value: '1'},
// {label: 'Tues', value: '2'},
// {label: 'Weds', value: '3'},
// {label: 'Thurs', value: '4'},
// {label: 'Fri', value: '5'},
// ]
// })
// ]
});
const country = config.country;
// UTILITY ———————
// This function adds leading zeros for date formatting
Number.prototype.pad = function(size) {
var s = String(this);
while (s.length < (size || 2)) {s = "0" + s;}
return s;
}
// CONFIG ———————
let table = base.getTable('Shares/reviews'); // Pick what table to pull data from
var deepDiveDays = [4]; // need to automate some of this, but currently it's on the honor system that all these arrays will be the same legth
var deepDiveTimes = [
["08:35","08:55","09:15"]
];
var deepDiveTimesEnd = [
["08:55","09:15","09:45"]
];
let earliestDateToAdd = await input.textAsync('What is the earliest date you want to add records for? (YYYY-MM-DD)');
earliestDateToAdd = Date.parse(`${earliestDateToAdd}`); // Date format: YYYY-MM-DD
let weeksToAdd = await input.textAsync('How many weeks worth of review slots do you want to add?');
// INIT —————————
var foundStartDate = 0;
var recordsAddedCount = 0;
var today = new Date();
today = Date.now();
timeDifference = (earliestDateToAdd - today);
var startDate = new Date(Date.now() + timeDifference + 25200000);
var thisDate = new Date();
thisDate = startDate;
thisDay = thisDate.getDay();
for (i = 0; i < weeksToAdd * 7; i++) {
thisDay = thisDate.getDay();
for (j = 0; j < deepDiveDays.length; j++) {
if (thisDay == deepDiveDays[j]) {
thisDateNumber = thisDate.getDate().pad(2);
thisMonthNumber = thisDate.getMonth() + 1; // getMonth() starts with Jan being 0
thisMonthNumber = thisMonthNumber.pad(2);
thisYearNumber = thisDate.getFullYear();
thisDateFormatted = thisYearNumber + "-" + thisMonthNumber + "-" + thisDateNumber;
thisDaySlots = deepDiveTimes[j];
thisDaySlotsEnd = deepDiveTimesEnd[j];
for (l = 0; l < thisDaySlots.length; l++) {
thisTimeSlot = thisDaySlots[l];
thisTimeSlotEnd = thisDaySlotsEnd[l];
thisTimeSlotFormatted = thisDateFormatted + " "+thisTimeSlot;
thisTimeSlotEndFormatted = thisDateFormatted + " " + thisTimeSlotEnd;
await table.createRecordsAsync([
{
fields: {
'Date/Time': thisTimeSlotFormatted,
'End Date/Time': thisTimeSlotEndFormatted,
'Event type': { name: 'Team mtg - OPEN SLOT'},
},
},
])
console.log("Added: "+thisTimeSlotFormatted);
recordsAddedCount++;
}
break;
}
}
thisDate.setDate(thisDate.getDate() + 1);
}
output.text('Done! '+recordsAddedCount+' records added –');
