In this Crash Course, we'll learn the fundamentals of Jet Admin so you can start building your app today.

We'll also dive deeper into advanced concepts to help you get the maximum juice for the squeeze.

Finally, we'll build some of the most popular kinds of apps together, guiding you step by step from the square one to production-ready.

In this section, you'll learn how to connect your Data to Jet Admin.

You can connect as many data sources as you need to create a centralized place for all your operations. You can integrate with anything using native integrations or custom APIs.

Use the submenu to navigate to a particular topic or start with the first one:

Data Editor is a key part of the Jet Admin App Builder. Typically you end up in Data Editor right after you connect your data source(s).

In Data Editor you can audit, edit, and refine your data before using it in the App Builder.

In Jet Academy, you'll be able to learn both the fundamentals of Jet Admin and more advanced topics through a series of short tutorial videos.

To navigate Academy, click on the topic in the menu on the left to open its contents, or get started with the most basic functions:

What is Jet Admin?

Jet Admin is an app builder that allows you to create Client Portals, Business Apps, and Internal Tools with your existing data, whether it's from databases, APIs, or Storages. You can build apps such as Onboarding apps, Admin Panels, Vendor portals, CRMs, and much more quickly and without code.

Building a Business App?

This 2-min video will explain what Jet Admin is and what you can build with it:

1. Connect your data: Connect Databases, business apps (Airtable, Stripe, Zendesk), Data Warehouses, Internal and external REST or GraphQL APIs, and File Storage.

2. Sync and Blend your data: Create a single source of truth (SSOT) that syncs to your multiple data sources (Stripe, Hubspot, Salesforce, ...).

3. Build App Interfaces: Drag and drop UI components (Tables, Forms, Charts, Details Images) onto Layouts (Modals, Columns, Tavs) and connect them to your data sources.

4. Customize your app: Design pixel-perfect components or use 50+ ready-to-use components from Marketplace.

5. Automate your workflow: Create multi-sequence Automation with over 30+ automation blocks and trigger them by Webhook or Schedule jobs every minute, hour, day, or month.

6. Publish and share your app

Building a Portal?

This 5-min video will walk you through the process of building a client portal from scratch:

Ready to Get Started?

This Quickstart Guide will walk you through the necessary steps for building your first app in Jet:

This short video will help you understand how to get around Data Editor and start working with your data more quickly.

Before you start working with your data, it makes sense to organize it so you can easily access the relevant parts.

This video covers the basics of sorting, filtering, working with columns, and more.

In this article, we'll review the integration with Airtable, and its characteristics and will go through the steps necessary to connect it to Jet Admin

Connecting Airtable

You can connect to Airtable from the data tab on the left menu bar or from the data section within a UI component. You'll need to enter a valid personal access token, and choose a base.

Obtaining a personal access tokens

To obtain your personal access token on Airtable's Developer Hub, follow the steps below:

1. Go to Airtable's developer hub page

2. Click on 'Create token'

3. Create a new token

4. Copy and save the token in a safe place.

Connect Airtable to Jetadmin

1. On Jetadmin's builder side, click 'Add Resource' from the data section on the left-side menu

2. Choose Airtable

3. Click on 'Sign In to Airtable' button

4. Click on 'Add a base'

5. Choose the needed base or workspace

6. Click 'Grant access'

7. Choose the base needed

8. Click the 'Choose tables' button

9. Select/unselect the needed tables and choose a view for each table

10. Click the 'Add Resource' button.

Choosing connection mode

After that, you need to choose how you'd like your Airtable to be integrated with Jet Admin. You can either connect directly or sync it with Jet's internal database to get extended functionality.

If you want to be able to combine your Airtable data with data from other data sources, such as Firebase, Google Sheets, or even REST API within the same tables, you should choose the "Sync" connection for Google Sheets. You can learn more about it here:

After having connected your Airtable, you'll be prompted to choose pages you want Jet Admin to generate an admin panel (CRUD pages) for.

Airtable Views

On Airtable side, you can create different views for each table. Each view allows you to filter and sort records. In Jetadmin you can choose to use only one view for each table when creating the resource. To view all records in each table, choose the main view 'All'.

The image below will show you the differences between the main view and the filtered views:

Switch Airtable's Views

To switch to other views for each table, follow the steps below:

1. Click 'Edit resource' from the resource's settings menu

2. Click on 'Choose tables'

3. Select the needed views for each table

4. Click 'Update resource'.

In this video, we'll learn about the very powerful field types Rollups and Lookups. We'll also go over an example of how to use them to "look into" the related table and get the information you need from there.

In this video, we'll learn about the related data – what this means and why relational databases are such a great concept. We'll also learn how to work with related data in Jet, how to set relations, and what to do with these related data sets later on.

In this video, we'll learn how to edit your data in Data Editor:

• Edit particular fields

• Add and delete records

• Upload and download data

