“Retool is a fast and easy way to build and maintain internal tools.”
We’re going to go over some basics that will set you up for success as you build and maintain these internal tools in Retool. Our docs are a fantastic resource to search through depending on your specific use case (connecting to Google Sheets, setting up pagination, what even is the List View component?), but there are a few things you should know before embarking on your journey.
Once you're finished with this guide, you'll be able to connect your database or API into Retool, write queries to read and write your data, and utilize Retool components to build functional apps.
You can read through the guide below in order (recommended), or pick any modules that pique your interest.
Let’s get started! (5 sections, ~5 hours total)
What is Retool? (5 min)
Remember, Retool has the following workflow:
- Connect your API or database, like PostgreSQL, MongoDB, Google Sheets, Salesforce, and 20+ more
- Get data into Retool from your database using queries to communicate with your connected resource
In short, API or database → Retool resource connection → Retool query → Retool component.
SQL databases like Postgres, MySQL, and MSSQL are some of the most popularly connected data sources to build Retool apps. And even if you're not using any of these directly, our Query JSON with SQL query type is convenient when working with JSON data, so it's worth getting comfortable with the basics!
To get up to speed with basic SQL (and how it relates to Retool), run through the SQL guide below.
SQL (1 hour)
The Retool workspace is divided into 4 visual boxes: (1) the main canvas, (2) the right panel, (3) the bottom panel and (4) the left panel. Each of these panels (2, 3, 4) have special names and functions that we’ll explore now.
App anatomy (15 min)
You might have noticed that the bottom panel has a lot going on, and you'd be right—writing queries is arguably the most important part of getting your Retool apps in shape. The link below walks you through how to write queries in Retool.
Query anatomy (25 min)
Just like with web apps, there's a lot to do once you've got your first Retool app working. The first place to get started is sharing apps: how to make sure your work gets used.
App management (10 min)
Before embarking on your own, review this final doc on best practices for building performant Retool apps. This doc goes over a few small things you can be mindful of to keep your apps running as smoothly as possible.
Performant apps (10 min)
You did it! Go on with confidence and start building your own super cool, super fun apps.
If you get stuck, our docs are always available and we’re on Intercom from 9am-6pm PST ready to help. You can also engage with the community to see what other Retool users are building and troubleshooting. Have fun!
Updated about a month ago