Table Fields

In this video, I will show you how to add images in Jestor and use them as covers for smart kanbans and lists. I will explain the difference between the image and file fields, and how the image field allows only one image per record. Adding images is useful for company logos, employee pictures, and other situations where you need only one image per record. Watch the video to learn how to add images and use them as covers in Jestor.Image Field - Adding Images and Covers in JestorChecklist Field## Text Field

In this video, I explain the different options available when using the text field in our app or table. I discuss the benefits of using bridge text versus short text and when to make a field required. I also demonstrate how to create and edit a text field, including formatting options like bold, italic, and quotes. Watch this video to gain a better understanding of how to use the text field effectively in our app.

Link Field

In this video, I explain how to add links and link buttons. I demonstrate how to create a link field and how it can be used to transform any text into a clickable link. I also show how to format the link correctly and how to add a link button. This feature is incredibly helpful for adding context and making videos more interactive. Watch the Loom to learn how to enhance your videos with links and link buttons.

Email Field

In this video, I discuss the importance of email field validation in forms and how it helps ensure accurate user information. I explain how to check if an email has the correct format, such as having an "@" symbol and a ".com" domain. By requiring users to provide a valid email, we can avoid collecting incorrect or incomplete contact information. Watch the video to learn more about the significance of email field validation and how it can improve our data quality.

Phone Number Field

In this video, I demonstrate how to create a phone number field that not only checks if the input is valid but also automatically formats it with spaces. This feature is incredibly useful as it ensures that users are entering numbers correctly and improves the overall user experience. Watch the video to learn how to implement this functionality in your projects.

Single Selection Field

In this video, I explain the purpose and functionality of single selection fields in smart kanbans. I demonstrate how to create stages and options, change colors, make fields required, and add tooltips. I also show how to apply single selection fields to create a smart cover using an example. By the end of the video, you will have a clear understanding of how to use single selection fields effectively in your projects.

Tag Field

In this video, I explain the benefits of adding a tag field for user selection and demonstrate how to implement it. By allowing users to choose multiple options, we can provide more flexibility and enhance the user experience. I also showcase how to differentiate the selected options by changing their colors. Watch the video to learn how to implement this feature and improve your product!

Multiple Select Field

In this video, I explain the concept of the multi-select field and its differences from the tag field. I also demonstrate how the information is displayed on tables and forms. Additionally, I show how to set a minimum number of selected fields, using the example of selecting at least two options out of five. No action is requested from viewers, but this video provides important context for working with the multi-select field.

Radio Select Field

In this video, I explain the concept of radio select fields and how they differ from single selection fields. I demonstrate how radio select fields allow you to choose only one option and how they are displayed on the standard record view. I also highlight the limitation of not being able to create a smart combo using radio select fields. No specific action is requested from the viewers, but this video provides important context for understanding radio select fields.

Address Field and Google Maps Integration

In this video, I demonstrate how to use the address field to connect directly to Google Maps and retrieve the exact location of an address. I show how this feature can be used in various scenarios, such as plotting the location on a map in an app or using it in forms. No action is requested from the viewers, but it provides valuable information on utilizing the address field effectively.

Number Fields

In this video, I explain the concept of number fields and how they work. I discuss the different types of number fields, such as currency and percentage, and demonstrate how they are represented. I also show how the number field only accepts numerical input and will not save any non-numeric values. Watch this Loom to gain a better understanding of number fields and how they can be used in our projects.

Currency Fields

In this video, I explain how to add currency fields in your application. I demonstrate how to customize the currency for each field and provide examples using USD and JPY. By following my instructions, you will be able to easily incorporate different currencies into your application. Watch the video to learn how to enhance your application with currency fields.

Percentage Field

In this video, I explain how the percentage field works and clarify any confusion around it. I discuss the option to add a number out of a hundred and how it can be used to include text, discounts, or quotes. I also emphasize that the value entered is not the actual number but a decimal representation. Watch this video to gain a clear understanding of the percentage field and avoid any misconceptions.

Chat Field

In this video, I explain how to use the chat field feature to bring conversations to your table or any other place you want to display information regarding a specific record. It's a simple and basic feature that allows you to have a chat for a specific record. I demonstrate how you can view messages, and mentions, add comments, reply, and see multiple messages. Watch the video to learn how to effectively use the chat field feature.

Favorite Field

In this video, I explain the concept of the favorite field and how it can be used to highlight specific records. I also demonstrate how to sort records by star rating to prioritize important information. Watch this video to learn how to make the most of your favorite field and sorting feature.

Record Update Form Field

In this video, I explain the differences between the record update form and the super form for updating record information. I recommend using the super form for most activities, but the record update form can be more useful for specific needs. I demonstrate how to personalize each form for each record and highlight the benefits of using the record update form, such as exchanging information with suppliers or clients more efficiently. No action is requested from the viewers, but this video provides valuable information for optimizing record updates.

