Chapitre 3 – Base de données intégrées

This database is built into the Convertigo platform and allows you to create business applications without any external connection.

As soon as you open your project, click the “No-code Database” tab at the top. You’ll then arrive at the database management interface. This is where you can create and manage all the data used in your application.

‍

On the right-hand side, click the “Add new…” button and select “Database”. Give your database a name. For example: “ClientTracking”, “HRFeedback”, or “Inventory”.

‍

‍

Once created, the database opens automatically and a first table is generated. You can start with this empty table, or import data if you already have some (CSV, JSON, XML, or even from PostgreSQL or Airtable).

‍

Your first table will appear. By default, it includes a single text column. Click the column header to rename it or change its type. Many field types are available:

Simple text, long text, number, date, email, phone number, checkbox, dropdown list, relation to another table, and even file uploads.

You can add as many columns as you need. Just click the “+” button on the right, then choose the name and type of the new field.

‍

‍

‍

On the left, you’ll find the sidebar with the list of all databases created in your project. Each database can contain one or multiple tables, and you can create as many tables as you like within a single database.

‍

‍

Each table works like a dynamic Excel sheet that you can fill in manually or automatically through your application.

Once your columns are set, you can begin adding rows manually or using forms inside your app. These data entries will then be available in your pages for display, filtering, or editing.

‍

‍

‍

Using AI to generate sample data for your internal tables

‍

Click the button below to download a sample CSV file with example data.  

You can use this file to import test data into your table and follow along with the tutorial.

‍

‍

During early development, it is often easier to test an application with realistic—but fictitious—data rather than empty tables. ChatGPT can help you create that data set in seconds, then deliver it as a CSV file you can import directly into the No-code Database.

Begin by deciding which columns your table needs. For example, if your app manages customer feedback you might require “Name”, “Department”, “Mood Score”, “Physical Well-being”, "Social Well-being", "Feedback Comment" and “Submitted At”. Once you have the column list, open ChatGPT and ask for a CSV. A concise prompt might read:

‍

“Generate a CSV with ten rows for a feedback table. Columns: Name, Department, Mood Score (1-10), Physical Well-being, Social Well-being, Feedback Comment, Submitted At (ISO date). Produce only the CSV text.”

‍

ChatGPT will respond with plain CSV content. Copy that response into a blank text file and save it with a .csv extension.

Return to the No-code Database tab in Convertigo, open the table you created, and click Import. Select the CSV file you just saved, let the wizard map each column, and confirm. Seconds later your table is filled with realistic entries, so you can immediately preview pages, test filters, and validate charts without waiting for real users to submit data.

‍

‍

Let's Import a set of data to populate our table

‍

‍