Skip to main content

Hello Community!



I have the below script that will create X number of records based on the Episode Count, but I would like to tweak it to auto-number those episodes each time. For instance, Show 1 has 5 episodes, then each episode record would be numbered 1, 2, 3, 4, 5



//Tables





let projects = base.getTable('Shows');


let episodes = base.getTable('Episodes');





//Record Input





let record = await input.recordAsync('Please select a project', projects);





//Record variables





let quantity = record.getCellValue('Ep Count');


let order = record.id;





//New record array





let recArray = [];





//Iterate by quantity





if(quantity > 1){


    for(let i=0; i < quantity; i++){


        //Push to the array


        recArray.push({


            fields: {


                'Shows': [{id: order}],


            }


        });


    }





    //Create new records


    await episodes.createRecordsAsync(recArray);    


}


Any insight would be so incredible appreciated 🙏 Thank you!

Sounds like your Episodes table should have a Number field.



        recArray.push({


            fields: {


                'Shows': [{id: order}],


                'Episode Number': i + 1


            }


        });


its i + 1 and not just i because your loop starts i at zero, and I’m assuming you don’t want “Episode 0” to be a result.



Also FYI your script will throw an error if you ever try creating more than 50 episodes at once.

Kamille - you are amazing!



This worked perfectly. Thank you so much for the assist here!

Reply


Terms & Conditions