A Fixed Entries register has a shape you draw once. Use it when the format is already decided: fixed rows, stacked headings, grouped spans, and values printed on the page before anybody fills it. A sieve analysis is one example; so is a QC incoming inspection report, a handover checklist, or any sheet a client sends you and expects back in the same layout. The person filling a log only fills the blanks. The other type, Running Entries, is the register you already know, where the filler adds rows as the work goes.
Go to Register → Add Register. Name it, and choose Fixed Entries.
Enter Columns and Rows (up to 30 columns and 200 rows), and choose whether the field type sits on the Column header or the Row header.
Build the header. Click Add header row for as many header rows as the printed sheet has, and type a label into any header cell.
Where one label covers several columns, select the neighbouring header cells and click Group. A grouped label can sit above or below the columns it covers, and a label can run the full height of the header.
Shape the body. Select a cell and use Split vertical or Split horizontal to cut it into two equal parts. Select neighbouring cells and click Group to make one span.
To add a column or row, use the small + at the edge of a selected header. Drag a header to reorder it. Use Delete column or Delete row to remove one.
Type into any cell that is the same on every log: labels, limits, fixed sizes. Double-click the cell and type. Tab moves right, Enter moves down. These cells become read-only for the filler.
Double-click each column letter (or row number) and set the field type and mandatory / non-mandatory. If the type is Option or Checkbox, type the choices here too; every cell on that column or row offers them. Switch Group allowed on wherever the filler should be able to join cells.
Click Assign Verifiers if the log needs verifying, then Go Live.
There is no Save button while you draw. If you press back, refresh or close the tab with changes you have not saved, digiQC asks Save your changes? with Discard or Save.
A QC incoming inspection report has its parameters down the side and five samples across the top, each sample with a Required and a Measured column.
Create the register with 10 columns, set the field type on the Column header, and click Add header row so the header is two rows deep.
In the lower header row, type Required and Measured into the first two columns.
In the upper header row, select the two cells above them, click Group, and type Sample - 1.
The field names become Sample - 1 · Required and Sample - 1 · Measured on their own. Repeat for Samples 2 to 5.
Type the parameter names and the required values into the body. Those cells are now read-only on every log, and the filler only types the measured values.
Running Entries if nobody knows how many rows there will be, such as a delivery log or a site diary. Fixed Entries if you are copying a printed sheet with a fixed shape.
While the register is still a draft, yes. Once it is live, no, in either direction. The same goes for the header that carries the field type (column or row). Those two are the only things that lock; everything else you can still change.
Yes. The header is just a grid of cells. Add as many header rows as you need, then Group the cells that share a label, wherever that row happens to be. A label above its columns and a label below them are drawn exactly the same way.
Select that column's header cells, top to bottom, and click Group. You get one tall cell, with no blank box.
Click Add header row again. There is no limit.
You don't. digiQC reads it off the labels above the column, widest label first, so "Required" under a grouped "Sample - 1" becomes Sample - 1 · Required. Change the label and the field name follows.
You don't. The field type sits on the column header or the row header, whichever you chose when you created the register, and every cell on that column or row follows. Mandatory works the same way, and so do the choices on an Option or Checkbox field: you type them once on the header and every cell offers them.
Always two, of equal size. Split again for more.
Only the first cell's value is kept, and digiQC asks before it happens. Ungrouping gives that value back to the first cell; the others come back empty.
There isn't one. That is why grouping, ungrouping and deleting all ask first, and why the editor asks before you leave with changes you have not saved.
There isn't one. If you press back, refresh or close the tab with unsaved changes, you are asked Save your changes? with Discard or Save.
Columns are a standard width, and long text wraps instead.
You can. A value you type into the template is free text, whatever the column's field type is. It is a label, not a reading.
No. A cell you filled in the template is read-only for the filler, so nobody has to fill it.
It decides whether the person filling a log may join neighbouring cells on that column or row and type one value across them. It is Off until you switch it on, on the column letter or row number.
Up to 30 columns and 200 rows. The numbers are capped when you create the register.
No. Every log keeps the shape it had when it was created, whether it is verified, waiting, sent back or a draft. Only new logs use the corrected register.
Open Edit and add them. Your existing logs keep the shape they were filled with; only logs created from now on have the extra rows.
While it is still a draft, switch the type and your columns come across. If you put the field type on the column header, they keep their names, types and mandatory settings. If you put it on the row header, they keep their names only, because the field type now lives on the rows, so you set one on each row.
No. A Fixed Entries register has no formulas, no Pass/Fail criteria and no Total, Average or Standard Deviation. You also cannot paste a block in from Excel.
Choose the register type, and the header that carries the field type, carefully. Neither can be changed once the register is live. Everything else can.
There is no undo in the grid editor, so read the confirmation pop-ups.
A cell you typed into the template can never be mandatory.
A row has no name. It is known by its number and whatever label you typed into its first column.
Grouping on a Fixed Entries register only joins cells. There is no Total, Average or Standard Deviation, unlike a Running Entries register.
2.4.10 Fill a Fixed Entries register log — what the site team sees and does.
2.4.2 Create & publish a register template — the Running Entries register.
2.4.4 Set up register verifications — submissions and verification levels — choosing who verifies.
