I have a modern date picker and for the onChange property I want to do numerous things....
I also have some buttons that want to set the datepicker selected date to the next / prev week and also a page on visible function around this, so that is 4 places where I would rather not repeat my code. But there's a variable that changes each time... I may set _dateSelected to Today() or use a DateAdd function...so that needs to allow for changes.
Set(_dateSelected, DatePickerCanvas6.SelectedDate);
Set(_weekNo,ISOWeekNum(_dateSelected));
Set(_startOfWeek,
DateAdd(_dateSelected,-(Weekday(_dateSelected,StartOfWeek.MondayZero)),TimeUnit.Days)
);
Set(_endOfWeek,
DateAdd(_dateSelected,6-(Weekday(_dateSelected,StartOfWeek.MondayZero)),TimeUnit.Days)
);
ClearCollect(
WeeklyCalendar,
{
Day: "Mon", Date: DateAdd(_dateSelected, -(Weekday(_dateSelected, StartOfWeek.MondayZero)), TimeUnit.Days)
},
{
Day: "Tue", Date: DateAdd(_dateSelected, 1 - Weekday(_dateSelected, StartOfWeek.MondayZero), TimeUnit.Days)
},
{
Day: "Wed", Date: DateAdd(_dateSelected, 2 - Weekday(_dateSelected, StartOfWeek.MondayZero), TimeUnit.Days)
},
{
Day: "Thu", Date: DateAdd(_dateSelected, 3 - Weekday(_dateSelected, StartOfWeek.MondayZero), TimeUnit.Days)
},
{
Day: "Fri", Date: DateAdd(_dateSelected, 4 - Weekday(_dateSelected, StartOfWeek.MondayZero), TimeUnit.Days)
},
{
Day: "Sat", Date: DateAdd(_dateSelected, 5 - Weekday(_dateSelected, StartOfWeek.MondayZero), TimeUnit.Days)
},
{
Day: "Sun", Date: DateAdd(_dateSelected, 6 - Weekday(_dateSelected, StartOfWeek.MondayZero), TimeUnit.Days)
}
)
My question is ...
a) how much of this can I put into a app.formula instead so I don't repeat myself, and
b) must I break it up into smaller chunks.
I'm sorry but I don't quite "get" formulas yet.