Once you've connected your Data Source to Jet, you can specify its settings, specify the sync intervals, see audit logs, manage collections (tables), and more:

This is the overview video on how to work with files in Jet, whether that means connecting an Airtable with files attached to records, connecting a dedicated storage such as Firebase, or using another data source.

This video explains how to change field types so that you can make sure your data is rendered in the correct format.

UI builder is a part of the App builder and allows you to assemble the UI components on the page using pre-made Drag & Drop UI components

In this video, we'll look behind the "no-code" curtain and explore how you can consolidate data from multiple data sources (Non-SQL included) using custom SQL queries.

Before diving into the features of the builder, it's important to understand the fundamental structural elements of any app you build with Jet: Pages and Overlays.

Any app you'll create with Jet will be built in the Builder mode so it's important to understand what it is and how it interacts with the user mode where your end users will be using the app

In this Crash Course section, we'll learn the fundamentals of the App builder.

App builder is a core part of Jet Admin. It allows you to assemble your UI, and layout as well as bind and transform data to create custom user flows for your app. All this is done through an intuitive Drag & Drop and Point & Click interface.

Go into the submenu to navigate to a particular topic or start with the first one:

To build any app you'll need two things: your UI and the data. But how to link or connect the two in Jet Admin? Learn in this video

In this video, we'll learn about the Field-Table binding use-case: you have an input field component and you want a value from a specific column from in a selected row of a Table to be fetched into this field

In this and the following videos, we'll cover how to bind data and components in various situations. In this video, in particular, we'll learn about the Filter-Table binding use-case: you have a filter component and you want all the inputs in it to be passed over into the Table and used to filter it.

In this video, we'll cover binding UI elements from separate pages:

• You have a Table on Page 1 and an input field on Page 2 and you want, when you click on the specific row in the table to drill down into Page 2. Additionally, as you drill down, you want to "pass" a specific value from a selected record in the Table into the input field on Page 2

In this video, we'll cover binding a UI element in the Modal to the UI component on the Page:

• You have a Table on a Page and an input in a Modal and you want, when you click on the specific row in the table to open up the Modal. Additionally, as the Modal opens up, you want to "pass" a specific value from a selected record in the Table into the input field in the Modal

Slowly ramping up the complexity of the use-cases, now we'll look at the Table-Table binding:

• You have two related tables and want, in the second Table, to dynamically show the records related to the selected (clicked) record in the first Table

In this video, we'll learn about the Form-Table binding use-case:

• You have a Form and you want this form to dynamically receive the values from a selected row (a record) of a Table into the fields of this form

Nested filters allow you to go through the layers of relations between collections and filter by ANY field from ANY collection (table), that's related to the original one.

In this section, we'll go over specific apps, building each use-case from scratch to the point when it's up and running.

Go to a specific one in the submenu or start from the first one:

Where is my data stored, and is it secure?

Yes, your data is secure and is always stored by you, whether that be with your chosen data resources or on your own servers. We provide Jet Bridge that makes our architecture secure. Jet Bridge is a free and open-source app that generates an API and proxies the requests to databases and business apps. We don’t collect, copy, or host your private data on our side. Jet follows best practices to ensure that important data is only accessed by you and your users. Jet encrypts all data and credentials that go through our servers using an HTTPS connection. Jet Admin offers you the ability to use Jet Tables, which is a PostgreSQL database hosted by Jet. Jet Tables, like other top-tier PostgreSQL databases, uses best practices to keep your data secure. Using Jet Tables is the only case in which your data would be stored on Jet servers, but there is no difference between the way Jet Admin allows you to access data in Jet Tables and the way that Jet allows you to access your data in other PostgreSQL databases, so your data remains secure, regardless of which databases you choose to use. You can learn more about Jet Tables here.

Host Jet Bridge on your servers. You can place it behind your VPN, in your own VPC. We won’t get access to your data, however, you will still receive interfaces updates normally.

If your infrastructure doesn't have access to the internet, you can use on-premise on your own servers and block all network connections. You can place it behind your VPN, in your own VPC.

Built-in Security-Grade Features

Incident Recovery

To prevent bad consequences for your business, Jet Admin automatically creates a backup of your interface, so you can always restore it in case of an incident. Simply push the “Recover” button at the top right corner of your screen and select what you would like to backup.

DMZ

Since Jet Admin doesn’t require access to your data, you are free to host your admin’s API under DMZ or VPN network. Once you do that, your admin panel will be separated from your public network, leaving no chance for malicious attacks or remote rooting. This might be on a checklist for some large healthcare and financial companies that can be held liable for clients’ personal information. In most cases though, it is not a necessity.

The community is where you can meet, get help & support, share resources and discuss what you're working on. The community is filled with thousands of kind and friendly users – many of them experts – who are willing to help each other out.

We have only a few simple guidelines:

• Be polite and kind to other members

• Use the search bar to see if your topic has been discussed before

