Add a number of days to a date script

There are couple things I noticed in your script:

• Moment.js is a library/extension thing that is not part of standard Javascript. You can’t use Moment unless you import the library.
• As designed, your script will create a new record for an episode regardless of whether a record for that episode has already been created.
• Your script starts a loop at 0 and then is explicitly told to do nothing when the index is 0. You could just start at 1.

Try the code below:

const importTable = base.getTable('Titles');
const importQuery = await importTable.selectRecordsAsync();
const episodesScheduleTable = base.getTable('Episodes Schedule');
const episodesScheduleQuery = await episodesScheduleTable.selectRecordsAsync()
const episodesScheduleNames = episodesScheduleQuery.records.map(x => x.name)
const patterns = [
    {pattern: 1, add: 1},
    {pattern: 2, add: 6},
    {pattern: 3, add: 5},
    {pattern: 4, add: 4},
    {pattern: 5, add: 3},
    {pattern: 6, add: 2},
    {pattern: 7, add: 1},
]

for (let record of importQuery.records) {
    var rowCount = record.getCellValue('EPS');
    let current = 1
    
    while (current <= rowCount) {
        var startDate = new Date(record.getCellValue('Start Date'))
        var year = startDate.getFullYear();
        var month = startDate.getMonth();
        var day = startDate.getDate();
        var pattern = record.getCellValueAsString('Release Pattern')
        var add = patterns.filter(x=> Number(x.pattern) == Number(pattern))[0].add
        var fullName = record.getCellValue('English Title') + ' ' + record.getCellValue('Season') + '.' + current
        
        if(!episodesScheduleNames.includes(fullName)) {
            var newDate = new Date(year, month, day + add*current);
            
            await episodesScheduleTable.createRecordAsync({
                "Name": fullName,
                "Release Date": newDate
            })
            output.text(`New record for ${fullName} created!`);
        }
        current++
    }
}

Let me know if that works.

const importTable = base.getTable('Titles');
const importQuery = await importTable.selectRecordsAsync();
const episodesScheduleTable = base.getTable('Episodes Schedule');
const episodesScheduleQuery = await episodesScheduleTable.selectRecordsAsync()
const episodesScheduleNames = episodesScheduleQuery.records.map(x => x.name)
const patterns = [
    {pattern: 1, add: 1},
    {pattern: 2, add: 6},
    {pattern: 3, add: 5},
    {pattern: 4, add: 4},
    {pattern: 5, add: 3},
    {pattern: 6, add: 2},
    {pattern: 7, add: 1},
]

for (let record of importQuery.records) {
    var rowCount = record.getCellValue('EPS');
    let current = 1
    
    while (current <= rowCount) {
        var startDate = new Date(record.getCellValue('Start Date'))
        var year = startDate.getFullYear();
        var month = startDate.getMonth();
        var day = startDate.getDate();
        var pattern = record.getCellValueAsString('Release Pattern')
        var add = patterns.filter(x=> Number(x.pattern) == Number(pattern))[0].add
        var fullName = record.getCellValue('English Title') + ' ' + record.getCellValue('Season') + '.' + current
        
        if(!episodesScheduleNames.includes(fullName)) {
            var newDate = new Date(year, month, day + add*current);
            
            await episodesScheduleTable.createRecordAsync({
                "Name": fullName,
                "Release Date": newDate
            })
            output.text(`New record for ${fullName} created!`);
        }
        current++
    }
}

Hi @Kamille_Parks , Thank you so much for your support.

I have developed the script using a batch function to query create 50 records per time, I have a slight problem here with date calculation increment

so with date calculations sometimes it doesn’t give the right value like
7/7/2021 + 7 = 14/7/2021
14/7/2021 + 7 = 20/7/2021 ( which is the wrong value ) the value here should be 21/7/2021
That’s the code I use
From my season level, Having some parameters like
1- Start Date
2- Pattern Release
3- No of Episodes
I tell the code what to follow in each scenario, The thing is with a simple increment of day calculation coding, It doesn’t do the job correctly
Like Date 7/7/2021 + 7 = 14/7/2021, 14/7/2021+7 = 21/7/2021 but the result I get is 20/7/2021, doesn’t make sense to me

// start delete table function
//--------------------------------------------------------------------------------------------------------
let table = base.getTable("Episodes Schedule");
let query = await table.selectRecordsAsync();
let records = query.records;
let recordCount = records.length;
let recordsToDelete = records.map(record => record.id);
let recordsDeleted = await batchAnd('Delete', table, recordsToDelete);
if (recordsDeleted !== null) {
output.markdown(`## ${recordsDeleted} records deleted from ${table.name}.`);
output.markdown(`These records can be restored from the trash bin within the next 7 days if you didn't mean to delete them.`);
};
async function batchAnd(action, table, records) {
let recordsActedOn = records.length;
switch (action) {
case 'Delete':
while (records.length > 0) {
await table.deleteRecordsAsync(records.slice(0, 50));
records = records.slice(50);
}
break;
default:
output.markdown(`**Please use 'Delete' as the "action" parameter for the "batchAnd()" function.**`);
recordsActedOn = null;
}
return recordsActedOn;
}
//--------------------------------------------------------------------------------------------------------
// End delete table function
const importTable = base.getTable("Titles");
const importQuery = await importTable.selectRecordsAsync();
const episodesscheduletable = base.getTable('Episodes Schedule');
const episodesScheduleQuery = await episodesscheduletable.selectRecordsAsync()
const episodesScheduleNames = episodesScheduleQuery.records.map(x => x.name)

let contactsToMake = [];
for (let record of importQuery.records)
{ 
let myDate = new Date();
let RowsToCreate=0; 
RowsToCreate= record.getCellValue('EPS') ;
myDate = new Date(record.getCellValue('Release Date'));
while (RowsToCreate>0)
{
output.text(myDate.getDate() + 7)
myDate.setDate(myDate.getDate() + 7); 
await episodesscheduletable.createRecordAsync({
"Release Date": myDate 
});
RowsToCreate = RowsToCreate -1 
}
}

Is there a way you can help me with that, this little tiny thing will make the whole process faulty
Please anyone with Scripting knowledge can help
Thanks alot guys
Ahmed Elagami