Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Multiple Dates per Entry in Calendar

Topic Labels: Data Formulas Views
Solved
Jump to Solution
985 2
cancel
Showing results for 
Search instead for 
Did you mean: 
LaurenMaine
6 - Interface Innovator
6 - Interface Innovator

Hi all--

We are a publishing company and we sometimes publish the same content multiple times throughout the year. We have a field set up "Publish Date" that shows all of the dates. The problem is when I try to have these feed into our general publishing calendar view, I can either only choose between the Minimum date (the first date) or the Maximum date (the last one), I can't figure out how to show both dates on the calendar (without having it span across the entire time in between the two dates). Is there possibly a way to separate the dates into separate entries and enter them into the calendar that way? Thanks in advance!

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hmm, perhaps you could try hardcoding a bunch of rollup fields like so:

Screenshot 2024-07-13 at 6.23.26 PM.png
And the formulas would be variations of the following, where you update "1,1" to "2,2" etc:

 

DATETIME_PARSE(
  ARRAYSLICE(values, 1,1) & ""
)

 

And in your Calendar view you'd use multiple date fields:

Screenshot 2024-07-13 at 6.23.06 PM.png

Link to base

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hmm, perhaps you could try hardcoding a bunch of rollup fields like so:

Screenshot 2024-07-13 at 6.23.26 PM.png
And the formulas would be variations of the following, where you update "1,1" to "2,2" etc:

 

DATETIME_PARSE(
  ARRAYSLICE(values, 1,1) & ""
)

 

And in your Calendar view you'd use multiple date fields:

Screenshot 2024-07-13 at 6.23.06 PM.png

Link to base

LaurenMaine
6 - Interface Innovator
6 - Interface Innovator

Got it, I think that worked! Thanks so much!!