• When posting questions, try to be clear and concise and write descriptive titles. If you need help with many different things, try posting them as separate topics.

• Where possible, provide links (e.g. to your app), screenshots or even videos that help explain the point you are trying to make

• Please be aware that everything you post in the forums is public

• If you have questions that others could benefit from – try to post publicly and not privately message other members. Some of our experts and staff get a lot of DMs – bear in mind that there are many other people in the forum that may be able to help you.

In this section, you'll be able to find answers to common questions as well as more advanced troubleshooting.

To navigate FAQ & Troubleshooting, click on the topic on the left menu to open its contents.

Our Slack channels are available for Pro and Enterprise plan users, including:

• Internal Tool Pro

• Internal Tool Enterprise

• Customer Portal Pro

• Customer Portal Enterprise

Joining our workspace gives you direct access to our team. You can ask any questions related to your app in your dedicated channel.

How to Join Slack

Step 1: Join the Workspace

1. Click the blue question mark button in the bottom-right corner.

2. Select Slack Channel from the support options.

3. Follow the instructions to join the workspace.

Step 2: Access Your Channel

1. Your Slack email may differ from your registered email; you can enter a different email if needed.

2. The default channel name is jetadmin_, but you can change it.

3. Once completed, you’ll be added to your specific Slack channel.

Need Help?

If you have any issues joining, reach out via live chat or email us at support@jetadmin.io.

To fix this you need to Recreate Scheme.

1- In Jetadmin, open the resource that is failing to sync;

2- Click on the 3 dots button on top-left near the resource name;

3- Choose ‘recreate scheme’ from the menu;

4- Click the ‘recreate structure’ red button;

5- Wait a few seconds till the data is being imported, then click the ‘Start working with …’ blue button.

Now your resource should be synced and working fine.

If your data is not loading, there might be many potential causes for this. This might as well render differently in the UI component: the infinite load, or the error.

In this article, we'll review the most common causes of this issue and help you identify and fix the problem.

Case 1 - VPN

A user supposedly hasn't changed anything but started to get this error:

Solution: Disabling VPN solved the problem - this is the most common reason for such an error. After disabling it, reload the page.

Case 2 - SQL query filters

In this case, a user wanted to display a filtered collection from a custom SQL query but got the "Nothing found" message

Even though the query was correct, it didn't account for the fact that Jet handles filtering automatically, so you should not add the WHERE clause.

Solution: omit WHERE and only set up the inputs and reference them in the query.

If you want to duplicate your app, you can save your progress as a backup to a file, create a new app, and restore your app from a backup. Please be aware that created actions won’t be copied, you will need to add them manually.

Go to MyApp in upper right corner -> Environment -> Settings -> Download backup

After that, create a new app and go to the Environment -> Settings to restore your backup.

If you've added new SQL tables to your database, you will need to manually select new tables to load into JetAdmin.

Go to Data -> Your Resource Name -> Three dots -> Edit resource

Scroll down and click on "Choose Tables"

You will see a list of your tables there. You’ll need to click on checkboxes of tables that you want to add and then click on "Update resource".

If you are having trouble connecting Django to JetAdmin, you will need to check a few things:

• Make sure there are no network restrictions.

• Check whether your Jet Bridge is the latest version.

• Check your CORS policies in Django.

If your network with Django is okay, and you are using the latest Jet Bridge version but still getting errors like this:

That means that you need to check your CORS policies in Django.

By default, there is a parameter in Jet Bridge for Django that contains CORS in settings.py called "JET_CORS_HEADERS".

It is enabled by default and filled automatically, but if your Django already has an app called “corsheaders” then it turns off. You can configure your CORS settings in the "corsheaders" app instead.

Alternatively, you can try to force "JET_CORS_HEADERS" to be set to True, but it can lead to strange effects, so we would advise trying it only as a last resort.

If you want to allow an input to only receive a certain number or text format, you can use regular expressions.

After you get your regular expression, you can input it in the validation field of your component. Click on the component in builder -> Display tab -> Validate -> Use Regular expression

You can also mention your field format in the custom validation error field for easier understanding.

Custom CRM in 10 mins 🚀

To familiarize yourself with how Jet works, let's build a simple CRM that will allow us to View and Edit the Customers:

We'll go through the whole process of creation step by step. Let's start with our data:

To insert test data into the Jet Database, first download the following provided CSV files:

Once you have downloaded the CSV files, follow the steps:

2. Create a new project and add Jet Table as your data source, or if you have an existing project, integrate Jet Table by navigating to Data > Add Resource.

3. Click Import CSV

4. Select the Companies CSV you downloaded

5. Click Import file

1. Follow the same process to import Deals: Data > Jet Tables > Add or Import.

👉Before we jump into the thick of it, there is one thing that needs to be clarified:

Internal Tools vs Customer Portals

Typical use-cases for the Client Portal and for the Internal Tool also differ, that's why we've created two separate quickstart journeys based on the common use-cases:

