Tables

Tables are where you organize all your data in Jestor, the foundation for apps, automations and integrations.

In short

  • What it is: tables are where you organize all your data in Jestor, with a look and feel similar to spreadsheets.
  • How it works: rows are individual records and columns (fields) define the type of information stored.
  • Why it matters: tables are the building blocks of your processes and feed apps, automations and integrations.

What is it

Tables are the most important part of Jestor. They are where you organize all your data, which can then be used in apps, automations, and integrations.

Tables in Jestor look and feel like traditional spreadsheets: you can click on any field to edit it and create as many columns as needed to store different kinds of information.

Each table has rows and columns:

  • Rows represent individual records (e.g., a single client)
  • Columns (fields) define the type of information stored (e.g., Name, Email, Phone Number)

Every row in a table shares the same set of fields, making tables a standardized and repeatable way to organize information.

Capabilities

  • Create as many columns (fields) as you need, choosing from many field types.
  • Edit any field by clicking on it, just like a spreadsheet.
  • Connect tables to each other to build relationships between your data.
  • Use table data in apps, automations and integrations.

Tables as building blocks

In Jestor, tables are the fundamental building blocks of processes. They are the foundation for creating efficient internal solutions and scalable workflows.

Just as important as the tables themselves is how they connect to each other. To build the best possible relationships between tables, it helps to understand what a relational database is and how it works.

How to add fields

Open your table and enter Build Mode by clicking the Build button or pressing B. Then click + New Field or press F and select the field type. See Field types.

Related pages