Editing README

screenElements:
Text Field
Status Dot

screenElements:
Dialog
Text Field
Button
Tab
Segmented Control
Text Field
Status Dot
Editable Text

screenPatterns:
Edit
Edit
Other Action

screenKeywords:
App Description & Documentation X
Description Max 250 characters
Enter a short description for this app
Editor README  User documentation
Preview README Last updated a few seconds ago by you
#### README
A README is ideal for providing information to the other editors of your app.
**Type some markdown herex* to start writing your README.
|App Description & Documentation X

Description Max 250 characters
Enter a short description for this app

Editor README ¢  User documentation

Preview README Last updated a few seconds ago by you
#i### README
|App Description & Documentation X

Description Max 250 characters
Enter a short description for this app

Editor README ¢  User documentation

W Edit README Last updated a few seconds ago by you

README
|Admin Panel
= o _ i B 0 - 100% m P Preview ~
= Description and documentation Edit
Header Inspect  Create
. \ Components Modules
Learn more v Community What's new ~ Welcome, John P
Q Search components
Main
Commonly used
3 = o =
Table Text Button Text Input
# —1 .
-
Number Input Select Container Form
- I O
Tabbed Modal Chart Key Value
Container
(a) G
Image Navigation
All queries completed. Text inputs
-
Code aQa = + [J General Response Advanced query1 » Run o .2 0
T s T ke S —I I
W query1 0.85 | oo e
Resource m onboarding_db Edit Q, Search tables or columns Editable Text Edlte;:ileeaText Email JSON Editor
. . Blu” =
SQL mode Run query automatically when inputs change Related tables (e Pl I ] : T—1
~ users
email # L CIaT Password Rlé:gi::;arxt Text Area Text Input
1 select * from users limit 100 id # bigint
active boolean
v—I
created_at timestamp
feature_flags jsonb URL
first_name varchar
Trancfarmar Enshla last_name varchar Numher inniite
(9 Latest No queries running % 92 0


Deploying a workflow

appName: Retool

appCategory: Developer Tools

appTagline: The best way to develop effective software

companyHqRegion: US & Canada

companyStage: Growth Stage

platform: web

pageType: Application

hotspotType: Click

screenPatterns:
Internal Tool
Canvas

screenElements:
Button
Top Navigation Bar
Switch
Button
Toolbar
Card
Accordion
Side Navigation
Badge

screenPatterns:
Acknowledgement & Success
Internal Tool
Canvas

pageType: Application Application

screenKeywords:
== Onboarding Demo - John Smith @ Latest version deployed Enable Deploy .
+ v 4 ¢ X P Run  — 100% + ,.‘
D
© startTrigger X -} fetchHNBestStories P X 8 G fetchStoryDetails | Loop H
Trigger Schedule i
99 RESTQuery (restapi) @ Use {{value}} and {{index}} variables
s m J current item in a loop.
hedule t nterva Action t URL
chedule type ction type Got it
Timezone +08 (Local) CET ORI o
news.firebaseio.com/v@/beststories.json
Mode GUI
Run every day ~ Show more options )
Iterable {} fetchHNBestStories
at 12:00 AM
At 12:00 AM, every day RESTQuery (restapi)
Action type URL
GET https://hacker-
news.firebaseio.com/ve,
value }}.json
~ Show more options
Logs ~ ® production -~ @
|-_ Onboarding Demo - John Smith © Undeployed changes Enable Deploy .
+ v 4 ¢ X P Run  — 100% + ,.‘
D
© startTrigger X -} fetchHNBestStories P X 8 C fetchStoryDetails | Loop H
Trigger Schedule i
99 RESTQuery (restapi) @ Use {{value}} and {{index}} variables
s m J current item in a loop.
hedule t nterva Action t URL
chedule type ction type —
Timezone +08 (Local) CET ORI o
news.firebaseio.com/v@/beststories.json
Mode GUI
Run every day ~ Show more options )
Iterable {} fetchHNBestStories
at 12:00 AM
At 12:00 AM, every day RESTQuery (restapi)
Action type URL
GET https://hacker-
news.firebaseio.com/ve,
value }}.json
~ Show more options
Logs ~ ® production -~ @


Signing up for the beta

pageType: Marketing

hotspotType: Keyboard Input

pagePatterns:
Features Page
Hero Section

screenElements:
Text Field
Button

screenElements:
Text Field
Button
Text Field
Text Field
Button

screenPatterns:
Acknowledgement & Success
Follow & Subscribe

pageType: Marketing Marketing Marketing

screenKeywords:
-_ Retool Products v Customers Integrations Pricing Docs Sign in
Power your apps with
Build apps faster with a Retool-hosted PostgreSQL database that requires no
setup time, and manage your data using an intuitive spreadsheet interface.
jsmith.mobbin@gmail.com
Thanks for requesting Retool Database beta access. We'll email you about the next steps soon!

@ Resources / Retool Database BETA @

customers orders
Add record Import v & Fields Y Filter $ Sort Refresh © Q

