Skip to content
Gallery
Coda Template : Days, Weeks and Months
A go to template on date related issues
Days
Weeks
Months
Extra
Share
Explore
Extra

icon picker
Archiving Dates

Once in a while you want to keep track of the dates and the users that confirmed something. Keeping track of dates on row level is a practical application of ModifyRows(). However if you simply use the basic formula, it looks ugly with a comma in front of the first item.
Below the ugly and three correct formula variations, up to you how you like it. However as you can see, the application of the The Last only works well with the The Straight Variation
By using IfBlank(List()) you avoid the ugly comma in front of an item.
Archiving Dates
Time
ConfirmedBy
the Ugly
The Straight
LeftToRight
RightToLeft
The Last
1
⁠
8/26/2021 4:45:20 PM⁠
⁠
⁠
8/26/2021 4:45:19 PM⁠
⁠
⁠
8/26/2021 4:45:15 PM⁠
⁠
⁠
8/26/2021 4:45:14 PM⁠
⁠
⁠
8/26/2021 4:45:12 PM⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
Click me
Click me
Click me
Click me
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
→
⁠
8/26/2021 4:45:20 PM⁠
⁠
⁠
8/26/2021 4:45:19 PM⁠
⁠
⁠
8/26/2021 4:45:15 PM⁠
⁠
⁠
8/26/2021 4:45:14 PM⁠
⁠
⁠
8/26/2021 4:45:12 PM⁠
⁠
2
⁠
8/26/2021 4:50:05 PM⁠
⁠
⁠
8/26/2021 4:50:08 PM⁠
⁠
⁠
8/26/2021 4:50:08 PM⁠
⁠
⁠
8/26/2021 4:50:09 PM⁠
⁠
⁠
8/26/2021 4:50:09 PM⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
Click me
Click me
Click me
Click me
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
→
⁠
8/26/2021 4:50:05 PM⁠
⁠
⁠
8/26/2021 4:50:08 PM⁠
⁠
⁠
8/26/2021 4:50:08 PM⁠
⁠
⁠
8/26/2021 4:50:09 PM⁠
⁠
⁠
8/26/2021 4:50:09 PM⁠
⁠
3
⁠
8/26/2021 4:50:13 PM⁠
⁠
⁠
8/26/2021 4:50:15 PM⁠
⁠
⁠
8/26/2021 4:50:15 PM⁠
⁠
⁠
8/26/2021 4:50:15 PM⁠
⁠
⁠
8/26/2021 4:50:16 PM⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
Click me
Click me
Click me
Click me
⁠
@Christiaan Huizer
⁠
⁠
→
⁠
8/26/2021 4:50:16 PM⁠
⁠
4
⁠
8/26/2021 4:55:50 PM⁠
⁠
⁠
8/26/2021 4:55:52 PM⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
⁠
@Christiaan Huizer
⁠
⁠
Click me
Click me
Click me
Click me
⁠
@Christiaan Huizer
⁠
⁠
→
⁠
8/26/2021 4:55:52 PM⁠
⁠
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.