List of Dates Between Dates

[Loqode]

Hi all!

I’m building a boat syndication app that allows boat shareholders to book days on their boat.

Is there a quick Javascript snippet I can use to create a list of all dates between the Start and End date of the booking?

E.g.

• Start 24th
• End 28th
• List of days between = 25th, 26th, 27th.

I’ve done this without code, but it has added quite a few columns to my table and isn’t really scalable…
I feel like there’s a short Javascript snippet of code that would solve this for me?

Any help would be much appreciated!

Cheers,
Marco

[Darren_Murphy]

I would use a Helper Table to dynamically generate the list. Is there a known maximum number of days?

[Loqode]

Thanks for the quick response Darren!

What’s a Helper Table?
And how would I implement it?

As for the max duration, I don’t expect a single booking to exceed 7 days, but there’s no hard limit so I wanted to build in redundancy incase someone wanted to book 2-3 weeks onboard.

[Darren_Murphy]

Gimme 10-15 mins, I’ll make a quick video.

[Loqode]

Legend, much appreciated!

[Darren_Murphy]

Here you go…

Also, just to answer this question…

@Loqode

What’s a Helper Table?

Have a read of the below thread:

How would you describe a helper table?

Hi all, ‘helper table’ seems a way to get things done with Glide as ‘invented’ by users. I don’t think I find it in any official Glide docs. How would you describe a ‘helper table’ and in what cases would you use it and how? Maybe this post + reactions can make it to the help section afterward

[Loqode]

Very clear explanation Darren, appreciate you taking the time to explain.

I’ll experiment now and see how I go, seems like a solid alternative to my column overload

[Loqode]

Hi Darren, looks like your solution works quite well for my use-case.

Since the Start and End dates are user-specific columns on another form, I was able to simplify your solution even further by replacing the user-specific Start & End dates in the Helper table with a Single Value column that pulls from the form itself… If that makes sense?

Anyhow, thanks your help!

[Darren_Murphy]

@Loqode

I was able to simplify your solution even further by replacing the user-specific Start & End dates in the Helper table with a Single Value column that pulls from the form itself… If that makes sense?

Yep, that makes perfect sense. I was just giving you a self-contained example.

Also, you’ve probably also figured out that the first 3 columns aren’t strictly necessary. You could replace those 3 with a single Number type column, and number the rows manually. I just do it the way I showed in the video out of habit. I also think it’s a bit more elegant