Schedule repetition frequency of a transaction or event based (daily, monthly or yearly). Kindly provide suggestions or feedbacks for improvements. Especially, I want to workout more edge case issues.
// Query for every record in “Table”
let table = base.getTable(“Table”);
let query = await table.selectRecordsAsync();
let srcDtl = await input.recordAsync(‘Select the row to repeat?’,table);
if (srcDtl) {
// Begin logic of creating repetitive transactions
// Replace ‘Field’ with name of the field in your table
let field = srcDtl.getCellValueAsString(‘Field’);
output.markdown("#### You selected “”+field+"" as the source budget");
// Display frequency options
let freq = await input.buttonsAsync('Frequency',['Daily','Monthly','Yearly']);
// Replace 'Date' with date field in your table
let srcDate=new Date(srcDtl.getCellValue("Date"));
let nextDate = new Date(srcDtl.getCellValue("Date"));
let ctr=0;
// Obtain how many times the operation is to be repeated
let freqLen = await input.textAsync('How many times to repeat this?');
// Check if entered value is a number
if(!isNaN(parseInt(freqLen))) {
for(;ctr<=parseInt(freqLen)-1;ctr++) {
// Based on frequency type vary the next date
if(freq=='Daily') {
nextDate.setDate(nextDate.getDate()+1);
} else if(freq=='Monthly') {
if(nextDate==srcDate) {
nextDate.setMonth(srcDate.getMonth() +1);
} else {
// Set date to original date
nextDate.setDate(srcDate.getDate());
// Add a month
nextDate.setMonth(nextDate.getMonth() +1);
// Edge case: If date is not matched with src date, means month rolled over to next one
if(nextDate.getDate()!=srcDate.getDate()) {
// Edge case: Push back date one day before to roll back to last date of previous month
nextDate.setDate(nextDate.getDate()-1);
}
}
} else if(freq=='Yearly') {
nextDate.setFullYear(nextDate.getFullYear()+1);
}
// Insert records in 'Table'. Add any other fields that you want to copy in to the recurring record
await table.createRecordAsync({
"Field": field,
"Date":nextDate,
})
}
output.markdown('#### Inserted '+ctr+' records, *'+freq+'* starting from '+srcDtl.getCellValue("Date"));
} else {
// If entered value is NOT a valid number display error and end
output.markdown('#### Re-run this script and enter ONLY a number in the above field!');
}
// End logic of creating repetitive transactions
}
