Connected Field or Text Field: Which Should You Use?

Deciding between a connected field or text field is the most consequential structural choice in most builds. Text is faster to create and produces duplication that compounds over time.

What text costs when it should be a connection

The same entity ends up existing many times, slightly differently.

  • One client written three ways across three records
  • A price updated in one place and not the others
  • Reports that cannot group reliably
  • No way to see everything relating to one entity

When text is genuinely enough

  • A one-off description with no other record behind it
  • Free-form notes nobody will filter or aggregate
  • An external reference you do not maintain, such as a supplier's own code
  • Anything that exists once and is never reused

How to decide in Jestor

  1. Ask in Jestor whether the value names something that exists elsewhere as a record.
  2. If it does, create the table and use a connected field.
  3. Set the label field on the related table so selection shows names, not identifiers.
  4. Use the connected display to surface details rather than copying them.
  5. Reserve text for genuinely one-off values nobody will filter or sum.

Why choose Jestor for relational structures?

In Jestor, tables are a relational database at the centre of the operation, so a connected field costs nothing structurally and prevents the duplication that text invites.

A card can surface data from several linked tables at once, including a parent's parent, which means connecting adds context rather than adding navigation.

Frequently Asked Questions

When is text acceptable?

For one-off values nobody will filter or aggregate. See jestor.com.

Why do connected fields show numbers?

The label is set to an ID rather than a name.

Can a card show a parent's parent?

Yes, through the connected display.

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.

Read more