Setup
Scheduled Report
Separate addresses with commas, semicolons or new lines.
1–28.
Same as From = whole days; 6:00 AM to 6:00 AM is a shift day.
Email filters — applied on top of the report's own filters.
None = all.
None = all.
None = all.
None = all.
Matched by the scale that weighed the load — tickets with
no scale recorded are left out.
Placeholders:
{company} {report}
{period} {start} {end} {count}
Sends the report exactly as set above, saved or not, for the period it would cover
right now. The schedule itself is not changed.
Load Email Rule
Separate addresses with commas, semicolons or new lines.
None selected = any customer.
None selected = any commodity.
Placeholders:
{company} {ticket}
{customer} {commodity} {carrier}
{truck} {net} {units}
Load Test Data
Pick a sample business. This deletes all existing data and loads about a year of tickets plus matching master data.
Custom Fields & Formulas
Open in a new tabPrinting
Open in a new tabPrompts
Open in a new tabSystem Settings
Open in a new tabReport Designer
Open in a new tabAdd Custom Field
The choices are grouped under each value of the parent — e.g. a
Variety field under Commodity, then a Grade field
under Variety. The forms and kiosk only offer the choices that
belong to the selected parent value.
Add, change, delete, or reorder lines to manage the list. Values already saved on tickets are kept even if removed here.
Type the choices below, or pick a list from
Database → Dropdown Fields — a list pairs each stored
value with the text people see (1 = Clean, 2 = Dirty), and is edited there.
The ticket stores true or false. Leave this on Yes / No, or
pick a True / False list from Database → Dropdown Fields
to show your own words, such as On / Off.
Leave this on Typed in per parent value to enter the choices by hand.
Point it at a list — Locations, say, another dropdown field, or a Dropdown Fields
list — and Tables gives you that list to tick against each parent value instead.
The names live in one place: a farm field is ticked against whichever commodity
is on it this season, and against another next season, without being retyped.
Each name is used under one parent value at a time.
Ties each choice to two answers instead of one — a Pivot under Location,
narrowed by Commodity, offers only the pivots of the location the driver picked
that are growing what they are hauling. Edit Tables then asks for both before
listing the choices, and the kiosk asks for this field before this one. Within
a parent value, each choice belongs to one answer of this field.
Manage this field's choices per parent value on
Tables after saving — the field gets
its own tab there.
Computed automatically whenever the ticket is saved and shown in
grids, reports, and printed tickets. Reference
NetWeight, GrossWeight, TareWeight,
InWeight, OutWeight, NetTons,
or any numeric custom field by name — use [brackets]
when the name has spaces. Operators + - * / ( ) and
functions round(x, n), abs, min,
max. A missing referenced value leaves the result blank.