Lesson 3 of 10 · ~5 minutes · Prerequisite: Lesson 2 — Objects and records
What you’ll learn
- What attribute types exist
- How to add a custom field
- When to use a formula instead of a manual field
Standard and custom attributes
Each object has standard attributes (name, owner, creation date, status) and you can add custom attributes to fit your business model. Useful examples:- On
Deal:Lead source(select),Probability(number),Acquisition cost(currency) - On
Company:NACE sector(select),Annual revenue(currency) - On
Invoice:Related project(reference)
Attribute types
Text
Text
Free-form string, single or multi-line. For names, descriptions, notes.
Number
Number
Integer or decimal. You can set a unit (€, %, pcs, hours).
Currency
Currency
Number with currency symbol. Multi-currency with automatic conversion.
Date / Datetime
Date / Datetime
Day or precise timestamp. Timezone-aware.
Select (dropdown)
Select (dropdown)
Pick from predefined options. Single or multi-select.
Checkbox
Checkbox
True/false. For flags like
VIP, Paid, Archived.Record reference
Record reference
Link to another record. E.g.
Owner (reference to Employee), Parent company (reference to Company).Formula
Formula
Auto-computed from other attributes. E.g.
weighted_value = deal_value × probability / 100.Status
Status
Special select with a workflow. Statuses can be grouped (e.g.
Open → Qualified → Won / Lost).Add a custom field
Define options (select)
For select attributes, enter options with a colour (useful in Kanban pipelines and filters).
Control visibility
Decide who can view and edit the field: everyone, specific roles, or only the record owner.
Using a formula
Formulas enable automatic calculations. Practical example onDeal:
+ - * /), comparison (> < == !=), logical (AND OR NOT), text (CONCAT LOWER UPPER), date (DAYS_BETWEEN TODAY).
Best practices
- Don’t create a thousand fields: add them only when truly needed. Too many fields slow the team down.
- Use sections: group related fields (Commercial data, Legal data, Internal notes).
- Standardise values: prefer
Selectover free text when possible (avoidRome,ROME,rome).
Verify
You know the main attribute types
You added at least one custom field to an object
You can write a simple formula
Next lesson
Lesson 4 — Lists, views and filters
Create your first dynamic list and share it with the team.