Gallery
Share
Explore

icon picker
Based on a Twitter post

Loud does not equal right
Christiaan Huizer
the post I reflected upon →

⁠
The Coda Guy on Twitter / X
Want to know a Coda super-trick?While making my Habit Tracker super template in @coda_hq I needed a table with one row per day in 2023. Manually adding those rows would have been a nightmareHeres the formula I wrote to do it in a single button press#nocode #buildinpublic pic.twitter.com/JJau8na7dQ— The Coda Guy (@thecodaguy) December 19, 2022
twitter.com
⁠
⁠


⁠
Scott - the CodaGuy
⁠
→
Sequence(
date(2023,1,1),
EndOfMonth(Today(),12)
).ForEach(CurrentValue.ToDate()).
Foreach(
AddRow([Every Day],[Every Day].Day,CurrentValue))

⁠

⁠
July 30 - August 6, 2024
⁠
⁠
⁠
Brian - Coda HQ Employee
⁠
→
Sequence(
_DP.Min(),
_DP.Max()).
ForEach(
AddRow(
[Every Day],
[Every Day].Day,
CurrentValue
))

⁠

⁠
Christiaan 2023
⁠
→
Sequence(
Date(2023,1,1),
Date(2023,12,31)).
ForEach(
AddRow(
[Every Day],
[Every Day].Day,
CurrentValue
))
⁠
⁠
A year as of today
⁠
→
Sequence(
Today(),
Date(
Today().Year(),
Today().Month() + 12,
Today().Day())
).ForEach(AddRow([Every Day],[Every Day].Day,CurrentValue))

The blog that explains a bit of back ground ⤵️

⁠
How to Coda your year dates?
Select your code wisely
huizer.medium.com
⁠
⁠

⁠
Delete rows
⁠
⁠
Every Day
Day
weekdayName
IsoWeekNumber
USAWeekNumber
There are no rows in this table
⁠

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.