TechAppForceFields
The 25 field types and what they do.
| Type | Notes |
|---|---|
| Text, TextArea, Rich text | Plain and formatted text |
| Number, Currency, Percent | Numeric values |
| Date, DateTime | Stored as dates |
| CheckBox | True or false |
| Email, Phone, URL, GeoLocation | Typed text |
| PickList, multi-select PickList | Values from an enum |
| JSON, Array | Structured values |
| UniqueIdentifier, User | Ids; User values expand to the user's details |
| AutoNumber, NextNumber, SequenceNumber | Numbering. NextNumber formats values such as INV-{yy}{MM}-{5n} |
| Insert and update timestamps | Set by the platform |
Fields can be required, unique, searchable or confidential, and can carry validation and lookup configuration. Tenants can add custom fields without a schema change; they are stored in a shared extension table.