Skip to content
Example
In the button I make us of a named canvas function.
If([DB ThisMonth].Count(),DeleteRows([DB ThisMonth]),
Sequence(1,_AllDatesThisMonth.Count()).FormulaMap(
[DB ThisMonth].AddRow(
TheDate,_AllDatesThisMonth.Nth(CurrentValue),
[DB ThisMonth].WeekDayName,_AllDatesThisMonth.Nth(CurrentValue).WeekdayName(),
[DB ThisMonth].WeekNumber,_AllDatesThisMonth.Nth(CurrentValue).IsoWeekNumber()
)))
Clear Table #
Example
TheDate
WeekDayName
WeekNumber
7/1/2022
Friday
26
7/2/2022
Saturday
26
7/3/2022
Sunday
26
7/4/2022
Monday
27
7/5/2022
Tuesday
27
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.