After you've made the changes to your app, you can preview it to test and, if everything's right, publish it. To preview your app, click on the Preview button at the top.

Great! Now that we're done with the Basics, we can get to the advanced functionality of Jet Admin:

You can build Portals with data from pretty much Any Data Source: Firebase, Sheets, Airtable, Stripe, REST API, and so on. We'll use Airtable in our example.

In our case, we will use two tables: Projects and Tasks. The projects table has the Link to Tasks column and the Tasks have the Project column in it.

Projects Table:

Tasks Table:

Next, we generate the app:

In Data, you can set up field types (Number, Text, Select, Date, Rating), define Relations between tables, pull record contents from one linked record into another, perform a calculation on Relation, or calculate the values.

Next, let's set up the field type for the Priority field. We will configure it as a Select type with predefined options: High, Medium, and Low.

1. Click on Priority header in your table to access its settings

2. Choose Edit field to modify the field's properties.

3. Select the field type as Select. This allows you to create a dropdown menu with predefined options.

4. Click on Display to proceed with the visual setup.

5. Add predefined options for the 'Priority' field: High, Medium, and Low.

Use the Link to Record field type to establish a relationship between Deals and Companies. This will enable you to link these two tables, effectively associating specific deals with respective companies.

1. Click on Company id column in your table to access its settings.

2. Choose Edit field to modify the field's properties.

3. Select the field type as Link to record. This option allows you to create a link between the current record and another table.

4. Specify the related table by selecting Company.

Once you've established a Relation using the Link to Record field type, you can pull record contents from one linked record into another, and you can perform calculations on this Relation, enabling more complex data manipulations and analyses based on the interconnected data.

Next, we will focus on extracting and inserting the Company logo into the Deals table.

1. Click + New Column on the right-top

2. Select Lookup related field

3. Select Company_id > Logo

4. Save

Components are prebuilt UI elements your users engage in, such as Tables, Forms, Buttons. In this example, only a limited number of components are used; you can explore 50+ Components in the UI Component Library. Drag-and-drop components within Layout Columns, Tabs, and Modals, facilitating the building of your app.

You'll be building an app that enables the creation and updating of Deals data. To enable this functionality, you'll add Table, Forms, and Modals. Learn more about Jet UI Concept in our documentation. Additionally, if you want to implement this functionality swiftly (Create, Update, Delete flow), you can generate it in seconds using Page Templates.

1. Set the Layout

Columns are used to set the horizontal component of the layout. You can add multiple columns and resize them.

2. Display Deals

When you select the Table component, the right panel automatically updates to display the properties of the component. Components come with a wide range of properties that you can configure. Properties are accessible from other components and queries, allowing for a more integrated and dynamic user interface experience.

Click Data Source – Jet Tables and the Deals collection that you've created.

Modify the Logo column to have a circular frame and position it as the first column.

3. Bind your components

Component Binding allows the passing of values between components. In this case, we will bind the Table and Filter components, enabling users to filter Deals by criteria such as Name, Priority, and Amount.

4. Update Deal with a Form component

The final component to add is a Form component. This component will allow you to generate Forms automatically based on your Collections fields.

Every field in the Form is individually configurable: you can add or remove fields from the Form, alter the field type, rearrange the order of the fields, and change appearance.

To update a deal, the user must select the corresponding row in the Table. You can configure the first row to be selected by default in a Table. To do this, go to the Display tab in the Table properties and choose Select the first row by default.

This tutorial will show how to customize the app's primary colors, typography, and menus.

The menu is a great component when you would like to implement navigation between pages.

PM Portal in 5 mins 🚀

As an example, we'll build a Portal for a Consultancy agency's corporate clients where they can View their Projects, Edit the related Tasks, and Update their Profile:

To build the portal, we start with preparing the data:

A helpful way to think about apps is through how users interact. Two elementary levels of interaction are viewing and editing data, which we built on the previous steps. But often, apps need to be able to perform custom actions with specific workflow.

Initiating a Form is a form of action. Actions such as Open Link and Show notification are native functionalities within Jet, triggering specific processes within your app.

In this tutorial, we'll set up a system to automatically send notifications to the user via email and Slack when a deal is marked as Closed Won.

1. Initiate the workflow when the Deal is updated, which occurs when the associated form is successfully submitted.

1. Add a conditional step in the workflow that checks whether the deal stage is set to Closed Won. For the conditional step, employ the 'Equals' operation using the Formula EQ({deal_stage}, 'Closed Won') to verify if the deal stage matches the Closed Won status. The value for {deal_stage} is selected from Formula.

1. Send email. Add actions to send an email with the content formatted as: "Deal {0} is Closed Won". Here, {deal_name} should be dynamically inserted into the email content, and its value can be selected using a formula that references the {deal_name} field from the data source.

1. Show notifications. Use the same logic to implement notifications.

