My app is designed to register tasks during workdays. One user can have multible tasks registered each day. Every task has a date column, preferably TODAY. And every task generates a row. So many rows can have the same workdate.
They also have to register when they are sick or on vacation as an optional task. And this is where my workers want to register from date and to date. So they dont have to register 15 times if they have 3 weeks vacay for example.
I have a slice where my workers can see each registration per date, sorted ascending. (History) If i can’t get the rows to copy all dates it will show blank dates for dates in between and the to date.
In the calendar view, also a slice. This captures when i set from date, to date. But the view isn’t working correctly (mailed support on this). But my workers still want the history slice as a tool. This gives a detailed view.
My database/datasheet is set up to capture all information, bases on dates and hours. It’s used to link all hours to a spesific department in the background.
I might do a count expression on dates and multiply it with working hours using a virtual column or something to get the correct hours. But that gives me just a halfway solution