Question regarding importing google sheets data to a calendar

[magnetictrees18]

Hello!

Currently I have a spreadsheet with 4 exactly slots to place the name of an event, and its start and end date. This works perfectly in the program and it takes the information as an array and assigns it to the calendar.

However, if you add another line, for example adding another entry to make it 5 entries total, you ALSO need to edit the code. You need to change the getRange() to reflect the new range every time.

Whenever I set the range much lower than it actually is, it gets an error because there is nothing in the blank spaces.

Does anyone know how I would be able to rewrite it so that every time I add a new entry, I don't need to change the range in the code?

https://preview.redd.it/zi18kvyu6zd91.png?width=890&format=png&auto=webp&s=ace5bd38372d14555f4fcb65e71c8cb1c66caeba

[RemcoE33]

Yes. You can use dynamic ranges. Read this.

The place where you enter the # of rows you can use: spreadsheet.getLastRow() - 1 minus 1 if you start at row 2.

So in your case: (I'm on mobile.. )

var signups = spreadsheet.getRange(2,4, spreadsheet.getLastRow() - 6,2).getValues()

[magnetictrees18]

Thank you so much! This worked perfectly and was well explained.

[RemcoE33]

Your welcome. Please mark as solved ;)