id team company phone email paid
Matt Bond [ Design Koala 925-212-8754 matt@koala.com
|-_ Retool Products v Customers Integrations Pricing Docs Sign in
Power your apps with
Build apps faster with a Retool-hosted PostgreSQL database that requires no
setup time, and manage your data using an intuitive spreadsheet interface.
jsmith.mobbin@gmail.com Sign up for the beta
-_ Resources |/ Retool Database BETA @
customers orders
Add record Import v & Fields Y Filter $ Sort Refresh
id team company phone email paid
Matt Bond [ Design Koala 925-212-8754 matt@koala.com
Sikan He Vegas 650-333-2781 sikan@vegas.com
Eeke de Miliano l broduct Strine 415-212-1234 ceke@strined com ™
|-_ Retool Products v Customers Integrations Pricing Docs Sign in
Power your apps with
Build apps faster with a Retool-hosted PostgreSQL database that requires no
setup time, and manage your data using an intuitive spreadsheet interface.
Work email Sign up for the beta
-_ Resources |/ Retool Database BETA @
customers orders
Add record Import v & Fields Y Filter $ Sort Refresh
id team company phone email paid
Matt Bond [ Design Koala 925-212-8754 matt@koala.com
Sikan He Vegas 650-333-2781 sikan@vegas.com
Eeke de Miliano l broduct Strine 415-212-1234 ceke@strined com ™


Releases and history

hotspotType: Hover

screenElements:
Tooltip
Dropdown Menu
Dialog
Stacked List
Tab
Segmented Control

screenPatterns:
Action Option
Timeline & History

pageType: Application Application Application

screenKeywords:
Release management is not available on

your plan. Upgrade your plan to create

and manage releases.
Releases History X
History L
Edit formTitle1 . .

. Current working version

You 2 minutes ago
Restore f:hanges 2 Restore
You 2 minutes ago
Edit forrI1T|tIe1 2 Restore
You 3 minutes ago
Edit fornﬂ 2 Restore
You 3 minutes ago
Create (?heckbox1 2 Restore
You 3 minutes ago
Create tfextlnput3 2 Restore
You 3 minutes ago
Create tfextlnputz 2 Restore
You 3 minutes ago
Edit forn"n 1; Delete ; Create textinput1 D Restore
You 3 minutes ago
Edit forn"n 1; Delete 9 Restore
You 3 minutes ago
Create ff':rmButtom 9 Restore
You 3 minutes ago
|Onboarding Page
= o 9 rag _ i B 0 - 100% m P Preview ~
= Description and documentation Edit
App actions
Header sect  Create
S Import app from JSON
Learn more v Community What's new ¥ Welcome, Jok ples
Export to JSON
ents
Main .
Duplicate app
Clone to module
Releases and history m T—1
t Button Text Input
Reload all queries
Upgrade components B
-
App settings ct Container Form
Scripts and styles | D
il
URL parameters
al Chart Key Value
Custom shortcuts
(a] G
Image Navigation
All queries completed. Text inputs
-
Code aQa = + [J General Response Advanced query1 » Run o .2 0
T s T ke S —I I
W query1 0.85 | oo e
Resource m onboarding_db Edit Q Search tables or columns Editable Text Edlte;:ileeaText Email JSON Editor
BIu”
SQL mode Run query automatically when inputs change Related tables (e Pl I z T—1
I
~ users
email # L CIaT Password Rlé:gi::;arxt Text Area Text Input
1 select * from users limit 100 id # bigint
active boolean
”—I
created_at timestamp
feature_flags jsonb URL
first_name varchar
Tranefarmar Enahla last_name varchar Niimher inniite
(9 Latest No queries running % 92 0
|Releases History X
History L
Edit formTitle1 . .

. Current working version
You 2 minutes ago
Restore f:hanges 2 Restore
You 2 minutes ago
Edit forrI1T|tIe1 2 Restore
You 3 minutes ago
Edit fornﬂ 2 Restore
You 3 minutes ago
Create (?heckbox1 2 Restore
You 3 minutes ago
Create tfextlnput?. 2 Restore
You 3 minutes ago
Create tfextlnputz 2 Restore
You 3 minutes ago
Edit forn"n 1; Delete ; Create textinput1 D Restore
You 3 minutes ago
Edit fornfﬂ ; Delete 9 Restore
You 3 minutes ago
Create ff:rmButton1 9 Restore
You 3 minutes ago


Archiving organisation

screenElements:
Text Field
Button
Divider

screenElements:
Button
Button
Text Field
Button
Divider

screenPatterns:
Delete & Deactivate Account
Settings & Preferences
Login

pageType: Application Application Application Application

screenKeywords:
Archive organization X
You will no longer be able to access this account or organization. Are you sure
you want to do this?

Cancel
|— Retool Q) Apps & Resources M Query Library i Learn ;’; Workflows BETA Upgrade e
Personal
Advanced
Account
Organization
Users
Permissions
Environments
Billing
Save
Branding Enterprise
Themes Business
Advanced
Beta Libraries
Add access to custom libraries to all applications in this organization. Retool includes out-of-the-box access to lodash, moment.js, uuid, and numbro.
Note: Adding preloaded libraries to all applications may negatively impact performance. We recommend adding preloaded libraries to individual applications when
possible to avoid potential issues. Learn More
Add Link
Cache queries across all users o«
Archive Organization
Archiving this Retool organization will also archive every user belonging to it.
Archive organization
|+~ Successfully archived organization.
Archive organization X
You will no longer be able to access this account or organization. Are you sure
you want to do this?
Cancel Archive organization
|-
== Retool
Welcome back
Need to create a new organization? Sign up here.
& Sign in with Google
or
Email
Password Forgot password?
By using Retool you are agreeing to our privacy policy and terms.


Logging out

screenElements:
Dropdown Menu
Avatar

screenElements:
Dropdown Menu
Avatar
Text Field
Button
Divider

screenKeywords:
-_ Retool O Apps & Resources @ Query Library i Learn &5 Workflows BETA Upgrade e
e John Smith
Admin
All (4) .
Welcome to Retool, John! Hide  settings
Recent
Audit logs
Starred N R O Data edit
ata editor
Build a simple app using a CSV M || B et SRS
Modules p'e app i 9 L SR bl kB oo ol b
Best way to start learning how to build in Retool . el L L B el R
. e i e Logout
Trash s rders h_
v e [ lm S Retool version 2.103.2
Learn with an example app = [ | -
Folders 9 . . ey porp 3 am—
Deconstruct a pre-built app to see how Retool works N PR A mume - e -
Start from scratch
If you already know what you want to build Intro to Retool 4:02
Al
Select all
o Add User Form
%% Module - 35 minutes ago by John Smith
o Admin Panel
~  App - 26 minutes ago by John Smith
o Basic Admin
9% Module - 32 minutes ago
o Sample Users Page
~  App - 2 hours ago
&% Invite new members o
|-
== Retool
Welcome back
Need to create a new organization? Sign up here.
& Sign in with Google
or
Email
Password Forgot password?
By using Retool you are agreeing to our privacy policy and terms.


Editing a table cell

screenElements:
Button
Loading Indicator

screenElements:
Button
Button
Loading Indicator
Checkbox
Toast

screenPatterns:
Edit
Loading
Edit
Acknowledgement & Success

screenKeywords:
Admin Panel
- i B 0O - 100% P Preview ~
= Manage users Edit
Header Inspect  Create
Components Modules
Q_ Search components
Main
Commonly used
First Name Last Name Email B Active
[ 2= @ o
Ben Bitdiddle ben@tryretool.com 4
Table Text Button Text Input
Eva Lu Ator evaluator@tryretool.com —
# —1 5
‘ -
DROP TABLE Users; droptable@xkcd.com Number Input Select Container Form
A B
Louis Reasoner louis@competitor.com Il D
[ ] 1
Tabbed Modal Chart Key Value
Alyssa P. Hacker tenx@tryretool.com Container
Save Changes 10of3 » ¥y Y C @ 0
Image Navigation
All queries completed. Text inputs
-
Code a = + [J General Response Advanced updateUser » Run o . 0
T s T ke S —I I
I getUsers —_— e
W updateUser e Q Search tables or columns Editable Text Editable Text Email JSON Editor
EVENT HANDLERS Area
Success + Add B/u” o
Related tables c Pl I = T T —1
getUsers.trigger() eoe S (TS
Password Rich Text Text Area Text Input
Failure + Add All tables Editor
i i i ~ ar_internal_metadata
Trigger queries, control components, or call other APIs in response to
query failure. These are not run when the query is previewed. key # varchar S—I
created_at timestamp
updated_at timestamp URL
value varchar
Numher inniite
(9 Latest No queries running % 92 0
|Admin Panel
- i B 0O - 100% P Preview ~
= Manage users Edit
Header Inspect  Create
(I7 usersTable
DATA -
Main
i usersTable
o O Data {{ getUsers.data }}
First Name Last Name Email B Active
Empty state No rows found
Ben Bitdiddle ben@tryretool.com 4
Show spinner when data is loading «©
Eva Lu Ator evaluator@tryretool.com Reset after successful save «©
N
Robert DROP TABLE Users; droptable@xkcd.com COLUMNS -
Columns (9) + Add
Louis Reasoner louis@competitor.com
Title Editable @
Alyssa P. Hacker tenx@tryretool.com @8 id X
£H First Name
™ Save Changes 1 0f3 » 43 Y C
& & fH Last Name
£ Email
Running queries... updateUser 0.7s fB created_at X
Code Q = + . ~ »
[] General Response Advanced updateUser Preview 0.7s O . (B updated_at X
I getUsers —_— e & Active
) updateUser Q Search tables or columns
B EVENT HANDLERS B feature_flags X
Success + Add trial_expiry_date X
Related tables c 8 -expins R
tU .tri
getUsers.trigger() > users Use dynamic column settings
Failure + Add All tables
' ' ' ~ ar_internal_metadata SORTING -
Trigger queries, control components, or call other APIs in response to
query failure. These are not run when the query is previewed. key # varchar
created_at timestamp Sort column Select column
updated_at timestamp
value varchar
ROW SELECTION -
(9 Latest Running updateUser: 0.7s % 92 0
|Admin Panel
- i B 0O - 100% m P Preview ~
= Manage users Edit
Header Inspect  Create
(I7 usersTable
DATA -
Main
i usersTable
o O Data {{ getUsers.data }}
First Name Last Name Email B Active
Empty state No rows found
Ben Bitdiddle ben@tryretool.com v
Show spinner when data is loading «©
Eva Lu Ator evaluator@tryretool.com Reset after successful save «©
Robert') DROP TABLE Users; droptable@xkcd.com COLUMNS -
Columns (9) + Add
Louis Reasoner louis@competitor.com
Title Editable @
Alyssa P. Hacker tenx@tryretool.com @8 id X
£H First Name
Showing 1-5 of 13 1|of3 » ¥y Y C
& & fH Last Name
£ Email
All queries completed. £8 created_at N
-
Code a = + [[J General Response Advanced updateUser » Run o .7 (B updated_at X
I getUsers —_— e @ Active
) updateUser Q Search tables or columns
B EVENT HANDLERS (B feature_flags B\
Success + Add trial_expiry_date X
Related tables c 8 -expins R
getUsers.trigger() .ee . .
> users Use dynamic column settings
Failure + Add All tables
i i i ~ ar_internal_metadata SORTING -~
Trigger queries, control components, or call other APIs in response to
query failure. These are not run when the query is previewed. key # varchar
created_at timestamp Sort column Select column
updated_at timestamp
value varchar
ROW SELECTION -
(9 Latest No queries running % 92 0
|Admin Panel
- i B 0 - 100% P Preview
= Manage users Edit
Header Inspect  Create
+~ updateUser ran successfully —
Components Modules
Q_ Search components
Main
Commonly used
First Name Last Name Email B Active
[ 2= @ o
Ben Bitdiddle ben@tryretool.com 4
Table Text Button Text Input
Eva Lu Ator evaluator@tryretool.com —
# —1 5
-
Robert DROP TABLE Users; droptable@xkcd.com Number Input Select Container Form
A B
Louis Reasoner louis@competitor.com Il D
[ ] 1
Tabbed Modal Chart Key Value
Alyssa P. Hacker tenx@tryretool.com Container
Showing 1-5 of 13 1]of3 » s+ YT C @ .
Image Navigation
Running queries... getUsers 0.7s Text inputs
-0
Code aQa = + [J General Response Advanced updateUser » Run o .2 0
T s T ke S —I I
W} getUsers 0.8s - T
W updateUser 0.75 | see Q, Search tables or columns Editable Text Editable Text Email JSON Editor
. EVENT HANDLERS Area
Success + Add B/u” o
Related tables c Pl I = T T —1
getUsers.trigger() eoe S (TS
Password Rich Text Text Area Text Input
Failure + Add All tables Editor
i i i ~ ar_internal_metadata
Trigger queries, control components, or call other APIs in response to
query failure. These are not run when the query is previewed. key # varchar S—I
created_at timestamp
updated_at timestamp URL
value varchar
Niimher inniite
(9 Latest Running getUsers: 0.7s % 92 0


Running a workflow

screenElements:
Drawer
Loading Indicator

screenElements:
Drawer
Loading Indicator
Top Navigation Bar
Switch
Button
Toolbar
Card
Accordion
Side Navigation
Badge
Drawer

screenPatterns:
Loading
Internal Tool
Canvas

screenKeywords:
-_ Onboarding Demo - John Smith © Undeployed changes Enable
¢ X » Run - 100% + ,."
Run History

9 .os

© startTrigger Ll O

Trigger el RESTQuery (restapi)

Schedule At 12:00 AM, every day (currently

disabled)
Action type URL

Logs v production
|-_ Onboarding Demo - John Smith © Undeployed changes Enable Deploy .
+ v 4 ¢ X P Run  — 100% + ,.‘
D
© startTrigger X -} fetchHNBestStories P X 8 C fetchStoryDetails | Loop H
Trigger Schedule i
99 RESTQuery (restapi) @ Use {{value}} and {{index}} variables
s m J current item in a loop.
hedule t nterva Action t URL
chedule type ction type —
Timezone +08 (Local) CET ORI o
news.firebaseio.com/v@/beststories.json
Mode GUI
Run every day ~ Show more options )
Iterable {} fetchHNBestStories
at 12:00 AM
At 12:00 AM, every day RESTQuery (restapi)
Action type URL
GET https://hacker-
news.firebaseio.com/ve,
value }}.json
~ Show more options
Logs ~ ® production -~ @
|-_ Onboarding Demo - John Smith © Undeployed changes Enable
¢ X » Run - 100% + ,."
Run History

9 © 376.8KB

Q@ startTrigger o O

Trigger Interval RESTQuery (restapi)

Schedule At 12:00 AM, every day (currently

disabled)
Action type URL

Logs v production
[Tue Nov 29 2022 18:38:35 GMT+0800] --- Successfully finished running query: fetchHNBestStories ---
[Tue Nov 29 2022 18:38:35 GMT+0800] --- Running query: fetchStoryDetails ---
[Tue Nov 29 2022 18:38:35 GMT+0800] Evaluating JS query: fetchStoryDetails
[Tue Nov 29 2022 18:38:38 GMT+0800] --- Successfully finished running query: fetchStoryDetails ---
[Tue Nov 29 2022 18:38:38 GMT+0800] --- Running query: filterStories ---
[Tue Nov 29 2022 18:38:38 GMT+0800] Evaluating JS query: filterStories
[Tue Nov 29 2022 18:38:38 GMT+0800] --- Successfully finished running query: filterStories ---
[Tue Nov 29 2022 18:38:38 GMT+0800] --- Running query: composeEmailMessage ---
[Tue Nov 29 2022 18:38:38 GMT+0800] Evaluating JS query: composeEmailMessage
[Tue Nov 29 2022 18:38:38 GMT+0800] --- Successfully finished running query: composeEmailMessage ---
[Tue Nov 29 2022 18:38:38 GMT+0800] --- Running query: sendEmail ---
[Tue Nov 29 2022 18:38:39 GMT+0800] --- Successfully finished running query: sendEmail ---
[Tue Nov 29 2022 18:38:39 GMT+0800] --- Successfully finished running the workflow ---


View access list

screenElements: Dialog Banner Avatar Tab

screenElements:
Dropdown Menu
Dialog
Banner
Avatar
Tab

screenKeywords:
-_ Retool O Apps & Resources @ Query Library i Learn &5 Workflows BETA Upgrade e
All (4) .
Welcome to Retool, John! Hide Learn more
Recent
Starred N R O .
Build a simple app using a CSV M || B et SRS ==
Modules p'e app i 9 L SR bl kB oo ol b o
Best way to start learning how to build in Retool . e L ol [ b o
Trash s orsers h_
Learn with an example app : e [ ——
Folders 9 . . ey porp 3 am—
Deconstruct a pre-built app to see how Retool works N PR A mume - e -
Start from scratch
If you already know what you want to build Intro to Retool 4:02
Al
Select all
o Add User Form
P2 Module - 38 minutes ago by John Smith
Admin Panel m >
App - a few seconds ago by John Smith
View access list
o Basic Admin
%% Module - 35 minutes ago Rename
Duplicate
o Sample Users Page
= App - 3 hours ago Export and download
Move to folder
Move to trash
&% Invite new members o
|Access list X
Users Groups
1 users have access to Admin Panel. To modify this, go to .
USER GROUPS PERMISSIONS
John Smith .
e jsmith.mobbin@gmail.com admin, All Users Own


About

hotspotType: Scroll Vertically

screenElements:
Avatar
Dropdown Menu
Table

pagePatterns:
Community Page
Community Page

screenKeywords:
= Retool Community Home Docs  Developer Network
& Fon Q=
elellitd  FAQ  Terms of Service  Privacy
About Retool Forum
Get help and learn what people are building with Retool
:& Our Admins
ben s alex Alex Tapper joeBumbaca
(Retool Team) (Retool Team) (Retool Team)
mohoq victoria Kabirdas Kabirdas Henry
(Retool Team) (Retool Team) i (Retool Team)
alina.retool Alina Din
everett_smith & alex-w Alex Westreich Community Manager (Retool
(Retool Team) (Retool Team) Team)
Tess a shawntax Shawn Taxerman kbn Kayla Bauhaus-Ness
g (Retool Team) < (Retool Team) - (Retool Team)
Kenny <2 Chris-Thompson sophiaqin
3 (Retool Team) (Retool Team) (Retool Team)
jmann Justin Mann jane Jane Kelly Ryland Ryland Wolff Baker
«4@ (Retool Team) (Retool Team) (Retool Team)
MikeLewis awright22 Alexander Wright mark Mark Florkowski
(Retool Team) (Retool Team) (Retool Team)
@ snir Snir Kodesh G IvanaSays Ivana lvanovic Q ryan Ryan Lucas
(Retool Team) (Retool Team) (Retool Team)
|= Retool Community Home Docs  Developer Network
& foum Q =
Latest Top
Badges Users
In accordance with the US holiday, Retool Support will be at lower capacity from Wednesday 11/23 thru Fric CGroups Tags
present on the forums for that time and also won't hold regular office hours on Thursday. .
Categories (2 more)...
We look forward to continuing working with you when we're back! M Queries and R... 1.8k M App Building 1.7k
M Feature Requ... 848 M Self Hosted R... 118
all categories » || alltags » | oLy Top  Latest W Discussion 112 Show and Tell 75
M Tips and Tricks 69 M Accountand.. 54
Category Topics Latest About FAQ
Keyboard Shortcuts
Discussion 6 / week & X @ Come join Rewwrwinve rivuro: .
Welcome to the #discussion category! This is a place to W App Building
talk discuss internal tools, find best practices, share
content, and ask general questions. 1
& & ¥ Welcome to the Retool community!
App Building 38/ week
Ge.t help and troubleshoot any problems you run into when Form not reacting to required fields 7
building apps o
B App Building
Queries and Resources 25 / week o S
. Form submitting whenever a field inside
Get help connecting to your data i (0}
is changed
W App Building bu
Self Hosted Retool 1/ week PP g9 e
This is your spot to post any questions (using Retool, bugs, Best toi t to 5 diff |
etc.) that relate to the on premise version of Retool est way 9 Insert {o I mysq 7
(enterprise or self serve). tables when i press a button?
M Queries and Resources
Account and User Management 3/ week
Add new record in mysql depending of 2
Mobile B [ weal n miilti ecalect valilee
|& foum Q =
Jay Jay Higgs prashant Prashant Mital samfitz Sam
(Retool Team) (Retool Team) (Retool Team)
Amanda * garrett Garrett Berg jSims John Sims
(Retool Team) (Retool Team) (Retool Team)
bryan-at-retool Bryan Alexi karloigarta
(Retool Team) (Retool Team) (Retool Team)
yogi Yogi Seetharaman Q Pawan Pawan Chahal ankur Ankur Rastogi
' (Retool Team) : (Retool Team) (Retool Team)
Shirley william-retool
(Retool Team) (Retool Team)
Lul Site Statistics
Last 24 hours Last 7 days Last 30 days All Time
Topics 1 84 333 5.5k
Posts 29 488 2.1k 35.2k
Users 6 57 239 4.7k
Active Users 51 357 769 —
Likes 8 84 419 6.0k
& Contact Us
In the event of a critical issue or urgent matter affecting this site, please contact us at
https://retool.com.


Hiding Getting Started resources

screenElements:
Toast
Top Navigation Bar
Button
Avatar
Side Navigation
Thumbnail
Search Bar
Stacked List
Icon
Floating Action Button
Badge

screenPatterns:
Acknowledgement & Success
Home

screenKeywords:
- .
- Q) Apps Resources ® Query Library oo L Upgrade e
- RetOOI s I You can revisit Getting Started resources in the Learn tab
Al
Recent
Starred Select all
Modules
Admin Panel
Trash ) . '
App - a minute ago by John Smith
o Basic Admin
P9 Module - 36 minutes ago
o Sample Users Page
~  App - 3 hours ago
&% Invite new members 0
|-_ Retool O Apps & Resources @ Query Library i Learn &5 Workflows BETA Upgrade e
All (4) .
Welcome to Retool, John! Hide Learn more
Recent
Starred N R O .
Build a simple app using a CSV M || B et SRS
Modules p'e app i 9 L SR bl kB oo ol b
Best way to start learning how to build in Retool . e L ol [ b o
Trash s oes -_—
Learn with an example app : e [ ——
Folders 9 . . ey porp 3 am—
Deconstruct a pre-built app to see how Retool works N PR A mume - e -
Start from scratch
If you already know what you want to build Intro to Retool 4:02
Al
Select all
o Add User Form
%% Module - 35 minutes ago by John Smith
o Admin Panel
~  App - 26 minutes ago by John Smith
o Basic Admin
9% Module - 32 minutes ago
o Sample Users Page
~  App - 2 hours ago
&% Invite new members o


Renaming a Table component

screenElements:
Text Field
Switch
Table
Side Navigation

screenKeywords:
= Admin Panel
- i B 0 - 100% m P Preview
= Manage users Edit
Header Inspect  Create
(I7 usersTable
DATA -
Main
i usersTable
Q@ ol Data {{ queryl.data }}
id email first_name last_name created_at updated_at active
Empty state No rows found
2 evaluator@... Eva Lu Ator Dec 2, 201... Nov 29, 20...
Show spinner when data is loading «©
3 droptable@..  Robert) DROP TABL..  Dec3,201..  Nov 29, 20... Reset after successful save «©
4 louis@com... Louis Reasoner Dec 4, 201... Nov 29, 20... COLUMNS -
Columns (9) + Add
5 tenx@tryre... Alyssa P. Hacker Dec 5, 201... Nov 29, 20...
Title Editable
6  cy@tryreto... CyD. Fect Dec 6, 201... Nov 29, 20... (Hid
£ email
Showing 1-5 of 13 1|of3 » ¥y Y C
I I [ first_name
[ last_name
All queries completed. {1 created_at
-
Code aQa = + [[] General Response Advanced query1 » Run o .7 [ updated_at
W query1 0.7s | soe - [ active
Resource ¥} onboarding_db Edit Q Search tables or columns (1 feature_flags
SQL mode Run query automatically when inputs change Related tables (e B trial_expiry_date
v users Use dynamic column settings
email # varchar
1 select * from users limit 100 id # bigint
A SORTING -
active boolean
Created at CHISEE Sort column Select column
feature_flags jsonb
first_name varchar
Trancfarmar Enahla Iast_name varchar ROW SELECTION -
(9 Latest No queries running % 92 0
|= Admin Panel
- i B 0 - 100% m P Preview
= Manage users Edit
Header Inspect  Create
(1 table1
DATA -
Main
i table1
Q@ ol Data {{ queryl.data }}
id email first_name last_name created_at updated_at active
Empty state No rows found
2 evaluator@... Eva Lu Ator Dec 2, 201... Nov 29, 20...
Show spinner when data is loading «©
3  droptable@...  Robert') DROP TABL...  Dec 3, 201... Nov 29, 20... Reset after successful save ©
4 louis@com... Louis Reasoner Dec 4, 201... Nov 29, 20... COLUMNS -
Columns (9) + Add
5 tenx@tryre... Alyssa P. Hacker Dec 5, 201... Nov 29, 20...
Title Editable
6  cy@tryreto... CyD. Fect Dec 6, 201... Nov 29, 20... (Hid
£ email
Showing 1-5 of 13 1|of3 » ¥y Y C
I I [ first_name
[ last_name
All queries completed. {1 created_at
-
Code aQa = + [[] General Response Advanced query1 » Run o .7 [ updated_at
W query1 0.7s | soe - [ active
Resource ¥} onboarding_db Edit Q Search tables or columns (1 feature_flags
SQL mode Run query automatically when inputs change Related tables (e B trial_expiry_date
v users Use dynamic column settings
email # varchar
1 select * from users limit 100 id # bigint
A SORTING -
active boolean
Created at CHISEE Sort column Select column
feature_flags jsonb
first_name varchar
Trancfarmar Enahla Iast_name varchar ROW SELECTION -
(9 Latest No queries running % 92 0
|= Admin Panel
- i B 0 - 100% m P Preview
= Manage users Edit
Header Inspect  Create
1 table1 2 e
DATA -
Main
i table1
Q@ ol Data {{ queryl.data }}
id email first_name last_name created_at updated_at active
Empty state No rows found
2 evaluator@... Eva Lu Ator Dec 2, 201... Nov 29, 20...
Show spinner when data is loading «©
3 droptable@..  Robert) DROP TABL..  Dec3,201..  Nov 29, 20... Reset after successful save «©
4 louis@com... Louis Reasoner Dec 4, 201... Nov 29, 20... COLUMNS -
Columns (9) + Add
5 tenx@tryre... Alyssa P. Hacker Dec 5, 201... Nov 29, 20...
Title Editable
6  cy@tryreto... CyD. Fect Dec 6, 201... Nov 29, 20... (Hid
£ email
Showing 1-5 of 13 1|of3 » ¥y Y C
I I [ first_name
[ last_name
All queries completed. {1 created_at
-
Code aQa = + [[] General Response Advanced query1 » Run o .7 [ updated_at
W query1 0.7s | soe - [ active
Resource ¥} onboarding_db Edit Q Search tables or columns (1 feature_flags
SQL mode Run query automatically when inputs change Related tables (e B trial_expiry_date
v users Use dynamic column settings
email # varchar
1 select * from users limit 100 id # bigint
A SORTING -
active boolean
Created at CHISEE Sort column Select column
feature_flags jsonb
first_name varchar
Trancfarmar Enahla Iast_name varchar ROW SELECTION -
(9 Latest No queries running % 92 0


Templates

pagePatterns:
Templates Page
Hero Section

screenElements:
Side Navigation
Grid List
Thumbnail

screenElements:
Dropdown Menu
Text Field
Button
Search Bar
Side Navigation
Grid List
Thumbnail

pagePatterns:
Landing Page
Templates Page
Templates Page
Hero Section
Templates Page

pageType: Marketing Marketing Marketing Marketing Marketing

screenKeywords:
-
- Retool Products v Customers Integrations Pricing Docs Sign in Start for free
Components
Workflows
. nate cron jobs, custom alerts, and ETL tasks with Retool Workflows. Learn more -
Mobile
Database
-
=maes | jnternal tools, remarkably fast
y
Self-hosted
with Ul libraries, hacking together data sources, and figuring out access
controls. Start shipping apps that move your business forward.
Watch demo
Try Retool for free - °
[ BN J
Inspector Components
& Good morning, Alex!
Customers 281 Y 1tly u
Select a customer to view their metrics. Active MRR  $284,432
A Text
Company name Proiect manager Supports markdown or HTML
Search here Select a manager Active subscription Analytics 1 Input
Control other components or
I
Niarkettier . R ) queries with text
Initech brosd
Select a tier Select a manager . ropdown
9 Customer since Jun 24, 2018 hd Select one value from a list of
options.
, Usage Records validated
12 results Y Button
m Trigger actions like run queries,
id Company name CSM MRR export data, or open other apps.
83.33% 40.78%
1 Initech Jessica Mohaim $321.50 | ’ |:| Table
Display tabular data with
pagination. .
2 Circle Health Duncan Idaho $111.00 —d
Used 5 Validated 31
3 Yogi sportswear Maya Gao $438.50 Monthly 12 Monthly 95 Key yal}.le map -
|-_ Retool Products v Customers Integrations Pricing Docs Book a demo Start for free
] CUPPUIC O AU T arTsT Suppurt o ATy UGS 7 VIE T asTovary
Elasticsearch
Firebase
Github ] Custom message Ready to merge
Select file
Google Sheets Enter message Add recipe
GraphQL ACL permissions Proviow @ mayagao
Lambda ® Private x <0 Clean up multi-line input
MSSQL Public-read " @ mayagao
MongoDB
MySQL S3 File Explorer Slack Notifier GitHub PR Dashboard
PostgreSQL The missing GUI for Amazon's S3. A way to easily share data with your An all-in-one view of all your PRs.
REST API Click on a file in the table to preview team in Slack. Pull in data from your See which PRs are: blocked on your
s3 it, upload files, and download files. database, and use variables from... review, unassigned to a reviewer,...
Content / CMS Comms and Email Dashboard
Salesforce
Segment
SendGrid
Slack Action Facility name Customer list Usage New trial date
Stripe S T, 9 Retool ® Now 4 days from now
ili ets.com 9,
Twilio NYC Depart... 9 p Order #1
yogi sportswear
Firebase Admin Panel Customer Success Panel Customer Support Tool
An admin panel template with basic LeadGenius uses Retool to make A way to view and manage all your
CRUD views for Firebase. Select a their customer data accessible customer support interactions via
collection, and click on a documen... across the organization. This... Retool. This tool pulls in a list of...
Admin Panel Support Tool - Admin Panel Support Tool - Admin Panel ‘
|-_ Retool Products v Customers Integrations Pricing Docs Book a demo

GDPR Data Export Elasticsearch Admin Panel MSSQL Admin Panel
A tool to help with compliance, Provides a custom Elasticsearch A simple admin panel for managing
compliance, compliance! When a dashboard to visualize metrics, data in a Microsoft SQL Server
customer asks for an export of all... traces, and logs, and easily build... database. Easily view records in a...
Compliance Analytics / ML - Admin Panel Support Tool - Admin Panel

stripe

I

Credits $1000 D m

A=
Stripe Credits A

P PP Suggest a template
An all-in-one tool that provides
everything a SaaS company needs Your email
to manage and add startup credits...
Support Tool

Your suggestion
Send suggestion
|-_ Retool Products v  Customers Integrations Pricing Docs Sign in -
- u
Rapidly develop tools with ready-made templates
From admin panels to dashboards and CRMs, these ready-made Retool templates provide
inspiration with just one click. Connect them to your own data sources and start customizing.
Q Search templates
CATEGORIES Showing all 40 templates
Customer Success
Customer Support Account Transactions
Data and Analytics B
4 en Jessica 51474 $29,368 m
DevOps Louis Created at ... 54368 $500 Send email
Engineering Maya 51822 I I
Marketing Jessica 53124 I 3/32 2/24
Operations
Product PostgreSQL Admin Panel MongoDB Admin Panel Custom CRM
Sales An admin panel for reading from An admin panel for reading from A customizable relationship
and writing to your customer data, and writing to your accounts data, management tool, tailored to your
USE CASES built on PostgreSQL. This app lets... built on MongoDB. This app lets yo... specific needs. Pull lead informati...
Support Tool - Admin Panel Support Tool - Admin Panel CRM
Admin Panel
Analytics / ML
CRM
|S
CATEGORIES Showing all 40 templates
Customer Success
Customer Support User User details Account Transactions 2
Data and Analytics
4 gen Jessica 51474 $29,368 m Amount Next step
DevOps Louis Created at ... 54368 $500 Send email
f : Maya

Engineering y. Ris22 ' ' . Last contract Next contract
Marketing Jessica S 53124 3/32 2124
Operations
Product PostgreSQL Admin Panel MongoDB Admin Panel Custom CRM
Sales An admin panel for reading from An admin panel for reading from A customizable relationship

and writing to your customer data, and writing to your accounts data, management tool, tailored to your
USE CASES built on PostgreSQL. This app lets... built on MongoDB. This app lets yo... specific needs. Pull lead informati...

Support Tool - Admin Panel Support Tool - Admin Panel CRM
Admin Panel
Analytics / ML
CRM |
Comms and Email et Yeerdetals stripe  Review complaint Start date End date
c I Ben .

ompliance . Jessica Select refund type
Louis Created at ...
Content / CMS
Maya Compose email

Support Tool
DATA SOURCES REST APl Admin Panel Stripe Refund Tool Charts

An admin panel for reading from A tool to pull in problematic orders A template designed to show off
CircleCl and writing to your customer data, from your database, issue refunds Retool's visualization capabilities --
Close.io built on Retool's REST API... via Stripe, and send confirmation... powered by Plotly.js and the World...
Datadog Support Tool - Admin Panel Support Tool Analytics / ML - Dashboard
Elasticsearch
Firebase
Github O, Custom message Ready to merge


Filtering templates

screenElements:
Side Navigation
Side Navigation
Grid List
Thumbnail

screenKeywords:
S
CATEGORIES Showing 19 templates matching 2 filters Clear all filters
Customer Success
e Customer Support User User details Account Transactions User User details
Data and Analytics B B
v en Jessica 51474 $29,368 m en Jessica

DevOps Louis Created at ... 54368 Louis Created at ...
Engineering Maya 51822 Maya
Marketing desslee 53124 . Jessica
Operations
Product PostgreSQL Admin Panel MongoDB Admin Panel REST APl Admin Panel
Sales An admin panel for reading from An admin panel for reading from An admin panel for reading from

and writing to your customer data, and writing to your accounts data, and writing to your customer data,
USE CASES built on PostgreSQL. This app lets... built on MongoDB. This app lets yo... built on Retool's REST API...

Support Tool - Admin Panel Support Tool - Admin Panel Support Tool - Admin Panel

o Admin Panel
Analytics / ML
CRM .
Comms and Email st"pe Review complaint Action Facility name Customer list Usage
Compliance Select refund type e O 9 Retool
ets.com 9,
Content / CMS NYC Depart.. 9 p 80%
Dashboard Compose email yogi sportswear
School distri... geoCities

Support Tool
DATA SOURCES Stripe Refund Tool Firebase Admin Panel Customer Success Panel

A tool to pull in problematic orders An admin panel template with basic LeadGenius uses Retool to make
CircleCl from your database, issue refunds CRUD views for Firebase. Select a their customer data accessible
Close.io via Stripe, and send confirmation... collection, and click on a documen... across the organization. This...
Datadog Support Tool Admin Panel Support Tool - Admin Panel
Elasticsearch
Firebase
Github R Name Quantity Price Create new code
|S
CATEGORIES Showing 13 templates matching 1 filter Clear all filters
Customer Success
e Customer Support User User details Account Transactions User User details
Data and Analytics B B
4 en Jessica 51474 $29,368 == en Jessica
DevOps Louis Created at ... 54368 Louis Created at ...
Engineering Maya 51822 Maya
Marketing desslee 53124 . Jessica
Operations
Product PostgreSQL Admin Panel MongoDB Admin Panel REST APl Admin Panel
Sales An admin panel for reading from An admin panel for reading from An admin panel for reading from
and writing to your customer data, and writing to your accounts data, and writing to your customer data,
USE CASES built on PostgreSQL. This app lets... built on MongoDB. This app lets yo... built on Retool's REST API...
Support Tool - Admin Panel Support Tool - Admin Panel Support Tool - Admin Panel
Admin Panel
Analytics / ML
CRM
Comms and Email Strlpe Review complaint New trial date Name Quantity Price
. ® Now 4 days from now
Compliance Select refund type Tea 32 $12.00
Content / CMS Order #1 Milk 103 $8.00
Compose email Salt 12 $3.23
Dashboard
Support Tool
DATA SOURCES Stripe Refund Tool Customer Support Tool Inventory Management
A tool to pull in problematic orders A way to view and manage all your An example tool to help manage an
CircleCl from your database, issue refunds customer support interactions via e-commerce business. Operations
Close.io via Stripe, and send confirmation... Retool. This tool pulls in a list of... teams at successful e-commerce...
Datadog Support Tool Support Tool - Admin Panel Support Tool - Admin Panel
Elasticsearch
Firebase
Github Create new code (STfety Antinn @R AAA User User details
|S
CATEGORIES Showing all 40 templates
Customer Success
Customer Support User User details Account Transactions 2
Data and Analytics
4 gen Jessica 51474 $29,368 m Amount Next step
DevOps Louis Created at ... 54368 $500 Send email
f : Maya

Engineering y. Ris22 ' ' . Last contract Next contract
Marketing Jessica S 53124 3/32 2124
Operations
Product PostgreSQL Admin Panel MongoDB Admin Panel Custom CRM
Sales An admin panel for reading from An admin panel for reading from A customizable relationship

and writing to your customer data, and writing to your accounts data, management tool, tailored to your
USE CASES built on PostgreSQL. This app lets... built on MongoDB. This app lets yo... specific needs. Pull lead informati...

Support Tool - Admin Panel Support Tool - Admin Panel CRM
Admin Panel
Analytics / ML
CRM |
Comms and Email et Yeerdetals stripe  Review complaint Start date End date
c I Ben .

ompliance . Jessica Select refund type
Louis Created at ...
Content / CMS
Maya Compose email

Support Tool
DATA SOURCES REST APl Admin Panel Stripe Refund Tool Charts

An admin panel for reading from A tool to pull in problematic orders A template designed to show off
CircleCl and writing to your customer data, from your database, issue refunds Retool's visualization capabilities --
Close.io built on Retool's REST API... via Stripe, and send confirmation... powered by Plotly.js and the World...
Datadog Support Tool - Admin Panel Support Tool Analytics / ML - Dashboard
Elasticsearch
Firebase
Github O, Custom message Ready to merge


Collapsing blocks

screenElements:
Top Navigation Bar
Switch
Button
Toolbar
Card
Accordion
Side Navigation
Badge
Card

screenKeywords:
-_ Onboarding Demo - John Smith © Undeployed changes Enable Deploy .
+ v 4 ¢ X P Run  — 100% + ,.‘
D
© startTrigger X -} fetchHNBestStories P X 8 C fetchStoryDetails | Loop H
Trigger Schedule i
99 RESTQuery (restapi) @ Use {{value}} and {{index}} variables
s m J current item in a loop.
hedule t nterva Action t URL
chedule type ction type —
Timezone +08 (Local) CET ORI o
news.firebaseio.com/v@/beststories.json
Mode GUI
Run every day ~ Show more options )
Iterable {} fetchHNBestStories
at 12:00 AM
At 12:00 AM, every day RESTQuery (restapi)
Action type URL
GET https://hacker-
news.firebaseio.com/ve,
value }}.json
~ Show more options
Logs ~ ® production -~ @
|-_ Onboarding Demo - John Smith © Undeployed changes (1) Enable Deploy .
+ v 4 ¢ X P Run  — 100% + ,.‘
D

© startTrigger < -} fetchHNBestStories i ¢ 8 C fetchStoryDetails | Loop H

Trigger Interval

Schedule At 12:00 AM, every day (currently

disabled)

Logs ~ ® production -~ @


Renaming a query

screenElements: Drawer Table

screenElements:
Editable Text
Drawer
Table
Editable Text
Editable Text

screenPatterns:
Acknowledgement & Success
Edit

pageType: Application Application Application Application Application

screenKeywords:
= Admin Panel
- i B 0 - 100% m P Preview
= Manage users Edit
Header Inspect  Create
usersTable
DATA
Main
i usersTable
Q@ ol Data {{ queryl.data }}
id email first_name last_name created_at updated_at active
Empty state No rows found
2 evaluator@... Eva Lu Ator Dec 2, 201... Nov 29, 20...
Show spinner when data is loading «©
3  droptable@...  Robert') DROP TABL...  Dec 3, 201... Nov 29, 20... Reset after successful save ©
4 louis@com... Louis Reasoner Dec 4, 201... Nov 29, 20... COLUMNS
Columns (9) + Add
5 tenx@tryre... Alyssa P. Hacker Dec 5, 201... Nov 29, 20...
Title Editable
6 cy@tryreto..  CyD. Fect Dec 6,201...  Nov 29, 20... id
email
Showing 1-5 of 13 1 0of3 » R ¢
I I first_name
last_name
All queries completed. created_at
Code N
[) General Response Advanced query1 D e » Run O . updated_at
W query? active
n - Search tables or columns
Resource ! onboarding_db Edit feature_flags
SQL mode Run query automatically when inputs change Related tables trial_expiry_date
users Use dynamic column settings
+~ Query ran successfully X Close
SORTING
id | email | first_name | last_name | created_at | updated_at | active
Sort column Select column
1 ben@tryretool.com Ben Bitdiddle 2018-12-01T00:... 2022-11-29T08:... true
2 evaluator@tryret... Eva Lu Ator 2018-12-02T01:... 2022-11-29T08:... false ROW SELECTION
Latest No queries running
|= Admin Panel
- i B 0 - 100% m P Preview
= Manage users Edit
Header Inspect  Create
(I7 usersTable
DATA -
Main
i usersTable
Q o Data {{ queryl.data }}
id email first_name last_name created_at updated_at active
Empty state No rows found
2 evaluator@... Eva Lu Ator Dec 2, 201... Nov 29, 20...
Show spinner when data is loading «©
3  droptable@...  Robert') DROP TABL...  Dec 3, 201... Nov 29, 20... Reset after successful save ©
4 louis@com... Louis Reasoner Dec 4, 201... Nov 29, 20... COLUMNS -
Columns (9) + Add
5 tenx@tryre... Alyssa P. Hacker Dec 5, 201... Nov 29, 20...
Title Editable
6  cy@tryreto... CyD. Fect Dec 6, 201... Nov 29, 20... (Hid
£ email
Showing 1-5 of 13 1 0of3 » R ¢
i o [ first_name
[ last_name
All queries completed. {1 created_at
-
W query1 1.0s | ses - [ active
" " Q, Search tables or columns
Resource ! onboarding_db Edit (1 feature_flags
SQL mode Run query automatically when inputs change Related tables c B trial_expiry_date
users Use dynamic column settings
+~ Query ran successfully X Close
SORTING -
id | email | first_name | last_name | created_at | updated_at | active
Sort column Select column
1 ben@tryretool.com Ben Bitdiddle 2018-12-01T00:... 2022-11-29T08:... true
2 evaluator@tryret... Eva Lu Ator 2018-12-02T01:... 2022-11-29T08:... false ROW SELECTION -~
(9 Latest No queries running % 92 0
|= Admin Panel
- i B 0 - 100% m P Preview
= Manage users Edit
Header Inspect  Create
usersTable
DATA
Main
i usersTable
Q@ ol Data {{ queryl.data }}
id email first_name last_name created_at updated_at active
Empty state No rows found
2 evaluator@... Eva Lu Ator Dec 2, 201... Nov 29, 20...
Show spinner when data is loading «©
3 droptable@..  Robert) DROP TABL..  Dec3,201..  Nov 29, 20... Reset after successful save «©
4 louis@com... Louis Reasoner Dec 4, 201... Nov 29, 20... COLUMNS
Columns (9) + Add
5 tenx@tryre... Alyssa P. Hacker Dec 5, 201... Nov 29, 20...
Title Editable
6 cy@tryreto..  CyD. Fect Dec 6,201...  Nov 29, 20... id
email
Showing 1-5 of 13 1 0of3 » R ¢
I I first_name
last_name
All queries completed. created_at
Code
[[] General Response Advanced query1 » Run o .7 updated_at
W query? active
n - Search tables or columns
Resource ! onboarding_db Edit feature_flags
SQL mode Run query automatically when inputs change Related tables trial_expiry_date
users Use dynamic column settings
+~ Query ran successfully X Close
SORTING
id | email | first_name | last_name | created_at | updated_at | active
Sort column Select column
1 ben@tryretool.com Ben Bitdiddle 2018-12-01T00:... 2022-11-29T08:... true
2 evaluator@tryret... Eva Lu Ator 2018-12-02T01:... 2022-11-29T08:... false ROW SELECTION
Latest No queries running
|= Admin Panel
- i B 0 - 100% m P Preview
= Manage users Edit
Header Inspect  Create
(I7 usersTable
DATA -
Main
i usersTable
Q o Data {{ queryl.data }}
id email first_name last_name created_at updated_at active
Empty state No rows found
2 evaluator@... Eva Lu Ator Dec 2, 201... Nov 29, 20...
Show spinner when data is loading «©
3 droptable@..  Robert) DROP TABL..  Dec3,201..  Nov 29, 20... Reset after successful save «©
4 louis@com... Louis Reasoner Dec 4, 201... Nov 29, 20... COLUMNS -
Columns (9) + Add
5 tenx@tryre... Alyssa P. Hacker Dec 5, 201... Nov 29, 20...
Title Editable
6  cy@tryreto... CyD. Fect Dec 6, 201... Nov 29, 20... (Hid
£ email
Showing 1-5 of 13 1 0of3 » R ¢
i o [ first_name
[ last_name
All queries completed. {1 created_at
-
W query1 1.0s | ses - [ active
" " Q, Search tables or columns
Resource ! onboarding_db Edit (1 feature_flags
SQL mode Run query automatically when inputs change Related tables c B trial_expiry_date
users Use dynamic column settings
+~ Query ran successfully X Close
SORTING -
id | email | first_name | last_name | created_at | updated_at | active
Sort column Select column
1 ben@tryretool.com Ben Bitdiddle 2018-12-01T00:... 2022-11-29T08:... true
2 evaluator@tryret... Eva Lu Ator 2018-12-02T01:... 2022-11-29T08:... false ROW SELECTION -~
(9 Latest No queries running % 92 0
|= Admin Panel
- i B 0 - 100% m P Preview
= Manage users Edit
Header Inspect  Create
usersTable
DATA
Main
i usersTable
o O Data {{ getUsers.data }}
id email first_name last_name created_at updated_at active
Empty state No rows found
1 ben@tryret... Ben Bitdiddle Dec 1, 201... Nov 29, 20... v
Show spinner when data is loading «©
2 evaluator@.. Eva Lu Ator Dec 2,201..  Nov 29, 20... Reset after successful save «©
3 droptable@... Robert') DROP TABL... Dec 3, 201... Nov 29, 20... COLUMNS
Columns (9) + Add
4 louis@com... Louis Reasoner Dec 4, 201... Nov 29, 20...
Title Editable
5  tenx@tryre...  AlyssaP. Hacker Dec 5,201...  Nov 29, 20... id
email
Showing 1-5 of 13 1|of3 » ¥y Y C
I I first_name
last_name
All queries completed. created_at
Code N
[) General Response Advanced getUsers » Run O . updated_at
i} getUsers e active
n - Search tables or columns
Resource ! onboarding_db Edit feature_flags
SQL mode Run query automatically when inputs change Related tables trial_expiry_date
users Use dynamic column settings
+~ Query ran successfully X Close
SORTING
id | email | first_name | last_name | created_at | updated_at | active
Sort column Select column
1 ben@tryretool.com Ben Bitdiddle 2018-12-01T00:... 2022-11-29T08:... true
2 evaluator@tryret... Eva Lu Ator 2018-12-02T01:... 2022-11-29T08:... false ROW SELECTION
Latest No queries running


Explore live demo

screenKeywords:
-
- Retool Products v Customers Integrations Pricing Docs Book a demo Start for free
[ 3O ]
Users Orders Products

Search by name... Add New User

1 # Email # FirstNa... # LastNa... # Ac... Created At Trial Expira... USER DETAILS

1 bobafett@... Ben Bitdiddle v Sep 20, 2018 ... Nov 30, 20... . .
Ben Bitdiddle

2 test@bobb... Eva Lu Ator v Sep 17,2018 ... Nov 16, 20... ID: 1

3 | ddroptable.. = Robert) DROP TAB... v Sep 19,2018 .. | Dec 4, 2022 Email: bobafett@course.course
Created At: September 20th 2018, 1:26:48 pm

4 louis@com... Louis Reasoner v Sep 16,2018 ... Nov 29, 20...

5 ap@hacker... Alyssa P. Hacker Sep 13,2018 ... Nov 24, 20...

6 cy@tryreto... CyD. Fect Sep 14,2018 ... Dec 9, 2022

1.... 123@ai.com Fo Seon v Nov 2, 2022 8:... Nov 6, 2022 TRIAL AND CREDITS

1... johncena@... john Cena Nov 3, 2022 6:... Nov 21, 20... A L
Trial Expiration Date: 2022-11-30

&= Retool
ot Test Somebody v Nov 14, 2022 ... Nov 2, 2022 Ubdate Undate t
Exniration: ndefinad
’
|-
- Retool Products v Customers Integrations Pricing Docs Book a demo Start for free
[ 3O ]
Users Orders Products
Search by name... Add New User
I # Email # FirstNa... # LastNa... # Ac... Created At Trial Expira... USER DETAILS
1 bobafett@... Ben Bitdiddle v Sep 20, 2018 ... Nov 30, 20... " 5
Ben Bitdiddle
2 test@bobb... Eva Lu Ator v Sep 17,2018 ... Nov 16, 20... ID: 1
3 | ddroptable.. = Robert) DROP TAB... & Sep 19,2018 .. | Dec 4, 2022 Email: bobafett@course.course
Created At: September 20th 2018, 1:26:48 pm
4 louis@com... Louis Reasoner v Sep 16,2018 ... Nov 29, 20...
5) ap@hacker... Alyssa P. Hacker Sep 13,2018 ... Nov 24, 20...
- &= ive: @ s .
6 cy@tryreto... CyD. Fect Sep 14,2018 ... Dec 9, 2022
Explore live demo
’
|-
- Retool Products v Customers Integrations Pricing Docs Book a demo Start for free
[ 3O ]
6 cy@tryreto... CyD. Fect Sep 14,2018 ... Dec 9, 2022
1.... 123@ai.com Fo Seon v Nov 2, 2022 8:... Nov 6, 2022 TRIAL AND CREDITS
1.. johncena@.. | john Cena Nov 3, 2022 6... | Nov 21, 20... Trial Expiration Date: 2022-11-30
1..| not Test Somebody v Nov 14,2022 .. | Nov 2, 2022 Update | v b, YYYY JFEEEE
Expiration: undefined
1... eecd@we.... hhyy tfgty Nov 15, 2022 ... Nov 15, 20...
Credits Used: 6767
2... polycentral... Ira Ko v Nov 17,2022 ... Nov 10, 20...
Creditl;p:saet: # Enter a number her : Update
2. TK TK TK 4 Nov 17,2022 ... Nov 17, 20...
2... benten@g... Ten Ben v Nov 18, 2022 ... Nov 24, 20... Credits Allocated: 2
2... jack@sprat... Jack Spratt 4 Nov 18, 2022 ... Nov 26, 20... -
Upda'te # Enter a number her Update
Credits v
Showing 1-14 of 20 1|of2 » + 3+ Y C Allocated
&= Retool
’


Resetting password

screenElements:
Text Field
Button
Divider

screenElements:
Text Field
Button

screenElements:
Text Field
Button
Text Field
Text Field
Button
Text Field
Button
Text Field
Button
Divider

screenPatterns:
Forgot Password
Forgot Password
Forgot Password
Forgot Password
Login

pageType: Application Application Application Application Application Application Application

screenKeywords:
+ Successfully reset password
-
== Retool
Welcome back
Need to create a new organization? Sign up here.

& Sign in with Google
or
Email
Password Forgot password?
By using Retool you are agreeing to our privacy policy and terms.
|== Retool

Finish resetting your password

Email
jsmith.mobbin@gmail.com

Token
38aebb9d576e064ac1c49e2abceedbb65a446f44

New password

Confirm new password
|-
== Retool
Reset your password
Enter the email address associated with your account. We will
send a reset link to your email.
jsmith.mobbin@gmail.com
Send reset link
By using Retool you are agreeing to our privacy policy and terms.
|-
== Retool
Reset your password
Enter the email address associated with your account. We will
send a reset link to your email.
Email
Send reset link
By using Retool you are agreeing to our privacy policy and terms.
|+~ Successfully sent reset password request
-
== Retool
Reset your password
Enter the email address associated with your account. We will
send a reset link to your email.
jsmith.mobbin@gmail.com
Link sent
By using Retool you are agreeing to our privacy policy and terms.
|== Retool
Finish resetting your password
Email
jsmith.mobbin@gmail.com
Token
38aebb9d576e064ac1c49e2abceedbb65a446f44
New password
New Password
Confirm new password
Confirm New Password
|-
== Retool
Welcome back
Need to create a new organization? Sign up here.
& Sign in with Google
or
Email
Password Forgot password?
By using Retool you are agreeing to our privacy policy and terms.


Editing an environment

screenElements:
Button
Button
Color Picker

screenPatterns:
Settings & Preferences
Edit

pageType: Application Application Application Application Application Application

screenKeywords:
— Retool Q) Apps & Resources M Query Library i Learn ;’; Workflows BETA Upgrade e
Personal .
Environments
Account
Organization ! Environments are not enabled in your plan.
. . Upgrade now
Users Upgrade to create multiple environments.
Permissions
Name Connected Resources
Environments
- ® production Default
Billing : : : : . 3 (Al)
Created 3 hours ago * An environment to define the production configuration of your resources
Branding Enterprise
@ staging N
Themes Business Created 3 hours ago ¢ An environment to define the staging configuration of your resources one
Advanced
Beta
|Edit production environment X
Name production
Display color @ #478860
o juration of your
Description
Z
- r s
|— Retool O Apps & Resources ® Query Library i Learn &5 Workflows BETA Upgrade e
Personal .
Environments
Account
Organization ! Environments are not enabled in your plan.
. . Upgrade now
Users Upgrade to create multiple environments.
Permissions
Name Connected Resources
Environments
. ® production Default
Billing . : : : . 3 (Al)
Created 3 hours ago * An environment to define the production configuration of your resources
Branding Enterprise
@ staging N
Themes Business Created 3 hours ago ¢ An environment to define the staging configuration of your resources one
Advanced
Beta
|- ;
- Q) Apps Resources ® Query Library @ Learn Upgrade e
- RetOOI 8 . +~ Successfully updated environment.
Personal .
Environments
Account
Organization ! Environments are not enabled in your plan.
. . Upgrade now
Users Upgrade to create multiple environments.
Permissions
Name Connected Resources
Environments
- ® production Default
Billing . . . ) . 3 (Al)
Updated a few seconds ago ¢ An environment to define the production configuration of your re...
Branding Enterprise
@ staging N
Themes Business Created 3 hours ago ¢ An environment to define the staging configuration of your resources one
Advanced
Beta
|Edit production environment X
Name production
Display color @ #3coz2nc
o An environment to define the production configuration of your

Description

resources

Z
Cancel Save
|Edit production environment X
Name production
Display color @ #3coz2nc
o juration of your
Description
4 7z
- r :


Explore all components

pagePatterns:
Misc
Feature Section

screenElements: Button Card Thumbnail

pagePatterns:
Misc
Header Section
Feature Section

screenElements:
Search Bar
Grid List
Card
Thumbnail

screenElements:
Search Bar
Grid List
Card
Thumbnail
Link
Icon
Button
Card
Thumbnail

pagePatterns:
Misc
Misc
Misc
Misc
Header Section
Feature Section
Misc
Feature Section

screenKeywords:
-_ Retool Guides Components Integrations Community Signin Get started
Section  Number inputs Search components
Text inputs
User name Description Email 1 {
. . 2 "data": [{
John Doe RSB HDIES TR D email@company.com 3 "type": "articles"
internal tools. i : '
4 "id": 1",
5 "attributes": {
Editable Text Editable Text Area Email I JSON Editor
Display click-to-edit text Display click-to-edit multiline text Enter an email and validate its format Edit and validate JSON I
Description D ipti
Password e User name
Heading 1 B I X US<S Retool is the fast way to build John D
cececccce internal tools. onn boe
Retool is the fast way to build internal tools. D
our building blocks and connect them to your
Password = Rich Text Editor pra Text Area Text Input =
Enter a password that is hidden or sh... Edit text using rich formatting I Enter multiple lines of text I Enter a single line of text
URL
https:// example.com
URL I
Enter a URL and validate its format
|-_ Retool Guides Components Integrations Community Sign in Get started
Section = Text inputs v Q Search components
Auur Loy o Looin Luunc % mapun ey ‘ ) o9 vprvaus:
Perform custom API authentication Embed a Looker dashboard Display a map with location markers Q0 Upload files to Amazon S3
Card number MM/YY
'S8 |
Stripe Card Form S Tableau E::3
Submit card information to Stripe -_—— Embed a Tableau visualization
Custom
Amount Title Refresh page.
Lorem ipsum dolor sit amet, consectetur
$12:000 4 $800 adipiscing elit, sed do eiusmod tempor . www.retool.com D @2
Stage Closed won Go to website (2
Custom Component HTML IFrame A
Embed a custom React component A container for custom HTML and CS... Embed a web page N
Have feedback about this page? Let us know
|-_ Retool Guides Components Integrations Community Sign in Get started
Section = Text inputs v Q Search components
Select start, end, ana Increment values Select a star, neart, or smiley raung Select a single value In a range
Select inputs
Select options
Select an option Select a car model O) Option
) ( Turn on option —
‘ 1 ‘ n L 3 Year / Make / Model v Option
) i () option
Button Group ° Cascader e — Checkbox e Checkbox Group
Select a button to trigger queries or a... Select values from a multi-level tree =z Toggle a boolean value Toggle a set of values
Select options Select an option Select options Select options
> [ ] Category 1 Requires verification v Option1 *  Option 3 v Option 1 v
v (m] Category 2 _
o Y Needs review ion 1 P Option 2
v Category 2 Option
Checkbox Tree Listbox Multiselect == Multiselect Listbox
Select values from a multi-level tree Select a single value — Select multiple values = Select multiple values p——
Select an option Select an option
e : Alignment
© option 2 Left Center Right =
Option 3 Requires verification v
Radio Group ° Segmented Control Select — Switch ©
1 2
Select one value from a set of options Select one value from a set of options Select or enter a single value — Toggle a boolean value
Switch group
|-_ Retool Guides Components Integrations Community Sign in
The best React component library is in
Retool r— & —
Retool components are optimized for the things that matter most for internal tools, with Ul and
formatting options to display and edit data from any source. Drag and drop to build Ul, write code
anywhere, and publish your apps in record time. —
Features
Comprehensive. Over 90 components and Customizable. Change styles, assign themes,
‘ counting to handle every data type and Ul for ‘ and choose from 3400 icons to make the Ul fa
internal tools. your own.
Powerful. Production-ready defaults that Accessible. Full keyboard support so all users
‘ tackle validation, formatting, time zone ‘ can navigate, edit, and save changes quickly
handling, and more. and comfortably.
Section = Text inputs Search components
Text inputs
User name Description Email 1 {
Retool is the fast way to build il & "d?ta” i B [ {" . .
John Doe S — email@company.com j :tlzpe ‘:1"art1C1es N
5 “attributés": {
|-_ Retool Products v Customers Integrations Pricing Docs Book a demo
90+ building blocks and counting
Everything you need to create beautiful internal apps your teams love.

eeccee * * * — v

Type Click Rate Select InPUtS

Over 40 inputs with built-in
e & . formatting anc.l validation for any
. data type, designed for data
fecord (B Toggle Uz density and fast user interaction.
Typography Buttons Qo —

a ctandard GitHiuih Elavarad llecea hiittone linke and NN —


Submitting feedback

screenElements: Popover Thumbnail Icon

screenElements:
Popover
Thumbnail
Icon
Text Field
Button
Text Field
Button

screenPatterns:
Help & Support
Feedback
Feedback

screenKeywords:
Admin Panel
- i B 0 - 100% m P Preview
= Manage users Edit
Header Inspect  Create
Components Modules
Q Search components
Main
Commonly used
First Name Last Name Email B Active Delete Add New User
O = @ =
Ben Bitdiddle ben@tryretool.com v B
- =
Email &4 ben@tryretool.com Table Text Button Text Input
Eva Lu Ator evaluator@tryret... B First name * Ben —
# —1I S
-
Robert DROP TABLE Use...  droptable@xkcd.... B Last name * Bitdiddle Number input  Select Container Form
Active * —
Louis Reasoner louis@competitor... g B .
h - — ,‘T‘ =
Alyssa P. Hacker tenx@tryretool.co... g Container — =
Showing 1-5 of 13 1]of3 » s+ YT C @ i =
Retool Overview (4 min)
Image Navi
@ View documentation
All queries completed. f
Text inputs . .
ay Ask the community
Code Q & + x
[[J General Response Advanced getUsers » Run O
T ¢ T B Chat with support
i} getUsers 1.35  ees e
f ; # Submit feedback
! updateUser Resource ) onboarding_db Edit Q Search tables or columns Editable Text Edlt:l
! deleteUser | © Reportabuse
SQL mode Run query automatically when inputs change Related tables (e Pl s
Keyboard shortcuts
~ users
A Password Rict " .
email # varchar ec  Take editor tutorial
1 select * id # bigint
gg fromusers active boolean 1 ?
3  order by id S —1I What's new?
created_at timestamp
feature_flags jsonb URL Component reference
first_name patchag Retool version 2.103.2 0
Trancfarmar Enshla last_name varchar Numher inniite
(9 Latest No queries running ® 92 0
|Submit Feedback X
Tell us a bit more
|Admin Panel
- i B 0 - 100% m P Preview
= Manage users Edit
Header Inspect  Create
Components Modules
Q Search components
Main
Commonly used
First Name Last Name Email B Active Delete Add New User
[ 2= @ o
Ben Bitdiddle ben@tryretool.com v B
- =
Email &4 ben@tryretool.com Table Text Button Text Input
Eva Lu Ator evaluator@tryret... B First name * Ben —
# —1 5
-
Robert) DROP TABLE Use...  droptable@xkcd.... B Last name * Bitdiddle Number Input  Select Container Form
Active * —
Louis Reasoner louis@competitor... B Il D
[ ] 1
- Tabbed Modal Chart Key Value
Alyssa P. Hacker tenx@tryretool.co... g Container
Showing 1-5 of 13 1]of3 » s+ YT C @ .
Image Navigation
All queries completed. Text inputs
-
Code aQa = + [J General Response Advanced deleteUser » Run o .2 0
T & T & < —1I I
W} getUsers 0.8s _
W updateUser Resource m onboarding_db Edit Q Search tables or columns Editable Text Edite;:ileeaText Email JSON Editor
}? deleteUser ol
GUI mode Run query only when manually triggered Related tables c Pl = z T—1
I I
> users
Password Rich Text Text Area Text Input
Table All tables Editor
> ar_internal_metadata
users )
> credits @ —1
Action type > deals
> dog_walkers URL
Delete a record > images
itame Niimher inniite
(9 Latest No queries running % 92 0
|Submit Feedback X
Hi


Getting in touch with developers

pagePatterns:
Misc
Feature Section
Contact Section

screenElements:
Text Field
Text Field
Button

screenElements:
Text Field
Text Field

screenElements:
Text Field
Text Field
Button
Text Field
Text Field

pagePatterns:
Misc
Feature Section
Contact Section
Contact Section

screenKeywords:
Here’s how it works:
0 Fill out the form below with some basic info °
e We’'ll get in touch to chat about project details, timeline, and
budget Thanks for your interest in the
©® Then we'll connect you with qualified developers with the right Retool developer network!
expertea WEe'll be in touch shortly to gather more details, get
to know you, and get you connected (like seriously
Retool matches you with developers, but doesn’t manage soon).
contracting or payment (but we do have templates if you need
them!).
-_ Retool Use Cases Integrations Developers Community Company
Admin panels PostgreSQL Changelog Community home About
Firebase GUI MySQL Documentation Support forum Customers
MongoDB GUI DynamoDB Status Show & tell Careers
GraphQL GUI Firebase On-prem deployment Retool for Startups Team
Dashboards GraphQL API Generator Internal Tools Report Blog
SQL GUI Amazon S3 Developer Utilities Engineering Time »
[ P Al Oleom ke Rebport
|I need help building my Retool apps
. Name

Here’s how it works:
0 Fill out the form below with some basic info
e We’'ll get in touch to chat about project details, timeline, and Email

budget
e Then we’ll connect you with qualified developers with the right

expertise Details
Retool matches you with developers, but doesn’t manage
contracting or payment (but we do have templates if you need
them!).

z
-_ Retool Use Cases Integrations Developers Community Company
AAdAmin nanale PAactaraO)l Channalam Cammiinitys heamao Ahnni+
|I need help building my Retool apps
. Name
Here’s how it works:
John
0 Fill out the form below with some basic info
e We’'ll get in touch to chat about project details, timeline, and Email
budget jsmith.mobbin@gmail.com
e Then we’ll connect you with qualified developers with the right
expertise Details
. Hi
Retool matches you with developers, but doesn’t manage '
contracting or payment (but we do have templates if you need
them!).
z
-_ Retool Use Cases Integrations Developers Community Company
AAdAmin nanale PAactaraO)l Channalam Cammiinitys heamao Ahnni+


Template detail

screenElements:
Side Navigation
Grid List
Thumbnail

screenElements: Button Chip Icon

screenElements:
Avatar
Chip
Button
Chip
Icon
Button
Button
Side Navigation
Grid List
Thumbnail

pagePatterns:
Templates Page
Social Proof (Testimonial) Section
Social Proof (Logo Cloud) Section
Templates Page
Templates Page
Templates Page
Templates Page

pageType: Marketing Marketing Marketing Marketing Marketing Marketing Marketing

screenKeywords:
-_ Retool Products v Customers Integrations Pricing Docs Book a demo Start for free
# Explore live demo
From startups to Fortune 500s, the world's most effective teams use i
Retool to power their internal apps. Our customers - @‘ at
=) DOORDASH m Brex ' emmaneend SBNBC These tools took months to build, but without them, our operators were
completely blocked.
@ Pinterest amazon Mercedes-Benz ~ ABInBev
What you can build . _ .
W|th Retool , Post image URL ame Quantity rice
Tea 32 $12.00
View all templates » Posttext Milk 103 $8.00
Salt 12 $3.23
N 0 v 2 sz
|-_ Retool Products v Customers Integrations Pricing Docs Sign in Start for free
¢ Back to all templates
Use cases
Support Tool Admin Panel
-
PostgreSQL Admin Panel
. . o . Customer Support  Operations
An admin panel for reading from and writing to your customer data, built on
PostgreSQL. This app lets you look through, edit, and add users, orders, and Resources
products.
W} PostgreSQL
Start with this template -
Components
= B £ = -
©
TabbedContainer
eoe
Users Orders Products
I # Email # FirstNa... # LastNa... # Ac... Created At Trial Expira... USER DETAILS
1 bobafett@... Ben Bitdiddle v Sep 20, 2018 ... Nov 30, 20... " 5
Ben Bitdiddle
|-_ Retool Products v Customers Integrations Pricing Docs Sign in Start for free
¢ Back to all templates
Use cases
Support Tool Admin Panel
-
PostgreSQL Admin Panel
. . o . Customer Support  Operations
An admin panel for reading from and writing to your customer data, built on
PostgreSQL. This app lets you look through, edit, and add users, orders, and Resources
products.
W} PostgreSQL
Start with this template -
Components
- A s
©
eoe
Users Orders Products
I # Email # FirstNa... # LastNa... # Ac... Created At Trial Expira... USER DETAILS
1 bobafett@... Ben Bitdiddle v Sep 20, 2018 ... Nov 30, 20... " 5
Ben Bitdiddle
|-_ Retool Products v Customers Integrations Pricing Docs Book a demo Start for free
= DOORDASH m Brex ' amentang SBNBC These tools took months to build, but without them, our operators were
completely blocked.
@ Pinterest amazon Mercedes-Benz ~ ABInBev
What you can build . .
With RetOOI ’ Post image URL Start date End date el CRENTiy i
Tea 32 $12.00
View all templates » Postiext Milk 103 $8.00
Salt 12 $3.23
N I wen' 2 3287
Buffer Content Scheduler Charts Inventory Management
Use your product data to create A template designed to show off An example tool to help manage an
social media posts. Pull in text and Retool's visualization capabilities -- e-commerce business. Operations
images from your database, and ad... powered by Plotly.js and the World... teams at successful e-commerce...
Content / CMS Analytics / ML - Dashboard Support Tool - Admin Panel
Try Retool today
o ] ]
|S
CATEGORIES Showing all 40 templates
Customer Success
Customer Support User User details Account Transactions 2
Data and Analytics
v gen Jessica 51474 $29,368 m Amount Next step
DevOps Louis Created at ... 54368 $500 Send email
. . Maya
Engineering y. Ris22 ' ' . Last contract Next contract
Marketing Jessica s 53124 3/32 2124
Operations
Product PostgreSQL Admin Panel MongoDB Admin Panel Custom CRM
Sales An admin panel for reading from An admin panel for reading from A customizable relationship
and writing to your customer data, and writing to your accounts data, management tool, tailored to your
USE CASES built on PostgreSQL. This app lets... built on MongoDB. This app lets yo... specific needs. Pull lead informati...
. Support Tool - Admin Panel CRM
Admin Panel See a live demo »
Analytics / ML
CRM |
Comms and Email et Yeerdetals stripe  Review complaint Start date End date
c I Ben .
ompliance . Jessica Select refund type
Louis Created at ...
Content / CMS
Maya Compose email
Support Tool
DATA SOURCES REST APl Admin Panel Stripe Refund Tool Charts
An admin panel for reading from A tool to pull in problematic orders A template designed to show off
CircleCl and writing to your customer data, from your database, issue refunds Retool's visualization capabilities --
Close.io built on Retool's REST API... via Stripe, and send confirmation... powered by Plotly.js and the World...
Datadog Support Tool - Admin Panel Support Tool Analytics / ML - Dashboard
Elasticsearch
Firebase
Github O, Custom message Ready to merge
|-
- Retool Products v Customers Integrations Pricing Docs Book a demo Start for free
[ 3O ]
Users Orders Products
Search by name... Add New User
I # Email # FirstNa... # LastNa... # Ac... Created At Trial Expira... USER DETAILS
1 bobafett@... Ben Bitdiddle v Sep 20, 2018 ... Nov 30, 20... " 5
Ben Bitdiddle
2 test@bobb... Eva Lu Ator v Sep 17,2018 ... Nov 16, 20... ID: 1
3 | ddroptable.. = Robert) DROP TAB... & Sep 19,2018 .. | Dec 4, 2022 Email: bobafett@course.course
Created At: September 20th 2018, 1:26:48 pm
4 louis@com... Louis Reasoner v Sep 16,2018 ... Nov 29, 20...
5) ap@hacker... Alyssa P. Hacker Sep 13,2018 ... Nov 24, 20...
- &= ive: @ s .
6 cy@tryreto... CyD. Fect Sep 14,2018 ... Dec 9, 2022
Explore live demo
’
|S
CATEGORIES Showing all 40 templates
Customer Success
Customer Support User User details Account Transactions 2
Data and Analytics
4 gen Jessica 51474 $29,368 m Amount Next step
DevOps Louis Created at ... 54368 $500 Send email
f : Maya

Engineering y. Ris22 ' ' . Last contract Next contract
Marketing Jessica S 53124 3/32 2124
Operations
Product PostgreSQL Admin Panel MongoDB Admin Panel Custom CRM
Sales An admin panel for reading from An admin panel for reading from A customizable relationship

and writing to your customer data, and writing to your accounts data, management tool, tailored to your
USE CASES built on PostgreSQL. This app lets... built on MongoDB. This app lets yo... specific needs. Pull lead informati...

Support Tool - Admin Panel Support Tool - Admin Panel CRM
Admin Panel
Analytics / ML
CRM |
Comms and Email et Yeerdetals stripe  Review complaint Start date End date
c I Ben .

ompliance . Jessica Select refund type
Louis Created at ...
Content / CMS
Maya Compose email

Support Tool
DATA SOURCES REST APl Admin Panel Stripe Refund Tool Charts

An admin panel for reading from A tool to pull in problematic orders A template designed to show off
CircleCl and writing to your customer data, from your database, issue refunds Retool's visualization capabilities --
Close.io built on Retool's REST API... via Stripe, and send confirmation... powered by Plotly.js and the World...
Datadog Support Tool - Admin Panel Support Tool Analytics / ML - Dashboard
Elasticsearch
Firebase
Github O, Custom message Ready to merge


Component detail

screenElements:
Search Bar
Grid List
Card
Thumbnail
Top Navigation Bar
Button
Search Bar
Side Navigation
Tab
Grid List
Table
Loading Indicator

screenPatterns:
Suggestions & Similar Items
Loading

pagePatterns:
Misc
API Docs & Developers Page
API Docs & Developers Page
API Docs & Developers Page

screenKeywords:
-_ Retool Guides Components Integrations Community Signin Get started
Section  Number inputs Search components
Text inputs
User name Description Email 1 {
. . 2 "data": [{
John Doe RSB HDIES TR D email@company.com 3 "type": "articles"
internal tools. i : '
4 "id": 1",
5 "attributes": {
Editable Text Editable Text Area Email I JSON Editor
Display click-to-edit text Display click-to-edit multiline text Enter an email and validate its format Edit and validate JSON I
Description D ipti
Password e User name
Heading 1 B I X US<S Retool is the fast way to build John D
cececccce internal tools. onn boe
Retool is the fast way to build internal tools. D
our building blocks and connect them to your
Password = Rich Text Editor pra Text Area Text Input =
Enter a password that is hidden or sh... Edit text using rich formatting I Enter multiple lines of text I Enter a single line of text
URL
https:// example.com
URL I
Enter a URL and validate its format
|-_ Retool Guides Components Integrations Community Signin Get started
Section = Text inputs Search components
Text inputs
User name Description Email 1 {
. . 2 "data": [{
Retool is the fast way to build " B v . .
John Doe e email@company.com 3 pre : "articles",
4 "id": 1",
5 "attributes": {
Editable Text Editable Text Area Email I JSON Editor
Display click-to-edit text Display click-to-edit multiline text Enter an email and validate its format Edit and validate JSON I
Description D ipti
Password e User name
Heading 1 B I X US<S Retool is the fast way to build John D
cececccce internal tools. onn boe
Retool is the fast way to build internal tools. D
our building blocks and connect them to your
Password = Rich Text Editor pra Text Area Text Input =
Enter a password that is hidden or sh... Edit text using rich formatting I Enter multiple lines of text I Enter a single line of text
URL
https:// example.com
URL I
Enter a URL and validate its format
|-_ Retool Guides Components Integrations Community Sign in Get started
Search components Ed.t bl T t
TEXT INPUTS
. A click-to-edit input field to enter a single line of text. Editable Text functions similarly to
Editable Text
i Text Input but is rendered as static text when not being edited. It can perform validation of
Editable Text Area
A required field, minimum or maximum length, email and URL formats, regular expression
i . patterns, and custom rules.
Rich Text Editor
Text Area Editable Text can automatically capitalize or check spelling, and supports browser autofill
Text Input types.
NUMBER INPUTS
Editable Number E I
Number Input Xamp es
Range Slider The following examples demonstrate some of the available functionality for Editable Text.
Rating
Slider
Input value Placeholder Disabled Read only SETTING VALUE
SELECT INPUTS
Default value George Washington
Button Group
Cascader Placeholder Enter a name...
Name
Checkbox Disabled false
George Washington 4
Checkbox Group Read only false
Checkbox Tree
Listbox
Multiselect
Multiselect Listbox
Radio Group
Segmented Control Labels
Select . . .
Position the label left or above and include a caption.
Switch
Switch Group Left Top Caption SETTING VALUE
DATE AND TIME INPUTS Default value George Washington
Calendar Input Label position left
Date Name George Washington ~ #
Date Range
|-_ Retool Guides Components Integrations Community Sign in Get started
Search components Ed.t bl T t
TEXT INPUTS
. A click-to-edit input field to enter a single line of text. Editable Text functions similarly to
Editable Text
i Text Input but is rendered as static text when not being edited. It can perform validation of
Editable Text Area
A required field, minimum or maximum length, email and URL formats, regular expression
i . patterns, and custom rules.
Rich Text Editor
Text Area Editable Text can automatically capitalize or check spelling, and supports browser autofill
Text Input types.
NUMBER INPUTS
Editable Number E I
Number Input Xamp es
Range Slider The following examples demonstrate some of the available functionality for Editable Text.
Rating
Slider
Input value Placeholder Disabled Read only SETTING VALUE
SELECT INPUTS
Placeholder Enter a name...
Button Group
Cascader Disabled false
Name
Checkbox Read only false
Ent /
Checkbox Group nieraname -
Checkbox Tree
Listbox
Multiselect
Multiselect Listbox
Radio Group
Segmented Control Labels
Select . . .
Position the label left or above and include a caption.
Switch
Switch Group Left Top Caption SETTING VALUE
DATE AND TIME INPUTS Default value George Washington
Calendar Input Label position left
Date Name George Washington ~ #
Date Range
|-_ Retool Guides Components Integrations Community Signin Get started
TOCus| ) SeliecL uie mpul e
Q Search components
TEXT INPUTS
Editable Text
Editable Text Area Related components
Password
Rich Text Editor
Text Area User name Email
Text Input John Doe email@company.com
NUMBER INPUTS
Editable Number .
Text Input I Email I
Number Input Enter a single line of text Enter an email and validate its format
Range Slider
Rating
Slider
URL Amount
SELECT INPUTS https:// example.com $32,000
Button Group
Cascader
Checkbox URL . Editable Number
Checkbox Group Enter a URL and validate its format Display a click-to-edit number
Checkbox Tree
Listbox
Multiselect Description
Multiselect Listbox Retool is the fast way to build
Radio Group internal tools.
Segmented Control
Select
. Text Area
Switch Enter multiple lines of text I
Switch Group
DATE AND TIME INPUTS
Calendar Input
Date
Date Range
|-_ Retool Guides Components Integrations Community Sign in Get started

Text size hé (14px)

Search components
TEXT INPUTS
Editable Text
Editable Text Area .
paceword Properties
Rich Text Editor Available properties for Editable Text with supported data types or values. You can write
Text Area JavaScript almost anywhere in Retool to manipulate or read information about
Text Input components.
NUMBER INPUTS
Editable Number NAME TYPE DESCRIPTION
Number Input
Range Slider value string The value of the input when it is not being edited. This is rendered as static text.
Rating ’ B : : i
i autoCapitalize 'none’ | Controls automatic capitalization of text input when using a virtual keyboard
Slider 'sentences’ |
SELECT INPUTS words® |
'characters’
Button Group
Cascader autoComplete boolean If true , the browser is allowed to automatically complete the input
Checkbox
autoFill string A token that describes the semantic meaning of the input so browsers can autofill with the
Checkbox Group . .
correct value. Only applied when autoComplete is true .
Checkbox Tree
Listbox editIcon IconKey The key of an icon to display to indicate editability
Multiselect o . .
i . formDataKey string When inside a Form, this key is used to pull the default value from form.initialData and
Multiselect Listbox construct the form.data property
Radio Group
Segmented Control hidden boolean If true , the component is currently hidden
Select . . . . . L .
hideValidationMessage boolean If true , no message will be displayed when the value is invalid
Switch
Switch Group iconAfter IconKey The key of an icon to display after the primary content
DATE AND TIME INPUTS iconBefore IconKey The key of an icon to display before the primary content
Calendar Input i . . .
B inputTooltip string Text to display in a tooltip below the input only on focus
ate

Date Range inputValue string The value a user enters into the field when the input is being edited. inputValue is used when
|-_ Retool Guides Components Integrations Community Sign in
Q Search components

TEXT INPUTS

Editable Text

Editable Text Area

Password

Rich Text Editor \

Lextites Loading component documentation...

Text Input

NUMBER INPUTS

Editable Number

Number Input

Range Slider

Rating

Slider

SELECT INPUTS

Button Group

Cascader

Checkbox

Checkbox Group

Checkbox Tree

Listbox

Multiselect

Multiselect Listbox

Radio Group

Segmented Control

Select

Switch

Switch Group

DATE AND TIME INPUTS

Calendar Input

Date

Date Range


Keyboard shortcuts

screenElements:
Popover
Keyboard Key

screenElements:
Popover
Thumbnail
Icon
Popover
Keyboard Key

screenPatterns:
Help & Support
Help & Support

screenKeywords:
Admin Panel
- i B 0 - 100% m P Preview
= Manage users Edit
Header Inspect  Create
Components Modules
Q Search components
Main
Commonly used
First Name Last Name Email B Active Delete Add New User
O = @ =
Ben Bitdiddle ben@tryretool.com v B
- =
Email &4 ben@tryretool.com Table Text Button Text Input
Eva Lu Ator evaluator@tryret... B First name * Ben —
# —1I S
-
Robert DROP TABLE Use...  droptable@xkcd.... B Last name * Bitdiddle Number input  Select Container Form
Active * —
Louis Reasoner louis@competitor... g B .
h - — ,‘T‘ =
Alyssa P. Hacker tenx@tryretool.co... g Container — =
Showing 1-5 of 13 1]of3 » s+ YT C @ i =
Retool Overview (4 min)
Image Navi
@ View documentation
All queries completed. f
Text inputs . .
ay Ask the community
Code Q & + x
[[J General Response Advanced getUsers » Run O
T ¢ T B Chat with support
i} getUsers 1.35  ees e
f ; # Submit feedback
! updateUser Resource ) onboarding_db Edit Q Search tables or columns Editable Text Edlt:l
! deleteUser | © Reportabuse
SQL mode Run query automatically when inputs change Related tables (e Pl s
Keyboard shortcuts
~ users
A Password Rict " .
email # varchar ec  Take editor tutorial
1 select * id # bigint
gg fromusers active boolean 1 ?
3  order by id S —1I What's new?
created_at timestamp
feature_flags jsonb URL Component reference
first_name patchag Retool version 2.103.2 0
Trancfarmar Enshla last_name varchar Numher inniite
(9 Latest No queries running ® 92 0
|= Admin Panel
- . B 0 - 100% m » Preview ~
- Edit
Create
Components
Keyboard Shortcuts X
Global
Add New User Global search %8| K
?
Ben Bitdiddle ben@tryretool.com v g Keyboard shortcuts
Email * ben@tryretool.com
Editor
Eva Lu Ator evaluator@tryret... |5 First name * Ben Toggle left panel 8| B
Toggle bottom panel 8|J
Robert DROP TABLE Use... droptable@xkcd.... |2 Last name * Bitdiddle A
Toggle right panel 8|U
Active” Toggle all | ®
— oggle all panels .
Louis Reasoner louis@competitor... = EE ?
m Toggle preview mode %|[o|[p
Alyssa P. Hacker tenx@tryretool.co... g Save %S
Undo 8| Z
1
Redo E IR R4
Show History modal 8|0 Y
All queries completed. S—
[0 General getUsers » Run o 2 Show grid ®
I} getUsers I Toggle grid ®| |6
I updateUser Resource I} onboarding_db Edit Toggle hidden components 2|/
I} deleteUser Select multiple 38| + Click
SQL d R 1 tically when i ts ch
QL mode un query automatically when inputs change P N5
users i
. Select without interacting % | + Click
email #
select * id # Drag without interacting 38|+ Drag
from users active
order by id Copy 2llc
created_at
feature_flags Cut 8|x
first_name Paste %[V
Trancfarmar Enahla last_name Niumher inniite


Duplicating app

screenElements:
Text Field
Button

screenElements:
Dropdown Menu
Text Field
Button
Text Field
Button

screenPatterns:
Action Option
Other Action
Other Action

screenKeywords:
Onboarding Page
= o 9 rag _ i B 0 - 100% m P Preview ~
= Description and documentation Edit
App actions
Header sect  Create
S Import app from JSON
Learn more v Community What's new ¥ Welcome, Jok ples
Export to JSON
ents
Main .
Duplicate app
Clone to module
Releases and history m T—1
t Button Text Input
Reload all queries
Upgrade components B
-
App settings ct Container Form
Scripts and styles | D
il
URL parameters
al Chart Key Value
Custom shortcuts
(a] G
Image Navigation
All queries completed. Text inputs
-
Code aQa = + [J General Response Advanced query1 » Run o .2 0
T s T ke S —I I
W query1 0.85 | oo e
Resource m onboarding_db Edit Q Search tables or columns Editable Text Edlte;:ileeaText Email JSON Editor
BIu”
SQL mode Run query automatically when inputs change Related tables (e Pl I z T—1
I
~ users
email # L CIaT Password Rlé:gi::;arxt Text Area Text Input
1 select * from users limit 100 id # bigint
active boolean
”—I
created_at timestamp
feature_flags jsonb URL
first_name varchar
Tranefarmar Enahla last_name varchar Niimher inniite
(9 Latest No queries running % 92 0
|Admin Panel (co
= o (copy) _ i B 0 - 100% m P Preview ~
= Description and documentation Edit
Header Inspect  Create
Components Modules
Q Search components
Main
Commonly used
First Name Last Name Email B Active Delete Add New User
[ == @ o
Ben Bitdiddle ben@tryretool.com v B
- =
Email &5 ben@tryretool.com Table Text Button Text Input
Eva Lu Ator evaluator@tryret... B First name * Ben —
# —1 5
-
Robert DROP TABLE Use...  droptable@xkcd.... B Last name * Bitdiddle Number Input  Select Container Form
Active * —
Louis Reasoner louis@competitor... B Il D
[ ] 1
- Tabbed Modal Chart Key Value
Alyssa P. Hacker tenx@tryretool.co... g Container
Showing 1-5 of 13 1]of3 » s+ YT C @ .
Image Navigation
All queries completed. Text inputs
-
Code aQa = + [J General Response Advanced getUsers » Run o .2 0
T & T ke S —I I
i} getUsers 0.95 | eoe e
W updateUser Resource m onboarding_db Edit Q Search tables or columns Editable Text Edlte;:ileeaText Email JSON Editor
! deleteUser ol
SQL mode Run query automatically when inputs change Related tables (e Pl = I z T—1
I
~ users
email # L CIaT Password Rlégi:;“ Text Area Text Input
1 select * id # bigint
gg fromusers active boolean
3 order by id —I
created_at timestamp
feature_flags jsonb URL
first_name varchar
Tranefarmar Enahla last_name varchar Niimher inniite
(9 Latest No queries running % 92 0
|Clone '‘Admin Panel' X
App name
Admin Panel (copy)
|Clone '‘Admin Panel' X
App name
Give your app a hame


API Generator

pagePatterns:
Landing Page
Footer Section

pagePatterns:
Misc
Header Section

screenElements: Button Banner

screenElements:
Text Field
Stepper
Button
Table

screenElements:
Link
Text Field
Stepper
Button
Table
Button
Banner

pagePatterns:
Landing Page
Footer Section
Misc
Misc
Misc
Header Section

pageType: Marketing Marketing Marketing Marketing

screenKeywords:
-_ Retool Products v Customers Integrations Pricing Docs Book a demo
~ - L J v v v L J v [ J [ J L J
GCL Sidlteu puliuinyg your el e e & e A °
= m e 6 6 6 o 0 0 O
internal tool in under 10 . Y %%
e 6 ¢ o 6 0 0 o
= e 6 o o e o o
minutes o e’ o
[ J
e 6 o o
: e o o o
Sign up for free Schedule a demo - o o ©
[
-_ Retool Use Cases Integrations Developers Community Company
Admin panels PostgreSQL Changelog Community home About
Firebase GUI MySQL Documentation Support forum Customers
MongoDB GUI DynamoDB Status Show & tell Careers
GraphQL GUI Firebase On-prem deployment Retool for Startups Team
Dashboards GraphQL API Generator Internal Tools Report Blog
SQL GUI Amazon S3 Developer Utilities Engineering Time
React components Google Sheets Report
Google Sheets GUI MongoDB
|-_ Retool Products v Customers Integrations Pricing Docs Book a demo Start for free
Gt paginate JRMQVIX/data?_page=2&_limit=10 Copy
POST /RmMQVIX/data Copy
PUT /RmMQVIX/data/1 Copy
&= Retool PATCH /RMQVIX/data/1 Copy
DELETE /RmMQVIX/data/1 Copy
Frequently Asked Questions
v R |
Will my API persist data? How long will my API be available for? Can | use my API outside Retool?
Yes, your APl has GET, PUT, POST, PATCH, and Your sample API will be available as long as you Yes, you can call this APl from wherever you
DELETE endpoints for reading + writing to your continue using it. We may delete it if it hasn’t need it (a mobile app, using cURL, Postman,
dataset. Writes are persisted. been used in the last 30 days - please contact us etc.). To use your APl in Retool, use our REST API
if that is a concern for your use case. connector.
- ~ ——
= * -_
How much data can | store? Does this cost anything? How was this built?
Your dataset can have at most 150 rows. Contact Nope! The API Generator is an embedded Retool app
us if you need a sample APl with more data. that uses some of our favorite open-source
libraries, including json-server, Moment.js,
faker.js and Lodash.
-_ DAI‘I\A' 'R .. PR o o e A ™ ool R T N e
|m Generate an APl from a CSV or a public data setGet started >
Build Your Dataset + addcoumn - AP] Preview
_
Column Title Data Type @ Huntington Benjefield
Poople/FulName v | m Heath Maring
API Name data # Rows 50 » nedetta hod
Preview: https://retoolapi.dev/.../data Size: 1 KB Rubina Albin
Generate API
Showing 50 results ¥y C
No API generated
You have not generated your API yet. Click Generate API to view endpoint details
‘
|-_ Retool Products v  Customers Integrations Pricing Docs Sign in Start for free
1 [
- FEATURED ON A
L) Q Product Hunt 1350
¥ Generate data that matches your use case.
Backend not ready? Still waiting for database access? ¥ Query with a flexible REST AP!.
Generate a custom dataset that you can read and write to ® Build an app for your API with Retool.
via a REST APL.
m Generate an APl from a CSV or a public data setGet started >
Build Your Dataset + addcoumn - AP| Preview
People / Full Name v .
o TReesese
_
T lowovewo |
o Emedrmee


Help

screenKeywords:
Admin Panel
- i B 0 - 100% m P Preview
= Manage users Edit
Header Inspect  Create
Components Modules
Q Search components
Main
Commonly used
First Name Last Name Email B Active Delete Add New User
O = @ =
Ben Bitdiddle ben@tryretool.com v B
- =
Email &4 ben@tryretool.com Table Text Button Text Input
Eva Lu Ator evaluator@tryret... B First name * Ben —
# —1I S
-
Robert DROP TABLE Use...  droptable@xkcd.... B Last name * Bitdiddle Number input  Select Container Form
Active * —
Louis Reasoner louis@competitor... g B .
h - — ,‘T‘ =
Alyssa P. Hacker tenx@tryretool.co... g Container — =
Showing 1-5 of 13 1]of3 » s+ YT C @ i =
Retool Overview (4 min)
Image Navi
@ View documentation
All queries completed. f
Text inputs . .
ay Ask the community
Code Q & + x
[[J General Response Advanced getUsers » Run O
T ¢ T B Chat with support
i} getUsers 1.35  ees e
f ; # Submit feedback
! updateUser Resource ) onboarding_db Edit Q Search tables or columns Editable Text Edlt:l
! deleteUser | © Reportabuse
SQL mode Run query automatically when inputs change Related tables (e Pl s
Keyboard shortcuts
~ users
A Password Rict " .
email # varchar ec  Take editor tutorial
1 select * id # bigint
gg fromusers active boolean 1 ?
3  order by id S —1I What's new?
created_at timestamp
feature_flags jsonb URL Component reference
first_name patchag Retool version 2.103.2 0
Trancfarmar Enshla last_name varchar Numher inniite
(9 Latest No queries running ® 92 0
|Admin Panel
- i B 0 - 100% m P Preview
= Manage users Edit
Header Inspect  Create
Components Modules
Q Search components
Main
Commonly used
First Name Last Name Email B Active Delete Add New User
[ 2= @ o
Ben Bitdiddle ben@tryretool.com v B
- =
Email &4 ben@tryretool.com Table Text Button Text Input
Eva Lu Ator evaluator@tryret... B First name * Ben —
# —1 5
-
Robert) DROP TABLE Use...  droptable@xkcd.... B Last name * Bitdiddle Number Input  Select Container Form
Active * —
Louis Reasoner louis@competitor... B Il D
[ ] 1
- Tabbed Modal Chart Key Value
Alyssa P. Hacker tenx@tryretool.co... g Container
Showing 1-5 of 13 1]of3 » s+ YT C @ .
Image Navigation
All queries completed. Text inputs
-
Code aQa = + [J General Response Advanced deleteUser » Run o .2 0
T & T & < —1I I
W} getUsers 0.8s _
W updateUser Resource m onboarding_db Edit Q Search tables or columns Editable Text Edite;:ileeaText Email JSON Editor
}? deleteUser ol
GUI mode Run query only when manually triggered Related tables c Pl = z T—1
I I
> users
Password Rich Text Text Area Text Input
Table All tables Editor
> ar_internal_metadata
users )
> credits @ —1
Action type > deals
> dog_walkers URL
Delete a record > images
itame Niimher inniite
(9 Latest No queries running % 92 0


Build a simple app using sample data

screenElements: Icon Thumbnail

screenElements: Dialog Button

screenElements:
Popover
Progress Indicator
Button

screenElements:
Dialog
Animation & Video

screenElements:
Progress Indicator
Button
Popover
Progress Indicator
Button
Dialog
Animation & Video
Icon
Thumbnail
Dialog
Button
Loading Indicator

screenPatterns:
Guided Tour & Tutorial
Acknowledgement & Success
Misc
Guided Tour & Tutorial
Loading
Loading

pageType: Application Application Application Application Application Application Application Application Application Application

screenKeywords:
20f9 b ]
Access your data
The query editor allows you to interact with your
resources using gueries &7 . Queries are reusable
functions which let you read and write data from
your resources.
Let’s write a SQL query to fetch some data from the
CSV we uploaded for you.
Show me
-
Code aQa = + [J General Response Advanced getData » Run o .
i} getData 0.4s | oo —_—
Resource ! onboarding_db Edit Q Search tables or columns
SQL mode Run query automatically when inputs change All tables (e
~ ar_internal_metadata
key # varchar
1 select * from users; created_at timestamp
updated_at timestamp
value varchar
> credits
> deals
Trancfarmar Enahla Ann wiallbave
|20f9 b ]
Access your data
The query editor allows you to interact with your
resources using gueries &7 . Queries are reusable
functions which let you read and write data from
your resources.
Let’s write a SQL query to fetch some data from the
CSV we uploaded for you.
Next
-
Code aQa = + [J General Response Advanced getData » Run o .
i} getData 0.95s | - I
Resource ! onboarding_db Edit Q Search tables or columns
SQL mode Run query automatically when inputs change Related tables c
> popular_foods
All tables
1 select .
2 from popular_foods ~ ar_internal_metadata
3 order by _id asc key # varchar
created_at timestamp
updated_at timestamp
value varchar
Trancfarmar Enahla
|.
We already uploaded your CSV data to a
PostgreSQL database we created just for you. Let's
open the bottom panel to access it.
|= Simple app using sample data - 11-29-2022 19:02... o
- ple app 9 P . B 0O - 100% m P Preview
= Edit
Header Inspect Create
Learn more v Community What's new &J Welcome, John container1
I Deprecated component. Upgrade
Main
BASIC
Search by food_name Q Title
i: container1
o O
. S Update Row
_id food_name scientific_name group sub_group UPDATE ROW
Disable this container
0 Angelica Angelica keiskei Herbs and Spices Herbs
food_name Angelica
1 Savoy cabbage Brassica olerace: - Vegetables Cabbages () Show loading state
Jelica keiskei
2 Silver linden Tilia argentea Herbs and Sp LAYOUT
bs and Spices
Height
3 Kiwi Actinidia chinensis Fruits
Fixed
4 Allium (Onion) Allium Vegetables Overflow
Showing 1-5 of 139 1 |of 28 »
Hidden
O O
All queries completed.
Maintain space when hidden
Ece [ General Response Advanced onUpdateRow PRun O .*
Always show in edit mode
i} getData —
) onUpdateRow Resource =~ ! onboarding_db Edit Searchitablesigricallimns STYLE
GUI mode Run query only when manually triggered Related tables Show border
popular_foods @) show drop shadow
All tables
Table Styles
ar_internal_metadata
popular_foods
key # varchar Header background . #2A3766 100%
i created_at timestamp
CtCnlVES . Header foreground #F5F5F5 100%
updated_at timestamp
Update an existing record f h
value varchar Background Default
Latest No queries running
|Let's add a Table component to the canvas.
|-_ Retool O Apps & Resources @ Query Library i Learn &5 Workflows BETA Upgrade e
Create an app
Build a simple app using a CSV < Build a simple app using sample data
Best way to start learning how to build in Retool g Don't have a CSV at hand? Use our sample data
Start from scratch < Learn with an example app
If you already know what you want to build g Deconstruct a pre-built app to see how Retool works
Video tutorials
- °__ = °__.___
Build your first app 13:34 Build a CRUD app from a Google Sheet 14:38
= == e [EEe—— e
= : = £ = | = e — s == [
= = = TEEE —— e [ —
= = i T o - s
= = — o i JR—
- e == »..;_ ; | o m—r——
= - - .= T e e—— —
Build a GUI for your SQL database 10:53 How Coursera uses Retool 6:55
Tips and tricks 2 3 >
|Simple app using sample data - 11-29-2022 19:02...
- ple app 9 P . B 0O - 100% m P Preview
= Edit
Header Inspect  Create
. \ Components Modules
Learn more v Community What's new {J Welcome, John P
Search components
Main
Commonly used
0 = @ =
Table Text Button Text Input
I —
-
Number Input Select Container Form
- BNES
Tabbed Modal Chart Key Value
Container
(a) G
Image Navigation
All queries completed.
Code Text inputs
[J General Response Advanced query1 m » Run 0o .~
W query1 —_— I
I
Resource =~ ¥ onboarding_db Edit Searchitablesigricallimns
Editable Text Editable Text Email JSON Editor
Area
SQL mode Run query automatically when inputs change Related tables
BIu”
users I 1 I I
email # varchar
1 select from users limit id # bigint Password Rié:g_;l'ext Text Area Text Input
itor
active boolean
created_at timestamp I
feature_flags jsonb
first_name varchar URL
Trancfarmar Enahla last_name varchar
Latest No queries running
0
|-_ Retool O Apps & Resources M Query Library i Learn &5 Workflows BETA Upgrade e
Create an app
Build a simple app using a CSV Build a simple app using sample data
Best way to start learning how to build in Retool k Don't have a CSV at hand? Use our sample data
Start from scratch < Learn with an example app
If you already know what you want to build g Deconstruct a pre-built app to see how Retool works
Video tutorials
- °__ = °__.___
Build your first app 13:34 Build a CRUD app from a Google Sheet 14:38
= == e —— ——
= : = £ = | = e — s == [ ae—
= = = TEEE —— e [ —
== = = — - —== - -
=2 — . = e ——
4 - :’ii — = "1"—‘ _‘ e S .
= W  - .= —— ey a——— m—
Build a GUI for your SQL database 10:53 How Coursera uses Retool 6:55
Tips and tricks 2 3 >
|40f9 I
Data, meet Table.
You canuse {{}} to reference components and
queries, or even write custom Javascript. Retool
interprets everything between {{}} asa
Javascript expression. Data {{getData.data}}

_id food_name scientific_name group sub_group Here we use [ 0 [t biet ot to populate our

table component with the results from our
0 Angelica Angelica keiskei Herbs and Spices Herbs
1 Savoy cabbage Brassica oleracei -~ Vegetables Cabbages
4 9 9 9 Back Got it!

2 Silver linden Tilia argentea Herbs and Spices Herbs

3 Kiwi Actinidia chinensis Fruits Tropical fruits

4 Allium (Onion) Allium Vegetables Onion-family veg -

Showing 1-5 of 139 1|of28 » 3 Y C
|20f9 b ]
Access your data
The query editor allows you to interact with your
resources using gueries &7 . Queries are reusable
functions which let you read and write data from
your resources.
Let’s write a SQL query to fetch some data from the
CSV we uploaded for you.
Building...
-
Code aQa = + [J General Response Advanced getData » Save & Run o .
i} getData o 0.4s | +e I
Resource ! onboarding_db Edit Q Search tables or columns
SQL mode Run query automatically when inputs change All tables (e
~ ar_internal_metadata
key # varchar
1 select created_at timestamp
2 from popula updated_at timestamp
value varchar
> credits
> deals
Trancfarmar Enahla Ann wiallbave