Hello Folks,
The batch feature here works perfect and it creates 50 records in milliseconds and goes on till it finishes the total number of episodes ( EPS ), I have a tiny issue with the numerical calculation, it doesn’t work well with pattern adds to the date
So if you run this batch script to add 7 days to each date the result is not accurate
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)
{
myDate.setDate(myDate.getDate() + 7);
await episodesscheduletable.createRecordAsync({
"Release Date": myDate
});
RowsToCreate = RowsToCreate -1
}
```
}
The result
14/3/2021
21/3/2021
27/3/2021
3/4/2021
10/4/2021
So 14+7 = 21
21+7= 28 not 27
Is there something wrong with my code, I just want to add 7 to each date add up, but it’s not working properly, Do you have a quick fix for that?
Thank you guys for your continuous help and support. Appreciate your input
waiting for your reply.
