Tables

What's a table?

In this video, I provide an overview of Jestor tables, our internal tool for storing information. I explain how Jestor combines relational databases and app creating tools to create a powerful solution for data storage. With Jestor, you can save data without the need for external databases or spreadsheets. Watch this video to learn more about the benefits of using Jestor and how it can solve all your data storage problems.

Creating Tables in Jestor

In this video, I will show you the two ways to create tables inside Jestor. I will guide you through the process of creating a new table and adding a title and selecting fields. No action is required from you, but this information will be helpful for your work in Jestor.

What's a Row or Record?

In this video, I explain the concept of records and rows in data storage. I use the example of storing information about a client, such as their name and address. I demonstrate how each piece of information is stored in a row, and how you can add new rows as needed. This video provides a clear understanding of the fundamentals of data storage and organization.

Jestor Table Emails: Create Tickets from Emails

In this video, I explain how to set up table emails in Jestor. Table emails allow you to create a new card or row in a table every time someone sends an email to a specific email address associated with the table. I also show how to activate the table email function and match fields to store information such as sender name, subject, body, attachment, and from email. Additionally, I demonstrate how each record in the table can have its own email address for email conversations, making it a useful way to receive information from other sources. Please watch the video for a step-by-step guide.

Should Members Access Tables Directly?

In this video, I explain why only builders must use tables when managing data within our company. I discuss how using tables helps maintain the structure of our data and ensures the safety of our members. I also highlight the benefits of using tables and the potential risks of not utilizing them. By the end of the video, I request that viewers acknowledge the importance of using tables in their data management practices.

Understanding Unique Records in Tables

In this video, I explain the concept of unique records in tables and how they help avoid duplicated information. I demonstrate how to activate the unique records feature and select a key field, such as name or email, to uniquely identify a user, ticket, or company. By the end of the video, you will have a clear understanding of how unique records work and how to implement them in your tables.

Changing Table Icon, Name and Description

In this video, I'll show you how to customize your table to make it easier to find and understand. You can add a name and description to your table, as well as change icons and colors. I'll also demonstrate how emojis and colors can be used to enhance your table. Watch this video to learn how to optimize your table for better organization.

How to Duplicate and Clone Tables in Jestor

In this video, I'll show you how to duplicate or clone tables inside Jestor. This feature is useful because it allows you to replicate all fields and information in a table, saving you time and helping you build apps faster within your organization. I'll guide you through the process step by step, and once it's done, you'll receive a notification.

Managing Fields on a Table: Creating, Hiding, Deleting

In this video, I demonstrate how to manage fields on a table inside Jestor. I show you how to hide a field without deleting it, and how to bring it back if needed. I also explain how to delete a field and add a new one. Watch this video to learn how to efficiently manage your table fields in Jestor.

Adding Table Fields with AI Suggestions

In this video, I demonstrate how AI can be helpful when building a new table. With AI, you can easily add new fields to your table based on context. The AI suggests field names, types, and even descriptions, making it quick and convenient to add new fields. However, it's important to note that the AI suggestions may not always be precise, so manual editing is available. Watch the video to see how AI suggestions can streamline the table-building process.

Adding Table Automations

In this video, I demonstrate how to add a new automation on a specific table using Builder Mode. I show you step-by-step instructions on how to activate Builder Mode, locate the "Add Automation" button, and select the desired table for the automation. I also provide an example of how to add an automation to a checklist. Watch this video to learn how to streamline your workflow with automations!

Where to Find Table's API IDs for Custom Integrations

In this video, I explain how Jester's open API works and how to find the API name or ID for each field or table. I provide a step-by-step guide on accessing information through the API and highlight the importance of understanding the available data. Watch this video to learn how to leverage Jestor's open API for your projects.

How to Delete and Recover a Table

In this video, I will show you how to delete a table in just a few simple steps. I will guide you through the process and explain the importance of being cautious when deleting a table. I will also discuss the option to recover a deleted table and provide recommendations on when it is appropriate to permanently delete data. Watch this video to learn how to effectively manage your tables and ensure data integrity.

How to Select a Label for Your Record

In this video, I will show you how to select a label for your record in a table. By default, the label is set as the title, but I will demonstrate how to change it to another field, such as the email. This is important for identifying specific records or cards in your app or system. Watch the video to learn how to easily select a label for your record.

Sharing a Table on Jestor

In this video, I demonstrate the easiest way to share a table on Jestor. Instead of sharing the table itself, I recommend creating an app page and using the table component or block. I show how to create a new blank app, add the table, and customize it. I also explain how to make the table read-only for public sharing or share it within the organization. No action is requested from the viewers, but this video provides important information on sharing tables effectively.

Reordering and Sorting Records on a Table

In this video, I will show you how to reorder and sort records on a table. I will guide you through the steps to take, including clicking on specific areas and using different options such as alphabetical order and numeric values. By the end of the video, you will have a clear understanding of how to reorder and sort fields both on a table and within a specific block on your app. No action is required from you, this video is for informational purposes only.

Exploring All Tables in Jestor

In this video, I show you how to navigate through all your tables in Jestor. By accessing the All Tables tab, you can easily view and manage all the tables within your organization. This video provides step-by-step instructions and important tips to help you efficiently explore and work with your tables. Watch the video to learn more and take action to optimize your table management.