Currency & unit referenceReference
Required amounts and quantities. If a money or quantity field is required, its currency or unit dropdown is required too — but only when SheetApps can pre-fill it (a currency it detected, a default you set, or a unit filled in from a chosen product). That way a required picker never blocks saving a value it couldn't have guessed.
Where the dropdowns appear depends on the shape of your form:
| Form shape | How currencies & units behave |
|---|---|
| Header only | A single set of fields, with no repeating lines. Each money or quantity field gets its own dropdown by the rules above, and the form can show several currencies at once. |
| Header + line items | A header with a repeating line-items table. When the header — or a totals block such as Sub Total / Grand Total — carries a currency, the whole record uses one document currency: the dropdown sits on the header or totals and every line inherits it, with no currency dropdown on each row. Units can still differ line by line. |
| Grid, no header | Columns across the top with rows below and no separate header. SheetApps treats it as a single-record form (Header only, above), so each money or quantity column gets its own dropdown, and different currencies or units can sit side by side. |
What the dropdowns are named. You rarely name these fields yourself — SheetApps adds them — but it helps to know their names when a rule, formula or default needs to refer to one:
| Dropdown | Field name | Label |
|---|---|---|
| Shared currency | currency | Currency |
| A field's own currency | <field>_currency | Currency |
| Shared unit | unit_of_measure | Unit |
| A field's own unit | <field>_unit | Unit |
Because the labels are always “Currency” and “Unit”, refer to a dropdown by its field name, not its label — for example default = HEADER.currency in a Rules default. A currency or unit code column you provide yourself keeps the name you gave it.
currency_2, currency_3).In printed and PDF records, money shows with its currency symbol and quantities show with their unit — matching what you see on screen.