Databases and relations
Update it once. It applies everywhere.
Which trade is yours?
An ordinary table. A relation as a column.
ClientsAdd column
NameText
PhonePhone
AddressAddress
OrdersRecord
Basic
TextNumberEmailPhone
Relations
PersonSelectRecordView
The Clients database has three columns
We have a column for everything.
Základní
AdresaAno/NeČísloDatum a časDoba trváníEmailFormátovaný textTelefonTextURL
Pokročilé
BarvaHTMLiconPodpisSoubory & mediaStránkaTlačítko
Vztahy
OsobaVícenásobný výběrVýběrZáznamZobrazení
Systémové
IDArchivovánoVytvořilVytvořeno dneZměnilZměněno dne
A record, together with its context.
Bathroom renovationJobs · detail
IDJOB-26-00702
StatusProbíhá
PriorityCritical
DeadlineAug 14, 2026
ClientJane Walker
Phone770 412 933
InvoiceF2026-114
UpdatedJul 29, 2026, 09:46
The job has its own fields
A new record arrives already filled in.
New job
ClientYou'll fill in
DeadlineYou'll fill in
StatusNewdefault
PriorityMediumdefault
AssigneeYoudefault
You create a new job
Audit trail and comments on the record.
Bathroom renovationActivity
Má
Mára6 days agochanged statusNew→In progress
Ji
Jindra4 days agoConfirmed with the client, moving ahead.
Má
Máratodaychanged priorityMedium→Critical
Write a message…
Every record keeps a history of changes
See connected data however you need it.
Jobs
All jobsBy statusInstallation datesJob photosTeam workload
JobStatusDeadline
Bathroom renovationIn progress2. 8.
Troja villaTesting9. 8.
Service contractDone16. 8.
Boiler replacementIn progress23. 8.
All jobs
Filter down to just your own.
Filter
WhereTasks.AssigneecontainsLULogged-in user
AndActivities.TypeequalsTask
Add filterAdd group
Also applies in
Showing 128 records
MáBoiler repair – WalkerTask
JiEmergency, burst pipeTask
MáAC serviceTask
JiBathroom renovation quoteIdea
MáGas inspection – apartment blockIdea
JiBoiler replacement – FreemanTask
MáAnnual service contractsIdea
MáMaterial orderTask
All activities in the workspace
Calculate a column with a formula.
Hours6
Rate / h850 Kč
Total price — Calculation
Hours*Rate5 100 Kč
Total price is computed from the other cells in the row