📄️ Setup log file generation (Rsyslog)
The log file serves as a comprehensive record of audit logs, capturing crucial information about various activities within the ToolJet. Follow the guide below to set up and utilize the log file feature effectively.
📄️ Use Inspector in App-Builder
This guide introduces Inspector in the app-builder, a feature that lets you view data related to queries, components, global variables, page-related variables, user-set variables and constants.
📄️ Use Form Component
In this guide, we'll create a simple app that uses a Form component to add records to a database. We'll use ToolJet Database as our data source.
📄️ Dynamically Change Cell Colors in Table
This guide shows how to change the text color and background color of certain cells in a Table component based on specific conditions.
📄️ Conditional Formatting in Table
Conditional formatting enhances the visual representation of data by allowing you to dynamically adjust the appearance of cells in table component based on specific conditions. This how-to guide will guide you through the process of implementing advanced conditional formatting for text color and background color in a Table component.
📄️ Bulk update multiple rows in table
Currently, the data sources 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 data sources 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 a look at the exposed variables of the currentUser property by clicking on the inspector icon on the left sidebar:
📄️ 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 integrate external JavaScript libraries into your application using RunJS queries. This guide walks you through the process of importing and utilizing these libraries effectively.
📄️ Run Actions from RunJS query
ToolJet allows you to execute various actions within RunJS queries. This guide outlines the syntax and examples for each action.
📄️ Intentionally Throwing an Error in RunJS for Debugging
In this step-by-step guide, we'll walk you through the process of creating a RunJS query that intentionally throws an error for debugging purposes.
📄️ Run query at specified intervals
In this guide, we'll walk through the process of building a ToolJet application that automates data retrieval at specific intervals. By utilizing the RunJS queries, we can set up intervals for triggering queries, ensuring that the data is fetched dynamically and efficiently.
📄️ Translating JavaScript Objects to Python in RunPy
This guide demonstrates the utilization of the to_py() function in RunPy queries for converting JavaScript objects into their corresponding Python representations.
📄️ Accessing User Location with RunJS Query
In this step-by-step guide we will build a ToolJet application that harnesses the power of the JavaScript Geolocation API to retrieve the user's location. The Geolocation API offers access to various geographical data associated with a user's device, utilizing methods such as GPS, WIFI, IP Geolocation, and more.
📄️ 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.
📄️ 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.
📄️ Upload And View Images and PDFs Using Base64 String
This guide shows how to upload and view images and PDFs using the base64 string format.
📄️ Use Events on Chart
Currently, the chart component does not support events. However, you can use the Custom Component to create a chart using a third-party library that supports events. Plotly is one of the libraries that supports events. In this tutorial, we will build a chart using Plotly and add events to it.
📄️ Print data from multiple tabs
In this guide, we will learn how to print data from multiple tabs in ToolJet. This will be useful when you want to print an invoice or a report from your ToolJet application. For example, a tooljet app that has a set of tabs for each invoice and you want to print all the tabs in one go.