Creating an Engaging and SEO-Friendly Blog Post from a YouTube Video Transcript

Table of Contents

• Introduction to Community Call for ToolJet Product Updates
• Exploring the Global Data Sources Feature in ToolJet
• Utilizing the OpenAI Plugin from the Marketplace
• Demonstrating the Table Auto Column Generation Feature
• Conclusion and Q&A Session

Introduction to Community Call for ToolJet Product Updates

This is a community call from ToolJet to discuss the latest product updates, features, and use cases for the ToolJet platform. The goal is to provide a two-way communication channel for sharing product releases, updates, and gathering feedback, comments, and questions from users.

The main focus of this call is to cover the latest features available in ToolJet, specifically the global data sources, the OpenAI plugin, and the table auto-column generation feature. The format has been changed from previous community calls, where the focus was on building specific applications. Instead, this call will concentrate on demonstrating specific aspects of the releases with product updates and providing demos to show how these features can be utilized.

Exploring the Global Data Sources Feature in ToolJet

In previous versions of ToolJet, data sources were scoped to the application level. With the introduction of global data sources, users can now create a data source that can be accessed and perform operations across multiple applications.

To create a global data source, click on the 'Add New Data Source' button in the left sidebar. This will display a list of available data sources. From here, users can select the data source they want to create and configure its settings. Once created, the global data source will be accessible to all applications within ToolJet, eliminating the need to create a separate data source for each new application.

Utilizing the OpenAI Plugin from the Marketplace

ToolJet now features a plugin marketplace, accessible from the application itself. The marketplace offers pre-built plugins and integrations that users can install and utilize within their applications.

One of the first plugins available in the marketplace is the OpenAI plugin. To use this plugin, users must navigate to the marketplace, install the OpenAI plugin, and set up the necessary credentials. Once installed, the OpenAI plugin will appear as a global data source and can be accessed across all applications.

The OpenAI plugin supports two main operations: completions and chat. Users can follow the OpenAI documentation on the ToolJet website (docs.tooljet.com) to learn more about the supported queries and parameters for each operation.

To demonstrate the usage of the OpenAI plugin, an example CRM application was built. This application showcases how the OpenAI plugin can be integrated to generate personalized email content based on user prompts. By leveraging the OpenAI API, the application can generate tailored emails for various scenarios, such as requesting product feedback or sending payment reminders.

Demonstrating the Table Auto Column Generation Feature

ToolJet now includes a feature that automatically generates table columns based on the data being displayed. This eliminates the need for users to manually define the table columns, as the columns will be generated dynamically based on the structure of the data.

To demonstrate this feature, a database dashboard application was built. This application connects to a PostgreSQL database and displays a list of all the tables within the database. When a user selects a specific table, the application retrieves the data from the database and automatically generates the table columns based on the structure of the data.

The table component used in the application remains the same, but the columns are dynamically generated based on the selected table. This feature proves to be particularly useful when working with databases, as it provides a convenient way to explore and interact with different tables without having to manually define the table columns for each one.

Conclusion and Q&A Session

The community call concluded with a recap of the topics covered, including the global data sources, the OpenAI plugin from the marketplace, and the table auto-column generation feature. Participants were encouraged to join the ToolJet Slack workspace (tooljet.com/slack) to ask any additional questions or share feedback.

The team at ToolJet expressed their openness to hearing from users through various channels, such as email, Twitter, and the Slack workspace. They are always willing to assist users with building applications or addressing any queries related to ToolJet.

FAQ

Q: What are the major features and updates in ToolJet 2.5.0?
A: The major updates in ToolJet 2.5.0 include access to the Plugin Marketplace in Community Edition, support for gRPC data sources, ability to add rows from the table component, and bug fixes and UI enhancements.

Q: What is the difference between global and local data sources in ToolJet?
A: Global data sources can be accessed and used across multiple applications, whereas local data sources were specific and scoped to an individual application.

Q: How can I install and use the OpenAI plugin in ToolJet?
A: You can install the OpenAI plugin from the Plugin Marketplace, set up the required credentials, and then use it as a global data source to perform completions and chat operations.

Q: What is the Table Auto Column Generation feature in ToolJet?
A: The Table Auto Column Generation feature automatically generates the columns in a table component based on the structure of the data provided, eliminating the need to manually define the columns.

Q: Can I build a database dashboard with ToolJet?
A: Yes, you can build a database dashboard with ToolJet that connects to your databases, lists the available tables, and displays the data from selected tables using the Table Auto Column Generation feature.

Q: How can I get help or support for building applications with ToolJet?
A: You can join the ToolJet Slack workspace at tooljet.com/slack, post questions in the general channel, reach out via email, or follow ToolJet on Twitter for support and assistance.

Q: What are some other potential use cases for the OpenAI plugin?
A: The OpenAI plugin can be used for various tasks, such as generating SQL queries, code snippets, and even assisting in writing emails or other content.

Q: Can I use the gRPC data source for my applications?
A: Yes, with ToolJet 2.5.0, you can now perform gRPC calls and connect to gRPC services as a data source.

Q: Is the OpenAI plugin available in the Enterprise Edition of ToolJet?
A: The OpenAI plugin was initially released for the ToolJet Enterprise Edition and is now available in the Community Edition starting with version 2.5.0.

Q: Are there any upcoming features or improvements planned for ToolJet?
A: Yes, ToolJet is continuously improving and adding new features. You can stay updated by following the release notes on the ToolJet GitHub page or joining the ToolJet Slack workspace.