You can link different tables as long as there's a common field in both of them. In our case, we'll link by the Unit name field.

Display the Projects

Drag the Table component and change the mock data to your own. Select the data source you've connected and the page you want to display:

1. Drag and Drop the Table Component to the page

2. Choose the Resource and the Collection

Link the Tables

Each Unit has many Tasks and we want to see the list of Tasks for a given Unit. To create this flow, follow the steps:

1. Click on the Table

2. Click on the Filter icon

3. Choose Unit ID -> ID equals

4. Click on the Formula icon

5. Choose Units -> Selected Row -> ID

Now, let's customize our Portal:

The key functionality of any Portal is that any user or group of users see and interact only with their data. In this step, we'll invite our users and set permissions to turn our Airtable app into a secure portal.

Invite Users

Click Share and add the email of a user. Then we can invite this user to the existing team or create a New Team by clicking Add a new Team. In our example, we build a portal for corporate clients, so we'll create separate teams for every company we work with.

1. Click on the Share button

2. Paste the Email you want to send an invite to

3. Click on the Team Icon

4. Choose Add a New Team

5. Write the Name of the New Team

6. Click on the Create button

Then send invites to the users.

Set the Data Separation

Team Properties and User Properties are used to set the data separation in Jet Admin. For each team or user, we add a Property that uniquely identifies a company or a client, such as domain or email. In our case, we use the company name:

1. Click on the Add Property

2. Choose the Name of the Property

3. Click on the Create button

4. Set the property of the team

Next, we need to filter our Portal's data by the property. Select the component you want to separate data for, proceed to filters, and set them Client field to match Client property what we've created.

1. Choose the Table

2. Click on the Filter icon

3. Choose Client -> Client equals

4. Click on the Formula icon

5. Choose Team Properties -> Client

Set Permissions

Additionally, we want our Coffee Beans employees to interact only with the portal page we've created. For this, go to the Teams and set page-level permissions to allow access to the Tasks , Tasks-edit and the Tasks-create pages:

Now, let's check how that works: the Beans Coffee employee that we've invited can see only their company's projects:

Jet Admin provides a library of pre-built UI components, such as Table, Map, Gallery, or Charts that you can drag and drop to display your data. As well as the Layout components that are used to assemble other components on the page.

Set the Layout

Columns are used to set the horizontal component of the layout. You can add multiple columns and resize them.

To add columns, follow the steps:

1. From the Layout menu, drag and drop Columns

2. Drag and Drop the Tasks Table in the Right Column

3. Drag and Drop a Form in the Left Column

We also can change the position of the individual fields in the record view. For that, drill down into the record and drag and drop the fields you want to reassemble:

Now, let's add our Project table and link it to the Tasks table:

In Jet Admin, you can customize the appearance of your Portal for better usability. Let's start with the Units table.

Let's disable unnecessary columns and rearrange the order.

1. Click on the Units Table

2. Disable the unnecessary columns

Let's now set the number of displayed rows to 5, and make the first row selected by default. To do that, follow the steps:

1. Go to the Display Tab

2. Set 5 in the Rows Per Table section

3. Enable the Select First Row By Default option

You can change the field types to render different fields differently and customize their appearance. To do so,

1. Click on the Priority field

2. Choose Low Option

3. Click on the Color field

4. Choose the Color

In Jet Admin, you can configure and customize any component individually on any page. Let's make our record fields non-editable so that the users will be able to change them.

1. Click on the Unit ID field

2. From the menu on the right, change it to Editable

3. Click on the Assign To ID field

4. From the menu on the right, change it to View-Only

Applying similar edits to the Tasks table and we're done with the UI customization.

Now, let's invite external users and make them interact only with their data:

Connect your Data Source

After creating a project, you'll be prompted to start with the Blank app or your Data. Select your chosen Data Source, fill in the credentials, and finish the process.

1. Click on the Data Source icon

2. Click on the Add Resource icon

3. Choose Airtable

Choose the Page

You can navigate through pages and create new ones in the top left tab. Now, let's pick another page:

1. Click on the Pages icon

2. Choose and Navigate to the Page

Now let's test how it works by

1. Clicking on the Table to select it

2. Clicking on a Row to drill down to the record view

Next, let's set up the Layout:

Single relations help you fetch data from the related collections.

To illustrate how it works, let's imagine we have the Transactions table that doesn't contain a customer's email and the Users table that contains the customer information including the email:

And we want to display the email in the Transactions list:

First of all, we identify how our tables are related: for each user, there are several transactions that are related to the users list by the ID and Customer ID fields:

Now, let's create a new custom column in the Transactions table:

Then change the column type to Link to record

Now, we need to select where we'll get the user email from (a related Users table), what field in the Users table is used to set relations with the Transactions table (the ID field), and what field from the Users table we'd like to display (the Email field):

And the final step is to get our custom field value from the Transactions table field that sets relations to the Users table (the Customer ID field):

