---
title: "How to use grouping while adding entries in a register log"
description: "Manual grouping while filling a register (Table part): tick consecutive rows -> Group Selected -> Confirm. Shared-value cell holds one value; calculated (Number) cell shows Total/Average/Std Dev. Ungroup keeps first row's value (shared) or leaves source untouched (calculated). Approved cells are locked — System Admin can ungroup without a Redo, or approver Redoes. Fixed grouping comes pre-sized and the size is editable."
url: https://help.digiqc.com/hi/articles/274-how-to-use-grouping-while-adding-entries-in-a-register-log
collection: "2.4 Register"
updated: 2026-10-28
language: hi
alternates: [en]
---

# How to use grouping while adding entries in a register log

Manual grouping while filling a register (Table part): tick consecutive rows -> Group Selected -> Confirm. Shared-value cell holds one value; calculated (Number) cell shows Total/Average/Std Dev. Ungroup keeps first row's value (shared) or leaves source untouched (calculated). Approved cells are locked — System Admin can ungroup without a Redo, or approver Redoes. Fixed grouping comes pre-sized and the size is editable.

### Overview

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._

### 🧭 How to use (while filling a log)

1.  Tick the **checkboxes** next to the rows you want — they must be **consecutive** and at least **two.**
    
2.  Tap **Group Selected.**
    
3.  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.)_

### Ungroup

-   **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.**
    

### If the cell is locked

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.
    

### ❓ FAQ

**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.

### 💡 Good to know

-   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.
    

### 🔗 Related articles

-   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