Overview

Quickstart: build an employee directory

1
Create an application

Create a ToolJet Cloud account or open your self-hosted instance. Select Create new app, name it Employee Directory, and drag a Table component onto the canvas.

2
Create the data table

Open ToolJet Database and create a table named employees. Add fields such as firstname, lastname, email, department, position, and status, then add placeholder records.

3
Fetch records

In the Query Panel, add a ToolJet Database query named getEmployees. Choose the employees table and the List rows operation. Enable application-load execution if you want the table to populate automatically.

4
Bind the table

Set the table's data property to the query result:

{{queries.getEmployees.data}}
5
Add records

Create an addEmployees query with the Create row operation. Bind form values to the relevant fields:

{{components.table1.newRows[0].email}}
{{components.table1.newRows[0].firstname}}
6
Trigger refreshes

Add an event handler that runs getEmployees after addEmployees succeeds. Add a table event that runs addEmployees when a new row is saved.

7
Preview and release

Use Preview while building. When the app is ready, select Release, then use Share to provide access to end users.

Next steps#

Continue with Building apps to learn the visual builder, or connect a production source in Data sources.

Updated

Was this page helpful?