A Document column gives a sheet record its own document action. Create an invoice, quote, receipt, or packing slip beside the sheet, then return to the same row and scroll position. Separate Document columns can serve different purposes for the same record.
Set up the column#
- Create or choose a connected document template in the sheet’s workbook. Check its field mappings and line-item relationship.
- Add a Document column to the sheet and choose that compatible template.
- Review the sample record. Optionally add rules that select another template when a field matches a value, such as a related subsidiary.
- Order the rules deliberately: the first match wins; other rows use the default template.
Create from the saved row#
- Click Create Invoice, or the action named for your column. The linked draft opens beside the sheet.
- Inspect the preview and missing-information messages. Open the source record from the panel to fix missing values.
- Save and finalize when the document is ready. Finalization stores the resolved content and actual PDF as an immutable version.
- Download or print the stored PDF. Click the cell again to reopen the same document.
The same column and record reopen the same document, including simultaneous creation requests. A Document cell is an action, so pasting text cannot overwrite its link. Save a new row before creating its document.
Keep issued documents stable#
Drafts preview current source and related-record data. Issued versions do not change when source records change. When relevant information changes, the cell shows Source updated; open the panel and choose Create revision. Finalizing the correction adds a version under the same document number. The version selector keeps older PDFs available.
Changing the column’s template or selection rules affects newly created documents. Existing documents keep their layout and identity. Removing the column does not delete historical documents from the workbook’s Documents area.
Use the record’s own reference#
Add an Auto-number field for a permanent record reference, then choose it as Number source in the template’s Page & data settings. An existing assigned document number always wins. One mapped reference cannot belong to two separate numbered documents in the same workspace; use the existing linked document or a revision.
Reuse the action in a workflow#
A Flow Document step or helper Generate document action can select the Document column and call the same open-or-create behavior. Template-based generation remains useful when a separate draft is intended. AI can propose the column configuration and a reviewed helper using the existing workspace-change flow.
Reusable workbook templates copy the column configuration and template references without copying generated documents or records. Conditions tied to particular related records do not transfer because those record identities belong to the original workbook.