Hi,
I’m building an internal business app in Glide for time tracking, travel orders and absences.
I already have a generated calendar table (Calendar_layout) with these columns:
- date
- year
- month_key (e.g. 202601)
- month_day_key (e.g. 202601/15)
- relations to:
- date-calendar
- lookup columns:
- look_work_hours
- look_commute
- look_absence
My goal is to create an accounting view where a user with role “Accountant” can:
- Select a month (e.g. January 2026)
- Select an employee
- See a table for that month (1–31) showing per day:
- worked hours
- travel (km or yes/no)
- absence type (sick, vacation, etc.)
- Also see monthly totals (sum of hours, sum of km, look-up absence days)
Right now I can show the calendar grid, but I’m struggling with:
-
Filtering
Calendar_layoutby selected employee -
Linking the employee to all related Time_entries, Travel and Absences in the same daily grid
What is the best Glide pattern to?
Any best practice for building an accounting-style monthly timesheet (1–31 rows × multiple metrics) in Glide would be greatly appreciated.
Thank you!
