The hidden id field

Each record has a unique id

When you create a table, each record has an id, which is basically the record's row number in the database. As such, that id is unique, incremental and non-repeatable.

For example, say you create a table named Clients.

  1. You create the first record, a client named Andrew. This record will have id = 1.
  2. You create the second record, a client named Matthew. This record will have id = 2.
  3. You delete Matthew's record, and a creates a new record for a client named Nathalie. This record will have id = 3, *despite the fact you've deleted the previous record.

As you can see, an id will never be re-used, even if a record is deleted.

Record ids are very important for fetching and updating information inside Jestor, being used in methods such as Jestor.loadData() and Jestor.update(), as well as when dealing with API integrations.

An easy way to check on the record's id through the interface is by opening the record. The URL will have the opened record's id.

API Name of the id

The id field will always follow the nomenclature below:

id_api_name_of_the_table

As an example, in the Clients table from the previous section, the id field would be id_clients. If you had a New Leads table, the id field would be id_new_leads.

It's important to check the API Name of the table on the Development area, as it won't always be as simple as converting it to lower case and substituting spaces with underscores, especially if you have tables with the same name or originally created with a different name.