I’m attempting to build a table of my team’s upcoming expected billing for projections. Entering each day and their expected logged time / project is overly tedious, so I’m attempting to create a button that at least helps with the repetitive nature of this.
I can’t share the doc at this time, but here’s my button code:
Sequence(SelectedDates.First(),SelectedDates.Last()).FormulaMap(AddRow(Schedule, Schedule.Date, ToDate(CurrentValue), Schedule.Name, SelectedStaff.FormulaMap(CurrentValue), Schedule.Project, SelectedProject))
This does a decent job of creating a loop that adds a new row for every date in the range with the defined staff member and project name (only one staff member at a time unfortunately). However, it includes ALL days in that range.
Is there a way to exclude weekends? I don’t see a function anywhere to parse whether a date falls on a weekend or not, so I’m hoping there’s a creative way to solve this. Otherwise I’ll be manually cleaning up afterwards…