Now, let's make UI components dynamically visible based on a rule:

This part focuses on advanced Jet features such as custom HTTP, SQL queries, conditional visibility, and related fields (e.g. single relation). Let's start with the latter:

In Jet Admin, you can make certain components visible or invisible depending on the values or combination of values from your data or user attributes.

Say, we want to show two different status change buttons depending on the status value of the selected row of the users table:

To achieve that, let's first drop two buttons: one that changes the status of a user to "active" and the other that changes it to "inactive":

Then, we proceed to the "Activate" button's settings to the "Visible" section:

Next, we type in the condition: IF the status value from the selected row equals "inactive", then return true, otherwise, return false. Returned true will make the component visible and false will make it invisible:

Here's the expression: =IF(EQ(elements.users["0"].selected_item.Status, "inactive"), 1, 0)

Then we do the same for the "Deactivate" button, grabbing the "active" value from the selected row:

=IF(EQ(elements.users["0"].selected_item.Status, "active"), 1, 0)

And we get our buttons being dynamically hidden based on the status value from the selected row:

For instance, you need to make your own API request, just choose Make an HTTP request as an operation. Let's look at an example of how to get a list of transactions. We are going to display a list of transactions in the table component with the Stripe API (you can use any API).

Make an API request using API Builder

1. Go to the Component Settings then Add Data Resource

2. Select a resource then choose collection as Make an HTTP request

Pass API parameters

Now you are in API Query Builder. Specify endpoint and add new customer parameter (to return charges for the customer specified by this customer ID)

Use tokens on your API request

When you create a new parameter it becomes available as tokens. You can set a value for the parameter to request a list of customer's transactions.

Transform your response

To transform the response, use the Response Nested Keys to specify the result of your request:

Paginate by pages

To paginate by the list of pages specify cursor pagination :

1. Select Cusror Pagination as Pagination:

2. In general, Cursor pagination is specified by next_cursor, has_more parameters. To parse the response we use Javascript notation. You can modify your function's return value by adding a transformer. Use the identifier data for the return value and enter any expressions to modify the result, such as add a property or loop over the data set.

• next_cursor as data['data'][data['data'].length - 1].id

• has_more asdata['has_more']

3. Let's specify the request by providing Query Params:

Run your request

Simply click Refresh Data button to run your request

Let's say, we need to display order total amount on Customer table for each customer. All Orders we stored in the separate Orders table in the SQL database.

The resultCustomerstable contains: customer_id, photo, name, total_amountcolumns of data for each customer.

Build SQL query using SQL Builder

1. Go to the Component Settings then Add Data Resource

2. Select a resource (SQL database) then choose collection as Make an SQL request

Write SQL query

Let's write a SQL query that returns customers includes the total amount column:

select 
(select sum(amount) from orders where customer_id = customerscrm.id) as total_amount,
id,
photo,
name
from 
customerscrm

Tips

Here is a list of your available tables, you can see the table columns. You can use them while writing SQL, just click on the table name and the name will be automatically added.

Run your SQL query

Simply click Update Result button to run your SQL command.

Customize table

Just close SQL Query Builder to start to customize the result table.

To add shapes, follow the steps:

1. Click on the Shape icon in the Toolbar at the top-left.

2. Select Rectangle as a Shape

3. Drag-and-drop Rectangle to the Canvas

Customize (resize, reshape, position,...) the Rectangle shape using the Right sidebar:

1. Click on Rectangle

2. Update the positioning of Rectangle

1. Update the corner radius of Rectangle

To customize Cards in the Gallery, follow the steps:

1. Click on the Gallery

2. Click on the Property card button in the right panel

3. From the dropdown menu, choose Customize with Designer

Generate documents for your Jet Admin applications with the Documint.

Jet Email allows you to send emails via Action or Workflow/Automations. All emails will be sent through no-reply@jetadmin.app (unless you have set up a custom From email address in App Settings).

Use the following guide to set up emails, and specify the next operation:

1. Choose operation -> App built-ins

2. Action -> Send email

3. Specify inputs:

