Timesheet View
Configuration reference: Folha de horas
Overview
The Timesheet view aggregates recorded time into Diário (daily), Semanal (weekly), Horário (week schedule), Blocos (week blocks) and Mensal (monthly) tabs, plus an Estatísticas (stats) tab for period totals grouped by category, user, profile, or a field captured by the timer profile, such as client, project or task. A KPI strip above the tabs shows totals for today, this week, this month, and overall; in Horário and Blocos only with Resumo no topo on.
It reads time either from the workspace's Tempos table (where the Timer stores its sessions) or from a table's own rows, so it works both as a personal/team time-tracking dashboard and as a read-oriented report over any table that has date and duration data.
Data source
Fonte de dados (data source):
- Auto (default): the workspace's Tempos when the view is not tied to a table, or is tied to Tempos itself; the rows of the view's table otherwise.
- Tabela (table): the rows of the view's table, read through the column map (date, duration, start, end, …).
The Timer source no longer exists; views that used it now read Tempos.
Mapeamento de colunas (column map): only shown when the effective source is a table. Maps table columns to the timesheet's fields: Data, Duração (segundos), Início/Fim (used to derive duration when no duration column is mapped), Etiqueta, Categoria, Utilizador, Notas. At minimum a date (or start time) and either a duration or a start/end pair must be mapped, or the view shows a "Mapeamento de colunas em falta" notice instead of data.
Mostrar os tempos da equipa (show the team's times): only shown on the Tempos source. Off (default), each person sees only their own times; on, they see the times of everyone they can see.
When the source is a table, entries are read-only: there's no "Adicionar" button and rows can't be edited from the timesheet. On the Tempos source, "Adicionar", tap-to-edit and "Apagar" work on the Tempos rows, through the same "Adicionar" dialog described in the Timer component page.
Modes
Configure which tabs are visible under Modos. When only one mode is enabled, the tab bar is hidden and that mode fills the whole view. With more than four modes, the toolbar switch becomes a menu. A new view has all six; on an existing view, Horário and Blocos appear once an admin turns them on.
| Mode | Layout |
|---|---|
| Diário | A single day's entries as a list (start, end, duration per row), with prev/today/next navigation and a running total against an optional daily target. |
| Semanal | A grid with one column per weekday and one row per category (or a single "Total" row when category grouping is off), plus a totals row and a rightmost total column. |
| Horário | The week with the hours of the day on the left and one column per day; each Tempos entry sits at its real start and end, side by side when they overlap (up to three; the rest count in a +N chip). Tap a slot to create an entry in it; drag with the mouse, or press and drag on touch, to cover several. Hours and slot size come from the filter profile's Grelha horária; with no profile, or a disabled one, 08:00–18:00 in 30-minute slots. Works on the Tempos source only; with another source it shows "O Horário usa o Tempos." |
| Blocos | The week without a time axis: each day stacks its entries with a height proportional to duration, and each day's Adicionar tempo creates an entry in hours and minutes. With a daily target, a dashed line marks it, with the value on the first column. Read-only on a table source. |
| Mensal | A month calendar grid with per-day totals. On wide screens it splits into the calendar plus a day-detail panel on the right; on narrow screens tapping a day opens the same detail as a dialog. |
| Estatísticas | A period selector (Hoje / Semana / Mês / Ano / Tudo / custom range) and a "group by" switch (Categoria / Utilizador / Perfil / field captured by the timer profile, such as client, project or task), rendering a bar list of totals per group. |
Mode-specific settings, also under Modos:
| Setting | Applies to | Description |
|---|---|---|
| Detalhe por categoria | Diário | Shows chips with the total per category above the day's list. |
| Agrupar por categoria | Semanal | Splits the grid into one row per category instead of a single aggregated total row. |
| Semana começa em | Semanal, Horário, Blocos | Which weekday starts the week. |
| Mostrar fim de semana | Horário, Blocos | Shows Saturday and Sunday (showWeekend, on by default). Off only hides them: the week total and Exportar still count the whole week. |
| Resumo no topo | Horário, Blocos | Shows the KPI strip above the grid (summaryOnTop, off by default). |
| Primeiro dia da semana | Mensal | Which weekday starts each row of the month grid. |
| Coluna total de semana | Mensal | Shows the per-row week-total column on the left of the grid. |
Filters
| Setting | Description |
|---|---|
| Categoria | Limits records to a single category value. Leave blank to show all categories. |
| Utilizador (id) | Limits records to a single user. Leave blank to show every visible user (see Mostrar os tempos da equipa). |
| Perfil | Keeps only the times of that timer profile and preselects it in manual entry. In Horário it also sets the grid ("Define a grelha do Horário"). A disabled profile shows with " (desativado)"; one that no longer exists, as "Perfil removido". |
One filter of the Tempos source is set in the view configuration (filterSourceFeatureId, see the reference), with no field in the dialog:
- Origin table: keeps only the times whose origin column for that table is filled.
Objective
| Setting | Description |
|---|---|
| Objetivo (horas/dia) | Optional daily hours target, used to render a "logged / target" total in the Diário, Semanal, and Mensal headers. |
Interface
| Setting | Description |
|---|---|
| Botão de exportar | Shows the export button in the toolbar. |
| Permitir entradas manuais | Shows the "Adicionar" button and enables editing existing entries. Has no effect when the data source is a table — those timesheets are always read-only. |
In Horário, an entry that starts or ends outside the grid hours is clipped; an entry fully outside them counts in the N fora do horário chip above the day, which opens the day's list. Entries created in Blocos, with a duration only, show at 09:00 in Horário. Tapping a block edits it: from Horário the dialog opens in Início e fim (a block that runs past midnight opens on the duration), from Blocos in hours and minutes, except a stopwatch entry that starts and ends on that day, which opens in Início e fim.
Times waiting to sync (stopped but without a Tempos row yet) show greyed out with "por sincronizar" and can't be edited until they arrive. They only show in timesheets without dynamic filters, facet selections or a category filter; with those filters, the time shows when its row arrives.
Admin configuration
The Configurar vista dialog has five sections: Filtros, Mapeamento (data source, column map and team times), Modos, Objetivo and Interface, matching the sections above.
Tips
- Use a Tempos-sourced Timesheet when you want people to log and edit their own time from the view; use a table-sourced Timesheet when you want a read-only rollup of time-like data that already lives in that table.
- Older workspaces may still have separate Daily/Weekly/Monthly Timesheet view types created before the unified view existed. They render through the same components locked to a single mode and no longer appear in the view type picker — new views should use Timesheet with only the needed mode(s) enabled instead.
- If a table-sourced timesheet shows "Mapeamento de colunas em falta", open the view's configuration and complete the Data/Duração (or Início+Fim) mapping under Mapeamento.