How to Set the Label Field on a Connected Table
The label field on a connected table decides what people see when they select a related record. Set to an ID, the selection list is a column of numbers. Set to a name, it becomes usable.
A small setting with large consequences
This is one of the most common early mistakes, and it is invisible until someone tries to use the form.
- Connected fields listing sequential IDs instead of names
- Users guessing which record is which
- Wrong selections that are hard to spot afterwards
- Forms abandoned because the choice is unclear
What makes a good label
- Unique enough that two records are not confused
- Recognizable to the people who select it, not just to finance
- Short, so it reads cleanly inside a form field
- Stable, since changing it changes every display
- Any field can serve — it does not have to be the title field
How to configure it in Jestor
- Open the related table in Jestor — cost centres or suppliers, for example.
- Click on the field you want as the label, such as the name field.
- Choose to select it as the label.
- Return to the connecting table; the field now shows names instead of IDs.
- Keep the sequential ID as the title field if finance refers to records by code.
Why choose Jestor for readable data?
Jestor separates the title field from the label field, which means a record can be numbered internally and displayed readably wherever it is referenced.
That separation is what lets allocation run on a cost centre ID while everyone selecting it sees the department name.
Frequently Asked Questions
Can any field be the label?
Yes, not just the title field. See jestor.com.
Where do I change it?
On the related table, by selecting the field as the label.
Can I keep an ID as the title?
Yes, and still display the name.
Video Tutorial: Step by Step
Check out other practical tutorials on the Jestor YouTube channel.
Get to know Jestor
With Jestor, you can automate workflows, connect teams, and build internal systems your way — all without code and powered by AI. Discover Jestor at jestor.com and see how to take your company's operations to a new level of efficiency and control.