Field types and settings
Which types of custom fields there are, which settings each type has and which limits apply
Last updated on
When you create a field, you choose a type. You cannot change the type afterwards. Under 2. Settings are that type's options. All options are optional, unless stated otherwise below.
For almost every type, you can also fill in an Error message. It replaces the default message when a value is not right. With Placeholder, you decide what appears in the empty input field.
Text and Long text
Text is one line, Long text several lines.
| Setting | What it does |
|---|---|
| Minimum length and Maximum length | The number of characters. Without a maximum, 1,000 characters apply for Text and 10,000 for Long text |
| Format | Any text, Email address, Phone number, Web address, IBAN, Postcode, Digits only or Custom pattern |
| Pattern (regular expression) | With Custom pattern. The whole value must match. Tillor refuses patterns with nested repetitions or backreferences and patterns longer than 200 characters |
Number and Amount
Amount uses your organisation's currency.
| Setting | Applies to | What it does |
|---|---|---|
| Minimum and Maximum | Number, Amount | Lower limit and upper limit |
| Whole numbers only | Number | No decimals allowed |
| Display | Number, only for whole numbers | Input field or Counter (− / +) with buttons |
| Step | Number | The value must be the minimum (or 0) plus a whole number of steps |
| Maximum decimals | Number | Limits the decimals |
Yes / no
An on/off switch. With Must be checked, the record can only be saved with the box ticked. Handy for consent.
Date
| Setting | What it does |
|---|---|
| Earliest date and Latest date | Fixed limits |
| Not in the past and Not in the future | Compared with today in your organisation's time zone |
| Within days of today | At most this many days before or after today |
Choice and Multiple choice
You choose a pick list. Choice stores one option, Multiple choice several. With Multiple choice, you set Minimum selected and Maximum selected. A list has 200 options at most.
Link to record
The field points to another record in Tillor.
| Setting | What it does |
|---|---|
| Links to | Customer, Terrain, Occupation, Meter, Task, Invoice, Reservation, Payment report, Phone call, Contact, Product, Meter cabinet, Payment, Document, NFC tag or Access method |
| Several records | Allow more than one linked record. You can then also set a minimum and maximum |
| Display | Picker or Dropdown (one searchable list) |
| Only this customer's records | Limits the options to records of the customer you are editing. Only for Contact, Invoice, Reservation, Occupation, Payment, Document, NFC tag and Access method |
| Only the terrain's records | Limits the options to the terrain's meters: for an occupation the terrain of that occupation, for a terrain the terrain itself. Only for Meter. You cannot save a meter from another terrain |
| Filter options | Optional TypeScript that decides per option whether it appears in the list, see Filter options. For Contact, Product, Meter cabinet, Payment, Document, NFC tag, Access method, Invoice, Reservation, Occupation, Meter and Terrain |
If a linked record is deleted later, the field shows Deleted.
If there are at least 50 records to choose from, you first type 2 characters to search. If there are fewer, such as the meters of one terrain, you see them all straight away.
Filter options
With Filter options, you decide yourself which records the field offers. You write TypeScript, like the rate formula, which Tillor runs for every option. If it returns true, the option appears in the list; otherwise it does not.
In the filter, you read fields with curly braces. The Variable menu shows what is available, including custom fields:
| Variable | What it is |
|---|---|
{option.…} | The record you could choose, for example {option.type} or {option.terrainId} for a meter |
{occupation.…}, {terrain.…}, … | The record you are editing, under the name of its type, with customFields for its own fields |
Example: only electricity meters of the occupation's terrain.
return {option.type} === "ELECTRICITY" && {option.terrainId} === {occupation.terrainId};Custom labels
The same filter can also decide what an option is called in the list. What you return decides the result:
| You return | Result |
|---|---|
true | The option is in the list under its own name |
false, null or an empty text | The option is not in the list |
| A text | The option is in the list under that text |
{ label, group } | The option gets that label and goes under the heading group. Both are optional |
Example: only meters from ICY and Hydrodigit, with the type added and grouped per supplier.
if (!["ICY", "TILLOR_HYDRODIGIT"].includes({option.provider})) return false;
return { label: {option.name} + " · " + {option.type}, group: {option.provider} };The label applies in the picker and on the chosen chips in the form. In places that only show the value, such as the detail page or an export, the record's own name is shown.
Insert example under the field gives a starting point. A filter that does not compile cannot be saved; the message under the field says what is wrong.
The filter does not only limit the list. If you still choose a record through the API or an old form that the filter leaves out, Tillor refuses to save it and names the field. Automations and imports are not checked, just as they may also fill in hidden fields.
Group of fields
A fixed set of subfields that appear together in the form, such as Dogs and Other animals under Animals.
| Setting | What it does |
|---|---|
| Add sub-field | Every subfield has a label, type and its own settings. Click More for the key, width and conditions. A group can have 30 subfields at most |
| Display | Card (with a border) or Inline (the fields continue in the form) |
| Columns | 1 up to and including 4 |
| Width in the group | Per subfield how many columns it spans |
Repeating rows
A table to which you add rows with Add row, for example several vehicles. You set the subfields as with a group. With Minimum rows and Maximum rows, you limit the list. Without a maximum, 100 rows apply, and more than 500 is not possible.
A group or repeating row may contain one more level of group or repeating row, no deeper.
Files
For documents and photos. A file that you upload can only be opened by whoever may see the field.
| Setting | What it does |
|---|---|
| Several files | Allow more than one file |
| Minimum files and Maximum files | Without a maximum, 20 files apply, and more than 50 is not possible |
| Maximum size per file (MB) | 50 MB per file at most, even if you want a higher value |
| Allowed file types | Any file, Images, PDF, Office documents, or your own extension such as .dwg or a MIME type such as application/zip |
Tillor checks the type from the file's content, not only from its name.
JSON
Meant for structured data that an integration supplies. Colleagues rarely fill this in on the form. With Maximum size (KB), you set a limit, 64 KB by default and 256 KB at most.
Settings for every type
| Setting | What it does |
|---|---|
| Encrypt this value | Stores the value encrypted. An encrypted field cannot be searched, filtered or sorted and is not available as a variable in automations. Only for top-level fields, so not for subfields. All custom fields are stored encrypted anyway, whether you switch this on or not |
| API only | Hides the field in forms and detail views. An integration fills it through the API. Such a field cannot be required |
| API only, read-only | Does show the field, but disabled, so colleagues see the value but cannot change it |
| Validation rules | Compare a date, number or amount with another field (Before, On or before, After, On or after, with an offset in days, weeks or months), or check the value with an expression. 10 rules per field at most |
A changed limit does not apply retroactively. A value that you do not change does not block saving the record, even if it no longer meets the new rule.