When a field has grouping switched on in the template (see *Setup grouping in a register template*), you can combine several consecutive rows into one cell while filling a register — in the Table part. Two kinds of result:
Shared-value — the grouped cell holds one shared value (Number, Text, Multiline, Date, Time, Options, Checkbox or Attachment field).
Calculated — on a Number field set to calculate, the grouped cell shows a Total, Average or Standard Deviation.
This article covers Manual grouping — where you (the filler) select the rows to group. With Fixed grouping the groups come pre-sized from the template and you can edit the group size; everything else works the same.
Tick the checkboxes next to the rows you want — they must be consecutive and at least two.
Tap Group Selected.
Confirm:
- Shared value — enter or pick the single shared value for the grouped cell. - Calculated — check the calculated preview (from the source column) and Confirm. (For a calculated group, the source column must have a value in each selected row.)
Shared-value cell: tap Ungroup → confirm. The first row keeps the value; the others become empty (checkbox: the first keeps its state; attachment: the first keeps its files).
Calculated cell: tap Ungroup → confirm. The cell splits back into empty cells; the source column values are unchanged.
Once a submission is sent for verification, its grouped cells are locked (you'll see a lock icon instead of Ungroup):
While it is waiting for verification, it is locked for everyone. If a verifier presses Raise Query and sends it back, you can ungroup and change it again.
Once it is Verified, it stays locked for you. A System Admin can still ungroup it to correct it, and the log keeps its Verified status.
I selected rows but there's no Group button — why? The rows must be adjacent/consecutive and you need at least two. For a calculated (Number) group, the source column must have a value in each selected row.
Why is there a lock icon instead of Ungroup? That submission has been sent for verification, so its cells are locked. If a verifier raises a query and sends it back, it opens for you again. Once it is Verified, only a System Admin can ungroup it, and the log keeps its status.
What happens to my values when I ungroup? Shared-value cell: the first row keeps the value, the rest are cleared. Calculated cell: it clears and the rows become editable; the source values are untouched.
Can I group empty rows? Yes — when there's no value that could be lost, you just get a simple confirmation.
Grouping is in the Table part; rows to be grouped must be adjacent/consecutive.
Shared-value groups keep the value in the first row on ungroup; calculated groups leave the source data untouched.
Sent and verified submissions lock grouped cells — a query sent back reopens them for you; after verification only a System Admin can ungroup them.
Setup grouping in a register template
2.4.3 Fill a register — logs, entries and submissions
2.4.4 Set up register verifications — submissions and verification levels