To-do Field

In this video, I explain how to effectively use the to-do field in our project management tool. I demonstrate how to create to-do lists for specific processes or projects, using the example of creating a new recipe for our restaurant. I show how to brainstorm, find items, compare prices, select suppliers, and make purchases, all while tracking progress visually. This feature allows us to streamline our workflow and ensure that no tasks are overlooked. Watch the video to learn how to optimize your project management process!

Checklist Field

In this video, I demonstrate how to create checklists using Jestor's field feature. Checklists are different from tasks or to-dos because they allow for more personalization and provide additional information. I show how to add fields, justify requirements, and activate or deactivate fields based on specific needs. Checklists are especially useful for clients or users who use Jestor on their smartphones or tablets. Watch the video to learn how to create checklists and make your operations more organized and efficient.

File and Attachment Field

In this video, I explain how to use the file and picture fields in Jestor. The file field allows you to store any type of file, such as PDFs, videos, spreadsheets, or pictures, within your Jestor. The picture field has special powers, as it can be used as a cover for Kamba and other places in the system. I demonstrate how to open a record, drag and drop a file, and view the uploaded picture. No action is requested from the viewers.

Image Field

In this video, I will show you how to add images in Jestor and use them as covers for smart kanbans and lists. I will explain the difference between the image and file fields, and how the image field allows only one image per record. Adding images is useful for company logos, employee pictures, and other situations where you need only one image per record. Watch the video to learn how to add images and use them as covers in Jestor.

Link Buttons Field

In this video, I will show you how to add buttons to links in tables using the link button feature. This feature allows you to enhance the functionality of your links by adding buttons that can be customized with icons and colors. I will also demonstrate how these buttons can be used for navigation and updating records in dashboards or apps. Watch the video to learn how to create buttons for your links and make your tables more interactive.

Exclude Record Button Field

In this video, I demonstrate how to use the exclude record button to easily remove records or cards from your system. I explain the importance of this feature in providing options for users to exclude specific records, whether they are on apps, lists, or tables. I also show how to customize the button's appearance by selecting different colors. Watch this video to learn how to efficiently manage and delete records using the exclude record button.

Open Record Button Field

In this video, I explain how to customize the open record button in an app to provide a custom way for users to access specific information. This feature is particularly useful when you have a read-only table but still want to allow users to edit certain data. I provide an example of how to add an open record button and demonstrate how it can be customized to open different types of information. Watch the video to learn how to avoid misclicks and enhance the user experience.

Clone Record Button Field to Duplicate Records

In this video, I will show you how to add a clone record button to easily duplicate records. This feature is incredibly useful when you need to use one record as a template for the next or when you want to replicate a similar step multiple times. I will demonstrate how to add the button and customize it with different emojis and colors. Watch the video to learn how to streamline your record duplication process.

Automation Button Field

In this video, I explain how to use the automation button and its popularity among users. I demonstrate how to click the button, give it a name, and initiate the automation process. I also show an example of using the information from a specific record to send an email. No action is requested from the viewers, but it's important to understand the process.

Record Link Button

In this video, I will show you how to easily copy record links in the app. By using the copy link button, you can quickly share specific record information without having to go to your browser. Watch this video to learn how to create and use record links in the app.

Checkbox Field

In this video, I'll show you how to add checkbox fields to your table. Checkbox fields can be used to add a checkbox to your records, allowing you to track completion or trigger automations. I'll walk you through the process of adding a checkbox field, selecting the default state, and using it to run an automation. Watch this video to learn how to effectively use checkbox fields in your tables.

Switch Field

In this video, I explain the purpose of a switch field and why it may be preferred over a checkbox field for UX/UI reasons. I discuss how a switch field is used to turn on and off certain features or automations, and I provide a step-by-step demonstration of how to add a switch field. Watch this Loom to learn how to enhance the user experience with a switch field.

Single User Field

In this video, I explain how to add a single user field to a record, such as a ticket or a client. This feature is particularly useful when you want to designate one owner or responsible person for a specific item. I demonstrate step-by-step how to create the user field and select the appropriate user. Additionally, I mention the possibility of adding automations to this field. Watch the Loom to learn how to efficiently manage user assignments in your records.

Last Edited By Field

In this video, I explain the purpose and functionality of the Log field in our database. I discuss how the Log field tracks the last person who added or edited a record. I also provide examples and demonstrate how the Log field works. Please watch this video to gain a better understanding of the Log field and its significance for our database management.

Multiple User Field

In this video, I explain the benefits of using multiple user field. By adding as many users as needed to a specific record, it becomes easier to manage and collaborate with team members. I demonstrate how to search for and select specific users to add to a project, making it a useful and efficient feature. Watch the video to learn how to enhance your project management with multiple user fields.

Date Field