• to – receiver email (allows only email's format)

• subject – text field to specify the email subject

• text – text field without markups

• text (HTML) – text field with markups

To familiarize yourself with how Customize with Designer works, let's build a simple design:

We'll go through the whole process of creation step-by-step.

1. Design your component

1.1 Choose Component Type

Identify the type of component you want to create, whether a button, card or any other UI element.

1.2 Customization with Designer

Step 1: How to add shapes

Select the shape you want to utilize from the menu on the top left. In the example, we will use Rectangle and Ellipse shapes.

Step 2: How to add parameters

To add a parameter to the card, you need to use the menu on the top left. After adding a parameter you need to specify type and test value.

Step 3: How to add borders

You can add borders to the shapes or reshape them. To add borders or reshape, choose the shape and use the menu on the right.

Step 4: How to locate fields

Use the tutorial below to locate the fields for the parameters.

2. Pass and bind data with elements.

After creating the design, you need to bind it with the table data.

3. Conditional visibility (Component Visibility, Conditional Fills)

For changing the visibility of a component please follow the steps as shown below.

4. Responsiveness

To check how your design will respond to different screen sizes, please follow the steps shown below. Ensure that it maintains its integrity and functionality across various devices.

Responsiveness and support of multi-screens refers to the ability of a design to adapt and display optimally across various devices and screen sizes. It ensures a seamless user experience by adjusting layout and content to accommodate different resolutions, promoting accessibility and usability.

To fit your component to different screen sizes, follow the steps:

1. Click to fix the width for the text component.

2. Go to the resizing section in the Right Sidebar.

3. Fix the borders for the text.

To pass data of type Image from Visual Builder to Component Designer, use the Parameters:

1. Click on Parameters in Toolbar

2. Click on Add Parameter in the Parameter sidebar

3. Click on Edit button to rename the Parameter

4. Change the type of the parameter to Image

5. Drop a test value for the Parameter

6. Save the test value

To show an image in the design, follow the steps:

1. Click on the shape you want to add an image to.

2. Go to the fills on the Right Sidebar.

3. Click on the Image button.

4. Click on the Set up with Formula button.

5. Specify the formula.

6. Select the corresponding parameter.

Hiding elements is useful for optimization, such as concealing large navigation menus on smaller screens. Conditional visibility improves user experience by showing only relevant content.

Hide elements in Component Designer using Conditional Visibility:

1. Click on the element you want to set conditional visibility to.

2. Go to the Right Sidebar.

3. Click on the Conditional Visibility button.

4. Scroll and choose the option that fits the best for your requirements.

Dynamically change elements in Component Designer using Conditional Fill:

1. Click on the element you want to set the conditional fill to.

2. Go to the Right Sidebar.

3. Go to the Fill section.

4. Click on the More button to see more options.

5. Scroll and choose the option that fits the best for your requirements.

To pass and bind simple data with the elements, follow the steps:

1. Click on the Gallery

2. Click on the Property card

3. Click on the Change Data Binding

4. Pass the corresponding Data for each of the Custom Components.

5. Click Use Selected Binding for saving.

To pass and bind data with the elements using Functions, follow the steps:

1. Click on the Gallery

2. Click on the Property card

3. Click on the Change Data Binding

4. Click on the Set up with Formula button

5. Click to search for the formula – CONCAT

6. Choose the fields: first_name and last_name – you want to concatenate: CONCAT(first_name, last_name)

7. Click on the Use selected binding for saving it

To set up Frame for Image – add Border to the Rectangle:

1. Select Ellipse

2. Click on the Add Border button on the Right sidebar

3. Set the color of the border

4. Set the thickness of the border

To add text to your design, follow the steps:

1. From the menu on the top left, click on the Text button.

2. Locate the field in your design.

3. Add a test value to the field and save it.

To connect the text field to the parameter using the formula, follow the steps:

1. Click on the field you want to connect a parameter to.

2. Click on the Function button.

3. Click on the Function button inside the field to specify the parameter.

4. Choose the parameter you want to connect.

Jet can automatically generate a user interface when creating a new page. There are several use cases that you can cover:

1. Record Review: allows you to view the details of a record selected from a list.

2. Record Update: update the data of a record chosen from the list.

3. Record Create: create new records using a form layout.

4. Dashboard: visual display of your data, incorporating KPIs and charts for a comprehensive overview.

Step 1: Upload Font Files to Storage

1. Navigate to Storage in Jet Admin.

2. Create a new folder for your font files (e.g., Fractul).

3. Upload all the required font files into this folder.

In the example below, the font files for "Fractul" are uploaded with different styles and weights such as:

• Fractul-Black.ttf

• Fractul-Bold.ttf

• Fractul-Italic.ttf

• Fractul-Light.ttf

• etc.

Step 2: Get the File Path

To get the correct file path for your font:

1. Click on the file in Storage.

2. In the details panel, click on the File Name.

3. This will open the file in a new tab.

4. The URL of this new tab is the direct path to the file, which you can use in your custom code.

Step 3: Define Fonts in Global CSS

Now that the font files are uploaded and you have your file paths, you can define them in Global CSS.

1. Navigate to App Settings in Jet Admin.

2. Go to Global CSS.

3. Paste the following CSS, adjusting the links according to the file paths you obtained:

@font-face {
  font-family: 'Fractul';
  font-style: normal;
  font-weight: 900;
  src: url('YOUR_FILE_PATH/Fractul-Black.ttf') format('truetype');
}

@font-face {
  font-family: 'Fractul';
  font-style: italic;
  font-weight: 900;
  src: url('YOUR_FILE_PATH/Fractul-BlackItalic.ttf') format('truetype');
}

@font-face {
  font-family: 'Fractul';
  font-style: normal;
  font-weight: 700;
  src: url('YOUR_FILE_PATH/Fractul-Bold.ttf') format('truetype');
}

@font-face {
  font-family: 'Fractul';
  font-style: italic;
  font-weight: 700;
  src: url('YOUR_FILE_PATH/Fractul-BoldItalic.ttf') format('truetype');
}

/* Add more font styles as needed */

body {
  --regular-font: 'Fractul', sans-serif;
  --heading-font: 'Fractul', sans-serif;
}

https://cdn-api.jetadmin.app/media/static_files/projects/YOUR_PROJECT/Fractul/Fractul-Black.ttf

Step 4: Reset Font to Default

If the font does not appear correctly, reset it by:

1. Going to App Settings > Global CSS.

2. Removing any existing font settings.

3. Saving and refreshing the page.

If you face any issues or need assistance, feel free to contact our support team.

In the Appearance section, you can customize the way that your app looks. This includes things like layout, colors, icons, themes, and font.

Font

The font can be changed in the Appearance settings as well. To change it, scroll down to the Fonts section, and choose a Regular and a Headings font. JetAdmin uses Google Fonts and offers an extremely wide range of font options. To view and compare fonts more easily, look at them on the Google Fonts site. If you do want to use your custom font, click on the + Custom font button, and you will be prompted to contact us so that we can help you with your custom font request.

Font for Sign In/Sign Up page

To change your font settings for the Sign In/Sign Up page, you need to have a custom domain set up. If you do, you can simply go to the Sign-Up page menu by clicking on the icon in the left-hand menu, and then changing the font in the menu on the right side of the page. Here you can also make other changes to appearance like customizing the background, adding a logo, or adding a custom welcome message.

Accent Color

Accent Color affects the highlight color for selected rows, the color of various components (e.g. buttons), and the color of the menu bar. To set the Accent Color for your app, simply go to the Appearance section in the App Settings menu and choose the color you would like to use.

Change the App's URL

The App name is the unique name of each application on Jetadmin. This feature allows you to change the app's unique name.

To change the app name, click on the URL box and rename your app with a unique name and click the "Change App URL" button.

App settings allow you to change the look and feel of the app and configure your app's parameters. You can find it in the left black bar in the builder mode.

1. Click on the App Settings

2. Hover your mouse over the menu to open it up

You'll see seven different tabs:

• Appearance - configure a color scheme and the layout of the app

• Menu - configure your app's menu, create sections, and reorder the elements

• App info - set up the app's name and service URLs

• Custom domain - set up a custom domain for your app

• Sign-up - customize the sign-up page, add your logo, favicon, etc

• Features - additional features

• Scripts & Styles - add global JavaScript and CSS

Jet Admin allows you to build custom business apps such as CRMs, admin panels, and internal tools using templates

Or create the app from scratch using drag-and-drop UI components

After creating a new app, you'll automatically get into the intuitive App Builder, where you can design, build, and deploy an app with drag-and-drop components, integrate resources, manage User & Team permissions, and customize the app appearance.

Here we’ll go over all the key elements and sections that will allow you to navigate Jet much more efficiently:

• Canvas

• Workspace

• Components

• Pages

• Data

• App Settings

• Sign in/Sign up

• Automation

• Preview & Share

Canvas

The canvas is the main element of the App Builder, the mode you'll use to create the application.

Workspace

If you need to create a new app or return to a previously created one, you can get back to the workspace from the App Builder by clicking on the button "My Apps" in the top left corner.

Components

• Basic components to work with Titles, Text, Images, Button, etс

Advanced tools to create even more custom solutions using:

• iFrame - a way to embed another webpage inside of your Jet app

Pages

From the top menu of the App Builder, you can duplicate, edit the current page, or manage page settings, parameters, and queries in Page settings.

Data

Or you can work with already connected resources — manage the integration, configure the field types, edit, delete, or create records, import and export data and create virtual collections (functionality varies based on the data source):

You can build apps with your data from pretty much Any Data Source: Firebase, Sheets, Airtable, Stripe, REST API, and so on.

Users & Teams management system

Here you can set permissions, define user roles, and manage members.

App Settings

• Appearance - customize colors and theme for your app

• Menu - customize your app's menu in user mode

• Custom domain - set up a custom domain for your app

• Features - additional features

• Sharing - set up the app's name and service

• Scripts & Styles - set up global JavaScript and customCSS

Sign in/Sign up

Preview & Share

There are three operational modes in Jet Admin:

• Builder mode, where you add data sources, drag-and-drop UI components, and so on

• User mode - this is the option that end users see after the app is published

• Preview mode that allows you to see the app preview in a user mode without having to publish an app.

Invite members via email or Public Access, and set permissions for already invited users.

You can always look through the documentation and video tutorials, or get expert support if you find it difficult to understand some issues. We are happy to help:)