Repeating Events the same Monday of the month

1

Hello!

Is there a formula to add rows to a table that repeat automatically the first Monday of each month?
(similar to GCal where you repeat an event and have the option to repeat at will)

2

You can do this with the relative dates pack Relative dates Pack, extend Coda with Relative... | Coda

Create a button that does what you want, and add this formula to disable it:
Today() != EndOfMonth(Today(), -1) + Days(1)

Then set up an automation to click the button every day.

Edit: Sorry, my response is for the first of every month, not the first Monday!

1 Like
3

hi @Miguel_Gomez ,

I guess this question has be put forward in many variations already and that therefore the pack suggestion of @Samuel_Langford is very useful. If you want to generate a list of values without a pack see my contribution below.

to get all Mondays in any given list of dates - I constructed this list via the Sequence(), you apply:

Sequence(Today(),Today()+365).Filter(
  CurrentValue.Weekday().Contains(2)).
  FormulaMap(CurrentValue.ToDate())

When you only want to have this list for unique months, you add an element to this filter in our case we ask also if the day is a number between 1 and 7

Sequence(Today(),Today()+365).Filter(
CurrentValue.WeekdayName().Contains("Monday") and 
CurrentValue.Day().Contains(1,2,3,4,5,6,7)).ForEach(CurrentValue.ToDate())

In my screenshot I replaced the Weekday() logic for a weekdayName() since I don’t know what kind of week logic you follow.

image
image1552×555 67 KB

Anyway a pack (or even better a native Coda integration) will for most users likely be the way forward, cheers, Christiaan

3 Likes
4 
Today() =  Sequence(Today(),Today()+31).Filter(
CurrentValue.WeekdayName().Contains("Monday") and 
CurrentValue.Day().Contains(1,2,3,4,5,6,7)).First()

The above part you need in your automation as I described here:

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.