📄️ Use Inspector
In this how-to guide, we will take a look at Inspector of the app-builder and see how it can be helpful in building applications.
📄️ Use form component
In this how-to guide, we will be building a simple application that will leverage the form component for adding a record into the database. For this guide, we will be using Google Sheet datasource to read and write data.
📄️ Change text color in columns of the table
In this how-to guide, we will build an app that will use a sample RestAPI to display the data in the table, and then we will change the text color of the columns according to the condition.
📄️ Bulk update multiple rows in table
Currently, the datasources in ToolJet have operation for bulk update(GUI mode) but that only works for changes made in the single row. We will soon be adding a new operation for bulk updating the multiple rows but for now we can bulk update multiple rows by creating a Custom JS query.
📄️ Delete multiple rows in table
The table component in the ToolJet has the option for bulk selection of rows that can have various use cases such as updating or deleting records. However, the datasources does not support bulk delete or bulk update operations.
📄️ Using Server Side Pagination in Tables
In this guide we will learn how to use server side pagination in table component. This will be helpful if you have a large data set and you want to load data in chunks. This will also help you to improve the performance of your application. This guide will be helpful if you are using datasources like MySQL, PostgreSQL, MSSQL, MongoDB, etc. in which you can use limit and offset to fetch data in chunks. We have also included an example to load data from Google Sheets in chunks.
📄️ Enable/Disable a component using current user's property
Let's take look at the exposed variables of the current user property:
📄️ Use Axios in RunJS
ToolJet allows you to utilize the three libraries - Moment.js, Lodash, and Axios. In this guide, we will see a few examples on how to use Axios library using RunJS query.
📄️ Import external libraries using RunPy
ToolJet allows you to utilize python packages in your app by importing them using the RunPy query.
📄️ Import external libraries using RunJS
ToolJet allows you to utilize external libraries in your app by importing them using the RunJS query.
📄️ Run Actions from RunJS query
Now you can trigger all the actions available in ToolJet from within the RunJS query. This guide includes the syntax for each action along with the example.
📄️ Intentionally fail a RunJS query
In this how-to guide, we will create a RunJS query that will throw an error.
📄️ Use the to_py() Function in RunPy: Converting JavaScript Objects to Python
This how-to guide will demonstrate the usage of to_py() function in RunPy queries for converting the JavaScript objects to Python.
📄️ Run query at specified intervals
In this how-to guide, we will learn how to make a query trigger at the specific intervals.
📄️ Access a user's location
In this how-to guide, we will build a ToolJet application that will utilize the JavaScript Geolocation API to get the user's location. The Geolocation API provides access to geographical location data associated with a user's device. This can be determined using GPS, WIFI, IP Geolocation and so on.
📄️ Use S3 signed URL to upload documents
In this how-to guide, you'll learn to upload documents to S3 buckets using the S3 signed URL from a ToolJet application.
📄️ Use custom endpoint for s3 hosts
In this how-to guide, we will see how we can connect to different S3 compatible object storages using the custom endpoint. In this guide, we are using Minio since it is an S3-compatible object storage.
📄️ REST API authentication using OAuth 2.0
ToolJet’s REST API data source supports OAuth 2.0 as the authentication type. In this guide, we’ll learn how to use Google OAuth2 API to delegate authorization and authentication for your ToolJet Application.
📄️ Upload files on AWS S3 bucket
This guide will help you in quickly building a basic UI for uploading or downloading files from AWS S3 buckets.
📄️ Upload files using GCS
In this guide, we are going to create an interface to upload PDFs to Google Cloud Storage.
📄️ Loading image/PDF from base64 string
In this how-to guide we will see how we can load an image or PDF file using the base64 string available on the database. In this how-to, we have used the postgres database which already has the base64 strings for the image or the PDF files available.