In this video, I demonstrate how to select dates in a calendar field. I show you two methods: using the calendar interface and manually typing the date. This feature is useful when adding important events like birthdays or scheduling appointments. Watch the video to learn how to easily select dates in a calendar field.

Date and Time Selection Feature

In this video, I demonstrate how to use the date and time selection feature. I show you how to select a specific date, time, and minutes of the day. This feature allows for easy scheduling and ensures accuracy. Watch the video to learn how to use this helpful feature!

Date Range Field

In this video, I explain how the date range field works and its benefits. I demonstrate how to select a range between dates and save it in two other date fields. I also discuss the importance of having a start field and a finish field, and how this field can be used for various situations like project timelines. Additionally, I highlight the usefulness of the date range field in creating a Gantt chart within the app. Watch the video to learn more about the date range field and its functionalities.

Time in Status Fields

In this video, I explain how time calculation works in status fields. By changing from one status to another, the system automatically calculates the time spent in each status. This feature is useful for tracking the duration of tasks, client positions in the pipeline, or project stages. I demonstrate how the time calculation works using a select field for status. Watch the video to learn more about this helpful feature.

Time Since Update Field

In this video, I explain the purpose and functionality of the Time Since Update field in our system. This field serves as a log to track when any information in a specific record was last changed. It doesn't matter which field is being updated, as the Time Since Update field will always show the most recent update. This feature is useful for identifying stagnant leads or opportunities that haven't been modified for a long time. Watch this video to learn more about how to utilize the Time Since Update field effectively.

Time Since Creation

In this video, I explain the concept of "Time since creation" and how it can be used to track the duration since a specific record or card was created. I discuss how this automatic field functions as a log field and provide examples of its practical applications. Watch this video to gain a clear understanding of time tracking in our system and how it can help us stay organized and efficient.

Time Field

In this video, I explain the usefulness of the time field in Jestor. I demonstrate how the time field can be used to save time and provide specific information, such as the duration of a song. I also show different ways to display the time field, including as text or in minutes and seconds. Watch this video to learn how to effectively utilize the time field in Jestor!

Timer Field

In this video, I demonstrate how to use the timer field, a built-in feature that allows you to track time by pressing play and pause. I show you how to create laps and view the total seconds. This feature can be useful for automations and in other apps and tools. Watch the video to learn more!

Add Record Button Field

In this video, I demonstrate how to use the "Add Connected" button in Jester, a relational database, to easily connect different tables. I explain the process of adding a connected record field and show how it helps in automatically connecting tables. I use the example of connecting a client to multiple projects to illustrate the advantages of this feature. No action is requested from the viewers, but it provides valuable information on how to efficiently connect tables in Jestor.

Lookup Field

In this video, I explain how lookup fields work in databases and how they can help you bring data from other tables into your current table. I demonstrate how to create a lookup field and select a connected table, as well as how to choose the specific information you want to display. I also highlight the importance of understanding that data from connected tables cannot be edited directly in the current table. Watch this video to learn how to efficiently use lookup fields and streamline your data management process.

Formula Field

In this video, I demonstrate how to use formula fields in our records. I start by adding a number and then show how to create a simple formula using the "text" function. I explain how variables work and how to do calculations, such as multiplication and concatenation. I also mention that more complex formulas and functions are available, and I highlight the documentation as a resource for further information. No action is requested from viewers.

Record Database ID Field

In this video, I explain the concept of record IDs in the database and how they are used. I show examples of record IDs and explain their importance in adding filters, automations, and integrations. I also clarify that record IDs are unique and cannot be changed. No action is requested from the viewers.

Connected Records (N:1) Field

In this video, I explain the importance of the connected record field in Jester and how it helps to connect data within your company. I provide a simple example of how one company can have multiple opportunities and highlight the need for this connection in building a CRM or support tool. I demonstrate how to add a connected record on the opportunity table, including adding filters to show only relevant records. No action is requested from viewers, but this video provides valuable context for data management in Jestor.

Bidirectional Connection (1:1) Field

In this video, I explain how to connect cards from one kanban board to another. By creating a bi-directional connection, you can ensure that information is always updated and easily accessible. I demonstrate how to select the relevant fields to display and show how this feature can be useful for tracking bugs and tickets. No action is requested from the viewers, but this feature can greatly improve collaboration and efficiency within teams.

Connected Tables (N:M) Field

In this video, I demonstrate how to create many-to-many connections using Jestor. I explain the concept of end-to-end connections and provide an example of connecting clients to courses. I show how multiple clients can be subscribed to multiple courses, and how courses can have multiple students or clients. No action is requested from the viewers.

Roll-Up Field

In this video, I explain how to use rollup fields to aggregate values from connected records and perform calculations. I demonstrate how to create a rollup field on the main record table and show examples of summing, averaging, finding minimum values, and counting. I also highlight the option to add filters or conditions to the rollup field formula. Watch this Loom to learn how to efficiently aggregate data and perform calculations using rollup fields.