Sorting field (shortcut)

screenKeywords:
-—_ Resources / Retool Database Feedback? e
= transactions - +
Add row Import CSV v @ Fields Y/ Filters { Sort Q Quick find & Refresh 51 records
O # id PRIMARY KEY v | A source v A account_num.. v A company v (® transaction_date v A payment_.. v A plan v |+
1 1 ¢ Settings account_63 MetLife Jan 13,2023 12:02:00 AM Credit Pro
2 2 ! Rename field account_267 FedEx Jan 15,2023 5:00:00 PM Invoice Basic
3 3 I¢ Insert field left account_458 Cisco Systems Jan 08, 2023 8:02:00 PM Invoice Pro
-1 Insert field right
4 4 account_991 Dropbox Jan 30, 2023 8:23:00 AM Credit Basic
21 Sort Ascending
5 5 account_241 General Electric Jan 21,2023 12:16:00 AM Invoice Enterprise
15 Sort Descending
6 6 account_682 Gon Jan 02, 2023 4:02:00 PM Debit Basic
Y Filter by this field unt- 9 y ! !
7 7 () Pin this field account_175 Stripe Jan 06, 2023 5:01:00 AM Invoice Pro
8 8 © Hide field account_676 Home Depot Jan 05, 2023 8:25:00 AM Credit Pro
9 9 1y Delete field account_615 Goldman Sachs Group Jan 07,2023 2:07:00 AM Credit Pro
10 10 NULL account_69 Procter & Gamble Jan 21,2023 12:58:00 AM Invoice Enterprise
11 11 NULL account_945 Progressive Jan 18,2023 7:26:00 AM Invoice Basic
12 12 NULL account_232 Citigroup Jan 04, 2023 8:00:00 PM Invoice Basic
13 13 NULL account_227 Stripe Jan 17,2023 12:29:00 PM Invoice Basic
14 14 NULL account_586 Oracle Jan 17,2023 10:52:00 PM Debit Pro
15 15 NULL account_789 JP Morgan Chase Jan 01, 2023 1:31:00 PM Credit Enterprise
16 16 NULL account_495 Gamestop Jan 11,2023 4:40:00 AM Invoice Basic
17 17 NULL account_120 Kroger Jan 04, 2023 6:55:00 AM Invoice Basic
18 18 NULL account_405 Nationwide Jan 17,2023 6:42:00 AM Credit Basic
19 19 NULL account_305 UnitedHealth Group Jan 07,2023 1:10:00 AM Invoice Basic
20 20 NULL account_20 Costco Wholesale Jan 17,2023 5:17:00 PM Debit Enterprise
21 21 NULL account_669 CVS Health Jan 13,2023 3:58:00 PM Credit Pro
|-—_ Resources / Retool Database Feedback? e
= transactions - +
Add row Import CSV v @ Fields Y/ Filters { Sort Q Quick find & Refresh 51 records
O # id PRIMARY KEY v | A source v A account_num.. v A company v (® transaction_date v A payment_.. v A plan v |+
1 1 NULL account_63 MetLife Jan 13,2023 12:02:00 AM Credit Pro
2 2 NULL account_267 FedEx Jan 15,2023 5:00:00 PM Invoice Basic
3 3 NULL account_458 Cisco Systems Jan 08, 2023 8:02:00 PM Invoice Pro
4 4 NULL account_991 Dropbox Jan 30, 2023 8:23:00 AM Credit Basic
5 5 NULL account_241 General Electric Jan 21,2023 12:16:00 AM Invoice Enterprise
6 6 NULL account_682 Gong Jan 02,2023 4:02:00 PM Debit Basic
7 7 NULL account_175 Stripe Jan 06, 2023 5:01:00 AM Invoice Pro
8 8 NULL account_676 Home Depot Jan 05, 2023 8:25:00 AM Credit Pro
9 9 NULL account_615 Goldman Sachs Group Jan 07,2023 2:07:00 AM Credit Pro
10 10 NULL account_69 Procter & Gamble Jan 21,2023 12:58:00 AM Invoice Enterprise
11 11 NULL account_945 Progressive Jan 18,2023 7:26:00 AM Invoice Basic
12 12 NULL account_232 Citigroup Jan 04, 2023 8:00:00 PM Invoice Basic
13 13 NULL account_227 Stripe Jan 17,2023 12:29:00 PM Invoice Basic
14 14 NULL account_586 Oracle Jan 17,2023 10:52:00 PM Debit Pro
15 15 NULL account_789 JP Morgan Chase Jan 01, 2023 1:31:00 PM Credit Enterprise
16 16 NULL account_495 Gamestop Jan 11,2023 4:40:00 AM Invoice Basic
17 17 NULL account_120 Kroger Jan 04, 2023 6:55:00 AM Invoice Basic
18 18 NULL account_405 Nationwide Jan 17,2023 6:42:00 AM Credit Basic
19 19 NULL account_305 UnitedHealth Group Jan 07,2023 1:10:00 AM Invoice Basic
20 20 NULL account_20 Costco Wholesale Jan 17,2023 5:17:00 PM Debit Enterprise
21 21 NULL account_669 CVS Health Jan 13,2023 3:58:00 PM Credit Pro
|-—_ Resources / Retool Database Feedback? e
= transactions - +
Add row Import CSV v @ Fields Y/ Filters { Sort 1 Q_ Quick find & Refresh 51 records
O # id PRIMARY KEY v~ = A account_num.. v A company v (® transaction_date v A payment_.. v A plan v |+
1 51 account_jsmobbin1 JMobbin Nov 01, 2023 5:00:00 PM NULL NULL
2 50 account_713 Salesforce Jan 11,2023 4:36:00 AM Credit Enterprise
3 49 account_885 Oracle Jan 04, 2023 4:46:00 AM Credit Basic
4 48 account_280 Walt Disney Jan 05, 2023 8:06:00 PM Invoice Pro
5 47 account_453 Costco Wholesale Jan 01,2023 7:12:00 PM Debit Enterprise
6 46 account_248 Front Jan 26,2023 12:27:00 AM Invoice Pro
7 45 account_778 Comcast Jan 02, 2023 8:35:00 AM Credit Basic
8 44 account_961 Nike Jan 08, 2023 5:50:00 PM Invoice Basic
9 43 account_766 Brex Jan 23,2023 12:29:00 PM Debit Pro
10 42 account_984 Bumble Jan 24,2023 9:10:00 AM Invoice Enterprise
11 41 account_805 CVS Health Jan 13,2023 5:26:00 AM Invoice Pro
12 40 account_137 Berkshire Hathaway Jan 01, 2023 5:57:00 PM Debit Basic
13 39 account_781 Nike Jan 03,2023 10:47:00 PM Invoice Pro
14 38 account_849 Procter & Gamble Jan 15,2023 9:42:00 AM Credit Enterprise
15 37 account_740 General Motors Jan 31,2023 2:58:00 AM Invoice Basic
16 36 account_418 Goldman Sachs Group Jan 26, 2023 5:22:00 AM Invoice Pro
17 35 account_565 FedEx Jan 17,2023 10:02:00 AM Debit Pro
18 34 account_748 Gamestop Jan 05, 2023 10:41:00 AM Debit Pro
19 33 account_998 Comcast Jan 20, 2023 7:55:00 AM Credit Pro
20 32 account_733 Target Jan 13,2023 12:35:00 PM Debit Pro
21 31 account_631 UPS Jan 06, 2023 7:42:00 AM Debit Pro


Adding a select component

appName: Retool

appCategory: Developer Tools

appTagline: The best way to develop effective software

companyHqRegion: US & Canada

companyStage: Growth Stage

platform: web

pageType: Application

hotspotType: Drag

hotspotType: Click

pageType: Application Application Application Application

screenKeywords:
= O JMobbin Admin QB m
@ Components Modules 57 <«
select1 Q e X »
. .
Q search compnents JMobbin Admin
I'_"Y Content
Commonly used
4 Mode Manual Mapped
New i ID Name Email Blocked
{i} D m Options B2 +
! 1  Hershel McV... etexton2d@... v
Table Text Button Option 1
) 2 Gayel Coton ekeitley3v@... v
— Option 2
T—I) |[#—TI — 3 Imogene Sch... ckiddey64@... v
@ Option 3
Text Input Nlumber Select 4 Anita Oliver tmordy6l@m... v
nput Default value
5 Costa Spata kesposilc@... v
o Placeholder Select an option
- 6 Catharina M...  uqueree69@... v
Container Form Tabbed Add-ons +
Container 7 Booth Macg... sloache34@...
Label Label
Il D 50 results Yy &L O
[ ] 1
Interaction =
Modal Chart Key Value
Unblock user ~ Loading false
Disabled false
Image  Navigation | Label Select an option v | Event handlers +
Text inputs Trigger qu'eries, control components, or call
other APIs in response to component events.
T— ¢ |T S S —1 Form data key {{ self.id }}
Editable Text Editable Text Email Validation rules +
Area
None
BIu”
{3 : Pl I
Appearance =
JSON Editor  Password Rich Text
Editor Show clear button
g i fal
| IE=D R=T Hidden alse
<> — 100% Qhulae ~ L
Text Area Text Input URL
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
select1 Q e X »
. .
Q search compnents JMobbin Admin
I'_"Y Content
Commonly used
4 Mode Manual Mapped
New i ID Name Email Blocked
{i} D m Options B2 +
! 1  Hershel McV... etexton2d@... v
Table Text Button Option 1
) 2 Gayel Coton ekeitley3v@... v
— Option 2
T—I) |[#—TI — 3 Imogene Sch... ckiddey64@... v
@ Option 3
Text Input Nlumber Select 4 Anita Oliver tmordy6l@m... v
nput Default value
5 Costa Spata kesposilc@... v
o Placeholder Select an option
- 6 Catharina M...  uqueree69@... v
Container Form Tabbed Add-ons +
Container 7 Booth Macg... sloache34@...
Label Label
Il D 50 results Yy &L O
[ ] 1
Interaction =
Modal Chart Key Value
Unblock user ~ Loading false
Disabled false
Text inputs Option 1 Trigger qu'eries, control components, or call
P other APIs in response to component events.
Option 2
T— ¢ |T S S —1 P Form data key {{ self.id }}
Option 3
Editable Text Editable Text Email Validation rules +
Area
None
BIu”
{3 : Pl I
Appearance =
JSON Editor  Password Rich Text
Editor Show clear button
g i fal
| IE=D R=T Hidden alse
<> — 100% Qhulae ~ L
Text Area Text Input URL
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
Components Modules 57 <«
@ Inspector (8U) <«
. .
ry (O ssarncomponans JMobbin Admin
'-
Commonly used
[ J
<I;
L"ﬂj! i ID Name Email Blocked
{i} 1 Hershel McV... etexton2d@... v
Table Text Button
) 2 Gayel Coton ekeitley3v@... v
& T—I) |[#—TI — 3 Imogene Sch... ckiddey64@... v
Text Input Nlumbter Select 4 Anita Oliver tmordy6l@m... v
npu
5 Costa Spata kesposilc@... v
A B
- 6 Catharina M...  uqueree69@... v
Container Form Tabbed
Container 7 Booth Macg... sloache34@...
Il D 50 results Y &L O
[ ] 1
Modal Chart Key Value
Unblock user v
Image Navigation
Text inputs
T $£ T & < —1I
Editable Text Editable Text Email
Area
BIu”
{3 : XT3 I
JSON Editor  Password Rich Text
Editor
| IE=D R=T
<> — 100%
Text Area Text Input URL
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
@ Component Tree P«
e %
I . . . ~) select1 Q S
I JMobbin Admin
Header Content
<l,. Sidebar Mode Manual Mapped
ID Name Email Blocked
© 11 Main Options oo+
! 1  Hershel McV... etexton2d@... v
R Option 1
) 2 Gayel Coton ekeitley3v@... v
Option 2
@ 3 Imogene Sch... ckiddey64@... v
Option 3
Main Components + 4 Anita Oliver tmordy6l@m... v
Default value
T text1 5 Costa Spata kesposilc@...
Placeholder Select an option
@ table? 6 Catharina M...  uqueree69@... v
Cy splitButton1 Add-ons +
7 Booth Macg... sloache34@...
select1 Label Label
50 results Y & O
Interaction =
Unblock user ~ Loading false
Disabled false
l Label Select an option v l Event handlers +
Trigger queries, control components, or call
other APIs in response to component events.
Form data key {{ self.id }}
Validation rules +
None
Appearance =
Show clear button
Hidden false
<> — 100% Qtulae ~ L
© Latest No queries running & wDebug O @


Deploying a workflow

screenElements:
Radio Button
Popover

pageType: Application Application Application

screenKeywords:
-—_ Jane Smith - Al Onboarding - Nov 8, 2023 6:00 PM Latest version deployed ~ (®) Run
8
/. No enabled triggers X
This workflow has been deployed with no enabled triggers.
View triggers
This workflow fetches the current weather and '+ Retool Al Actions '
uses Al to suggest an activity.
Press the P> play button to fetch the weather in San Francisco. Use Retool Al to sugg
€3 Scroll to your right to see the set up Reference the results of the previous block by Reference the previot
P> Press play button in each block sequentially This fetches the data from the Open-Meteo API. using fetchWeather directly in code. a
¢ startTrigger = - @ - fetchWeather = - @ » - | getWeather = - @ » O ¢ generateActivities
Enabled triggers RESTQuery (restapi) | JavaScript | Retool Al
GET https://api.open- | 1 const weatherData = fetchWeather.data | Action
g |
meteo.com/vl/forecast? | |
Edit triggers latitude=37.616&Longitude=-122.3833&cu 3 return weatherData.current_weather Generate text
rrent_weather=true&temperature_unit=fa | | Examples: Product desci
Test JSON Parameters hrenheit
. | Inputs Data JSON Settings Q nput
+ More options 1 What's a good
Explain your r
Inputs Data JSON Settings [v] 2
3 Weather:
4 {{getWeather.c
Use Retool Vector:
Model
& opt-4
Inputs
ﬁ@ — 100% 3 % ¢ X B3 1ul
@ production Run history
|-—_ Jane Smith - Al Onboarding - Nov 8, 2023 6:00 PM Undeployed changes  (® Run Deploy v
og Deploy workflow X
Version 0.0.2 Major Minor @ Patch
Description
Add a short description of changes (optional)
Deploy
This workflow fetches the current weather and '+ Retool Al Actions '
uses Al to suggest an activity.

Press the P> play button to fetch the weather in San Francisco. Use Retool Al to sugg
€3 Scroll to your right to see the set up Reference the results of the previous block by Reference the previot
P> Press play button in each block sequentially This fetches the data from the Open-Meteo API. using fetchWeather directly in code. a
¢ startTrigger = - @ - fetchWeather = - @ » - getWeather = - @ » - O ¢ generateActivities

Enabled triggers RESTQuery (restapi) JavaScript Retool Al
GET https://api.open- 1 const weatherData = fetchWeather.data Action
2
meteo.com/vl/forecast?
Edit triggers latitude=37.616&Longitude=-122.3833&cu 3 return weatherData.current_weather Generate text
rrent_weather=true&temperature_unit=fa Examples: Product desci
Test JSON Parameters hrenheit
. Inputs Data JSON Settings [v] nput
+ More options 1 What's a good
Explain your r
Inputs Data JSON Settings [v] 2
3 Weather:
4 {{getWeather.c
Use Retool Vector:
Model
& opt-4
Inputs
ﬁ@ — 100% 3 % ¢ X B3 1ul
@ production Run history
|-_ b Jane Smith - Al Onboarding - Nov 8, 2023 6:00 PM Latest version deployed ~ (®) Run Deploy v
® 8 s
@ This workflow fetches the current weather and '+ Retool Al Actions '
uses Al to suggest an activity.
O Press the P> play button to fetch the weather in San Francisco. Use Retool Al to sugg
&3 Scroll to your right to see the set up Reference the results of the previous block by Reference the previot
P Press play button in each block sequentially This fetches the data from the Open-Meteo API. using fetchWeather directly in code. 5
¢ startTrigger = - @ - {} fetchWeather = - @ » - getWeather = - o » - ¢ generateActivities
Enabled triggers RESTQuery (restapi) JavaScript Retool Al
No triggers enabled GET https://api.open- ; const weatherData = fetchWeather.data Action
meteo.com/vl/forecast?
Edit triggers latitude=37.6168longitude=-122.3833&cu 3 return weatherData.current_weather Cenerate text
rrent_weather=true&temperature_unit=fa Examples: Product desci
Test JSON Parameters hrenheit
. Inputs Settings o Input
{"webhookParaml": value"} + More opt|ons 1 What's a good
Explain your r
Inputs Settings o 2
3 Weather:
4 {{getWeather.c
Use Retool Vector:
Model
& gpt-4
Inputs
®
:@—100%*[] % ¢ X B3 jiul
® production O Run history


Database settings

hotspotType: Hover

screenElements:
Stacked List
Banner

pageType: Application Application Application Application Application

screenKeywords:
-—_ Retool Apps Resources Database Query Library Workflows Q (s«
& Retool Database Test connection
About  Usage
Name Type Last edited
O Title your first app
|== Retool Apps  Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
B Retool Database Test connection
About Usage
Advanced options Allowlist IPs
. . . Default
Disable converting queries to prepared statements

Ensure your database has
allow-listed the following IPs:
35.90.103.132/30 O
44.208.168.68/30 O
Region-specific
Allowlist the following additional
IPs if you are calling resources
from Frankfurt:
3.77.79.248/30 O
|== Retool Apps  Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
) Playground Re...

8 Retool Database PostgreSQL

3  Retool Storage File Storage

B  Retool Email Email

<>  Retool Al Al

< Retool Vectors Beta Al

Name Type Created Usage

[ Playground Resources Folder 23 minutes ago 0

onboarding_api REST API 23 minutes ago 0

! onboarding_db PostgreSQL 23 minutes ago 0
|== Retool Apps  Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
B Retool Database Test connection
About Usage
+  Test connection successful View in console
Allowlist IPs
Ad d oot Default
vanced options Ensure your database has
. . . allow-listed the following IPs:
Disable converting queries to prepared statements
35.90.103.132/30 O
44.208.168.68/30 O
Region-specific
Allowlist the following additional
IPs if you are calling resources
from Frankfurt:
3.77.79.248/30 O
|== Retool Apps  Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
) Playground Re...

EB  Retool Database PostgreSQL Settings
3  Retool Storage File Storage

B  Retool Email Email

<>  Retool Al Al

< Retool Vectors Beta Al

Name Type Created Usage

[ Playground Resources Folder 4 days ago 6

onboarding_api REST API 4 days ago 0

! onboarding_db PostgreSQL 4 days ago 0


Searching Retool

screenElements:
Top Navigation Bar
Logo
Card
Banner
Floating Action Button

screenPatterns:
Home
Feature Info

screenPatterns:
Empty State
Command Palette

hotspotType: Keyboard Input

screenPatterns:
Home
Feature Info
Empty State
Command Palette

screenKeywords:
-—_ RethI Apps Resources Database Query Library Workflows Upgrade Q (s~
Welcome to Retool, Jane! x
o 8 S]
Apps Database Resources
Create a web app or a native mobile app to build a custom Easily store data in a free SQL database and power your Securely connect your data and display it inside of Retool
internal tool for your business. Retool apps. apps.
Create aweb app -
Create a mobile app - Use Retool Database - Connect aresource -
s s o . Get started with Al
. © @ © O¢ Retool Al gives you powerful building blocks - like LLM connectors and a vector database - to create Al- Start building with Al > Learn more X
powered applications and workflows.
/:.:» Introducing Retool Storage
Retool storage is a Retool-hosted file store. Using Retool Storage, you can upload and download files and use Try Retool Storage > Learn more X
N them in your apps and workflows.
Al
All  Recent Starred Modules Folders Trash
Name v Updated Last Editor
(mm] [Sample App] Users Dashboard 23 minutes ago @
o Title your first app 21 minutes ago Jane Smith 0
|Eearch by name, type, or folder name
Recently opened
5 Workflows Page
4+ Settings

Untitled

Retool Playground Email Query
Resources

[demo resource] BigQuery Playground Resources

[demo resource] Firebase Playground Resources

[demo resource] Google Cloud Stor... Playground Resources
) [demo resource] Google Sheets Playground Resources
|Untitled x  [Type a command
No results found.
|add
Top result
[Sample App] Users Dashboard Desktop app
Apps
JMobbin Admin - Backup
JMobbin Admin Panel
Resources
{} onboarding_api
! onboarding_db


Turning on two-factor authentication

screenPatterns:
Home
Feature Info
QR Code

screenKeywords:
& Retool
Scan this QR code
-
E .'.:i_ LR E
k. iﬂﬁ}ﬁf o
S

[m] Kimare =E

Authenticator code
|== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
+ Successfully saved.
Advanced
Account
! Deploy Retool at scale.
Users Upgrade to get
L. version control with Git
Permissions
Environments ' Ul mers
identity management with SAML SSO
IAM Credentials
,and
Billing directory sync via SCIM.
Branding Business
Themes Business Authentication Options
Source Control Enterprise
Require Two Factor Authentication o«
Advanced
Beta This applies to the entire organization, not limited to one domain.
Retool Events
Retool Al
Auto-join domains
Users with emails from these domains can join this organization.
Add domain
Allow anyone to request to join
This adds a link on the login screen to allow any user to request access.
Preloaded JavaScript @
Add preloaded JavaScript to all applications in the organization by assigning them to the window scope. G
|== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
Advanced
Account
! Deploy Retool at scale.
Users Upgrade to get
L. version control with Git
Permissions
Environments ' Ul mers
identity management with SAML SSO
IAM Credentials
,and
Billing directory sync via SCIM.
Branding Business
Themes Business Authentication Options
Source Control Enterprise
Require Two Factor Authentication
Advanced
Beta This applies to the entire organization, not limited to one domain.
Retool Events
Retool Al
Auto-join domains
Users with emails from these domains can join this organization.
Add domain
Allow anyone to request to join
This adds a link on the login screen to allow any user to request access.
Preloaded JavaScript @
Add preloaded JavaScript to all applications in the organization by assigning them to the window scope. G
|-—_ RethI Apps Resources Database Query Library Workflows Upgrade Q (s~
Welcome to Retool, Jane! x
o 8 S]
Apps Database Resources
Create a web app or a native mobile app to build a custom Easily store data in a free SQL database and power your Securely connect your data and display it inside of Retool
internal tool for your business. Retool apps. apps.
Create aweb app -
Create a mobile app - Use Retool Database - Connect aresource -
s s o . Get started with Al
. © @ © O¢ Retool Al gives you powerful building blocks - like LLM connectors and a vector database - to create Al- Start building with Al > Learn more X
powered applications and workflows.
/:.:» Introducing Retool Storage
Retool storage is a Retool-hosted file store. Using Retool Storage, you can upload and download files and use Try Retool Storage > Learn more X
N them in your apps and workflows.
Al
All  Recent Starred Modules Folders Trash
Name v Updated Last Editor
(mm] [Sample App] Users Dashboard 23 minutes ago @
o Title your first app 21 minutes ago Jane Smith 0
|& Retool
Scan this QR code
-
E .'.:i_ LR E
k. ﬁl}ﬁ' o
S

[m] Kimare =E

Authenticator code

222621


Adding a tooltip

screenKeywords:
= B JMobbin Admin Q8 m
@ BlockTable > Comments e P 0»
. .
I_—? JMObbln Admln Content
v
Any additional things to add? Source Optionally choose a key
<D
ID Name Email Blocked Comments D comments
{i}
1 Hershel McV... etexton2d@... Label Comments
2 Gayel Coton ekeitley3v@... v
\9 v itley3v@ Format String
3 Imogene Sch... ckiddey64@... v
@ Value
4 Anita Oliver tmordy6l@m... v
Add-ons +
5 Costa Spata kesposilc@... v . A
Header tooltip ~ Any additional things
. to add?
6 Catharina M...  uqueree69@... v
7 Booth Macg... sloache34@...
Interaction =
50 results Yy &4 5 Event handlers +
Trigger queries, control components, or call
other APIs in response to component events.
Editable
Appearance
Background
Text
Hidden false
Align I e |
Pin column | - 5|
<> — 100%
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ BlockTable > Comments e P 0»
. .
I_—? JMObbln Admln Content
v
. Source Optionally choose a key
<D
ID Name Email Blocked Comments D comments
{i}
1 Hershel McV... etexton2d@... Label Comments
2 Gayel Coton ekeitley3v@... v
\9 v itley3v@ Format String
3 Imogene Sch... ckiddey64@... v
@ Value
4 Anita Oliver tmordy6l@m... v
Add-ons +
5 Costa Spata kesposilc@... v . A
Header tooltip ~ Any additional things
. to add?
6 Catharina M...  uqueree69@... v
7 Booth Macg... sloache34@...
Interaction =
50 results Yy &4 5 Event handlers +
O O Trigger queries, control components, or call
other APIs in response to component events.
Editable
Appearance
Background
Text
Hidden false
Align I e |
Pin column | - 5|
<> — 100%
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q 8 m
@ (77 BlockTable > Comments e P2 »
3 .
Iy JMobbin Admin - Content
v
. Source Optionally choose a key
<>
ID Name Email Blocked Comments D comments
{i}
1 Hershel McV... etexton2d@... Label Comments
2 Gayel Coton ekeitley3v@... v
\9 ay y3ve Format I" String
3 Imogene Sch... ckiddey64@...
@ Value
4 Anita Oliver tmordy6l@m... v
Add-ons +
5 Costa Spata kesposilc@... v None
6 Catharina M... uqueree69@...
- Interaction =
7 Booth Macg... sloache34@...
4 Event handlers +
50 results Y &L O Trigger queries, control components, or call
o S other APIs in response to component events.
Editable
- Appearance
Background
Text
Hidden false
Align I e |
Pin column |l - >
<> — 100%
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ BlockTable > Comments e P 0»
. .
I_—? JMObbln Admln Content
v
. Source Optionally choose a key
<D
ID Name Email Blocked Comments D comments
{i}
1 Hershel McV... etexton2d@... Label Comments
2 Gayel Coton ekeitley3v@... v
\9 v itley3v@ Format String
3 Imogene Sch... ckiddey64@... v
@ Value
4 Anita Oliver tmordy6l@m... v
Add-ons +
5 Costa Spata kesposilc@... v
6 Catharina M...  uqueree69@... v
7 Booth Macg... sloache34@... Interaction =
A R ] - Event handlers +
50 results Y & O ; i
Trigger queries, control components, or call
O O other APIs in response to component events.
Editable
Appearance
Background
Text
Hidden false
Align I e |
Pin column | - 5|
<> — 100%
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ BlockTable > Comments e P 0»
. .
I_—? JMObbln Admln Content
v
. Source Optionally choose a key
<D
ID Name Email Blocked Comments D comments
{i}
1 Hershel McV... etexton2d@... Label Comments
2 Gayel Coton ekeitley3v@... v
\9 v itley3v@ Format String
3 Imogene Sch... ckiddey64@... v
@ Value
4 Anita Oliver tmordy6l@m... v
Add-ons +
5 Costa Spata kesposilc@... v
P P @ Header tooltip
6 Catharina M...  uqueree69@... v Cell tooltip
Interaction
7 Booth Macg... sloache34@... Caption
A M wao: cta—i.a . Event handlers Status indicator
50 results Y &L O Trigger queries, Cunuurcumpunsie; vr van
S S other APIs in response to component events.
Editable
Appearance
Background
Text
Hidden false
Align I e |
Pin column | - 5|
<> — 100%
© Latest No queries running & wDebug O @


Creating an app (AI)

hotspotType: Scroll Vertically

pageType: Application Application Application Application Application Application

screenKeywords:
-—_ B Jane - Al Template App - November 8th 2023, 5:54:37 pm Q B m
@ Components Modules P«
+~ generateText ran successfully (. buttonGenerate Q e X »
I__Y Q_ Search components
v H i H Content
Commonly used Build Al-powered apps with Al Actions, Jane
<> . . . . Text Generate text
New This guide shows you how to use Al Actions to build apps.
3
. Add-ons +
{i}
Table Text Button None
O
o | |E=D |E=t . @ Generate text U Edit or preview the app by 1099 Interaction
Text Input Number Select Type Default Submit
Input
A B Input & Prefill with example Output Event handlers +
- A haiku about Retool Crafting with Retool, Click generateText.trigger()
Container Form Tabbed Streamlining workflows with care,
Container Efficiency's tool. Loading
| [:] {{generateText.isFetching}}
— II Loader position  Auto -
Modal Chart Key Value
O O
Disabled
Generate text
@ A BC S S {{generateText.isFetching}}
Image Navigation N
Appearance 4
Text inputs © Summarize text Algn o e @
T $ T K4 S —I Hidden false
Input ill wi Output ’ I I
Editable Text Editable Text  Email P & Prefill with example P Variant Solid Outline
Area
Enter input to summarize text Styles 2 +
BIu”
{3
1| | &t I Background () #8843AE 100%
JSON Editor ~ Password Rich Text Border / #4B3EBE 0%
Editor
T.
= T —1I ®—1I
y ~ o0
Text Area Text Input URL
© Latest No queries running & fkDebug O @
|-
= 5 Jane - Al Template App - November 8th 2023, 5:54:37 pm Q B m
Components Modules 57 <«
@ Inspector (8U) <«
&
Commonly used Learn how this app works What's next
<D
New
W= o
{i} Understand how Al Actions work with components Create your own app!
] Table Text Button To understand how Al Actions work, click the </> Code tab in the left This is a Retool app built to help you understand what Retool
@ sidebar, and select one of the queries like generateText or extractText . Al Actions can do. Feel free to experiment, hack away, and
I I = customize this app as you see fit, or even build a new one
— |
@ e.g. To learn how the Classify text example above was built, from scratchl
TextInput  Numb Select i i ist i i ?
T e T 1. Click the </> Code tab in the left sidebar How might these Al actions assistin enhancing your apps?
2. Click the classifyText query : i
A B
o The input references the content of the text area component Try other Al examples
-
o The classification label references the content of the select
Container Form Tabbed component Mock data generation 7
Container
o The query is triggered when you click the Classify text
button. The button has a click event configured through Plotly chart generator 7
P |I| event handlers in the panel on the right.
. ian 7
Modal Chart Key Value Learn more about Al Actions 7 Entity extraction
Summarize table rows 7
Image Navigation L-""".-:"-""“-"-""-"-""“-"-"-""-""“-""""""""J
Additional resources
Textinputs Learn how to build a web app from start to finish 7
I Learn how to build automations with Workflows 7
Editable Text Ed":br':;e“ Email Learn how to connect your data sources 7
Bru» IR S R R
JSON Editor  Password Rich Text
Editor
I I I
<> — 100%
Text Area Text Input URL
© Latest No queries running & fDebug O @
|= O Jane - Al Template App - November 8th 2023, 5:54:37 pm Q B m
@ Components Modules 57 <« )
Inspector (3£U) <«
r? Q. Search components
‘. . . .
Commonly used Build Al-powered apps with Al Actions, Jane E
<> i aui ; ; (e V]
! New This guide shows you how to use Al Actions to build apps. A =
l I M (]
{
Table Text Button
O
@ T—I1 # —1 e o Generate text A Edit or preview the app by toggling preview mode E3 in the top right
Text Input Number Select
Input
— Input & Prefill with example Output
= A haiku about Retool Crafting with Retool,
Container Form Tabbed Streamlining workflows with care,
Container Efficiency's tool.
= @t B
Modal Chart Key Value
O O
(@) e - :
Image Navigation
Text inputs o Summarize text
T $ T K4 S —I
Input ill wi Output
Editable Text Editable Text Email p & Prefill with example p
Area
Enter input to summarize text
o BIu”
1 Pl 1
JSON Editor  Password Rich Text
Editor
E | IE=1 k=
N ~ 0%+
Text Area Text Input URL
© Latest No queries running & fkDebug O @
|= O Jane - Al Template App - November 8th 2023, 5:54:37 pm Q B m
@ Components Modules 57 <«
@ link1 Q - X »
r? Q. Search components
g H H H Content
Commonly used Build Al-powered apps with Al Actions, Jane
<> . . . . Text Prefill with example
New This guide shows you how to use Al Actions to build apps.
FEL |G
. Add-ons
{ +
O Table Text Button Prefix icon ¥ Interface Arrows B...
B
T—1 # —1I e o Generate text A Edit or preview the app by togg )
3 Interaction
Text Input Number Select .
Input =i Loading false
— Input i & Prefill with example (] Output Disabled false
-
A haiku about Retool Event handlers +
Container Form Tabbed
Container Click textGenerate.setValue..
P I I | [:] Appearance =
Modal Chart Key Value Allow wrapping
Generate text
@ ABC Text size Default (12px) -
Image Navigation Underline Never v
Textinputs © Summarize text Align e sle 5|
Hidden false
T $ T K4 S —I
- - - Input & Prefill with example Output Styles 2 +
Editable Text Editable Text Email
Area Text @ #8843AE 100%
Enter input to summarize text
o BIu”
1| [ R8I 1
JSON Editor  Password Rich Text
Editor
E | IE=1 k=
N -
Text Area Text Input URL
© Latest No queries running & fkDebug O @
|= O Jane - Al Template App - November 8th 2023, 5:54:37 pm Q B m
@ Components Modules 57 <«
No components X »
r? Q. Search components
‘. . . .
Commonly used Build Al-powered apps with Al Actions, Jane No components selected
<> A A . A
! New This guide shows you how to use Al Actions to build apps.
EH | |
{
Table Text Button
O
@ T—1 # —1I e o Generate text A Edit or preview the app by togg
Text Input Number Select
Input
— Input & Prefill with example Output
-
Enter input to generate text
Container Form Tabbed
Container
= ot B
Modal Chart Key Value
(@) =
Image Navigation
Text inputs o Summarize text
T $ T K4 S —I
Input ill wi Output
Editable Text Editable Text Email p & Prefill with example p
Area
Enter input to summarize text
o BIu”
1| [ R8I 1
JSON Editor  Password Rich Text
Editor
E | IE=1 k=
N ~ 0%+
Text Area Text Input URL
© Latest No queries running & fkDebug O @
|= O Jane - Al Template App - November 8th 2023, 5:54:37 pm Q B m
® Components Modules 57 <« . S
No components X » |
Q [search components 5 ) ) A
e Build Al-powered apps with Al Actions ,
No components selected
Commonly used This guide shows you how to use Al Actions to build apps. i
<> !
New
g —) .
BEY| | fus .
{i} (6 J |
Table Text Button o Generate text 4 Edit or preview the app by toggli |
® -
*—1) | =5 3
@ = Input & Prefill with example Output
Text Input Number Select Enter input to generate text )
Input |
Container Form Tabbed
ISHET AliEE _ .
© Summarize text |
& <+ X |
@ Input & Prefill with example Output ;
< !
Enter input to summarize text N
Get started with Al .
- Learn how to use Al in Retool |
+ Al Actions .
E " Retool Vectors i
Build a Q&A app with your data j
@ Extract entity from text j
Al Workflows .
Automate your Al processes A
"~ Altemplates Input & Prefill with example Output |
See what you can do with Al Enter input to extract entity root: null .
" Learn more |
IS 100% -+ 1
TORTTIrow TORTTTPWT T B :.7. B B B i B B B B B B B B B B B B B B B B B B
© Latest No queries running fDebug O @


Creating a vector

screenKeywords:
Create a Vector X
® How it works
1. Create a Vector to upload your data
2. Preview your embeddings
3. Build a chat app that references Vectors
Vector name
T&C
Vector type
] ®
Document Site URLs
Upload files or plain text Crawl through public URLs
|-—_ RethI Apps Resources Database Query Library Workflows Upgrade Qs ~
<  Vectors
® What is a vector?
A Vector is a way to store unstructured text (e.g. from a website or document) in a format that makes it accessible to L
earn more
LLMs. Retool Vectors can ingest documents, plain text, and web pages. With it, you create chat experiences that know
about your business.
Name Type Last edited

[  [Demo] Vector - Jane Smith

Y  [Demo] Retool Al docs

%  [Demo] Amazon 10-K
|Create a Vector X
® How it works
1. Create a Vector to upload your data
2. Preview your embeddings
3. Build a chat app that references Vectors
Vector name
Vector type
] ®
Document Site URLs
Upload files or plain text Crawl through public URLs
|== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
T&C Add document v
No document found


Minimizing panels

screenKeywords:
= O JMobbin Admin QB m
@ Inspector (82U) <«
e
<2
{i}
O
<> — 100%
© Latest No queries running & fDebug O @
|= O JMobbin Admin QB m
@ Code L« = () getUsers X -+ (=]
Inspector (82U) <«
Showing 1 =
I-_Y owing Q + General Response Advanced ees  Preview
'-
{7} getUsers
<> Resource  {} Playground Resources / Users API
{i} Run query automatically when inputs change
O
Action type
@ GET https://retoolapi.dev/qi0S3  api/v2/endpoint.json
(GET req) Will run automatically whenever a parameter changes.
URL parameters
key value X
Headers
key value X
+ Add new
Body
None
Output M
Response APl Request
v 0
v {
"id": 1,
"name": "Hershel McVittie",
"email": "etexton2d@stanford.edu",
"blocked": false
+
v {
"idt: 2,
"name": "Gayel Coton",
"email": "ekeitley3v@github.com",
"blocked": true
+
<> v { — 100%
"id": 3,
© Latest No queries running & fDebug O @
|= O JMobbin Admin QB m
@ Code Lo«
Inspector (82U) <«
I:? Showing 1 Q = +
v
{7} getUsers 0.8s
<2
{i}
O
<> — 100%
© Latest No queries running & fDebug O @


Importing a query

pageType: Application Application Application Application Application Application Application

screenKeywords:
= O JMobbin Admin QB m
@ Code L« = () getUsers X -+ (=]
Inspector (82U) <«
I-_Y Showing 1 Q= + General Response Advanced ees  Preview
'-
{7} getUsers
<> Resource  {} Playground Resources / Users API v
{i} Run query automatically when inputs change v
O
Action type
@ GET v https://retoolapi.dev/qi0S3  api/v2/endpoint. json
(GET req) Will run automatically whenever a parameter changes.
URL parameters
key value X
Headers
key value X
+ Add new
Body
None v
Cookies
key value X
+ Add new
Transform results Enable
Enable transformers to transform the result of the query to a different format.
Event Handlers
Success +
Trigger queries, control components, or call other APIs in response to query
success. These are not run when the query is previewed.
— 100%
<> Output A
© Latest No queries running & fkDebug O @
|= O JMobbin Admin QB m
@ Code Lo« = getUsers o i&m query2 ¢ -+ () No components L »
Showing 2 Q = + ;
I-_V'Y General Response Advanced Preview m No components selected
{7 getUsers 0.4s
<> = query2e Resource &= Import from Query Library v
{i} Run query only when manually triggered v
O
Select query
@ Choose a query -~
& Retool Playground Email Query
Enable transformers to transform the result of the query to a different format.
Event Handlers
Success +
Trigger queries, control components, or call other APIs in response to query
success. These are not run when the query is previewed.
Failure +
Trigger queries, control components, or call other APIs in response to query
failure. These are not run when the query is previewed.
— 100%
<> Output A
© Latest No queries running & M Debug O @
|= O JMobbin Admin Q 5 m
@ Code L« = getUsers &= query2 o = No components L o»
Showing 2 =
I—j owing Q + General Response Advanced Preview m No components selected
getUsers o .
/ Something went wrong.
<> = 2
= duenyes Error ID: 0682c09980124a5ca6747f4b41a5f9f3
{3 Our team has been notified. We're working to fix this ASAP. Monitor
our service health page at status.retool.com.
Q) TypeError: Cannot read properties of undefined (reading
'toString')
3 at fa (https://retool-
edge.com/37308.7f1ac4513b691e3554F9.js:1:123691)
at ja (https://retool-
edge.com/app.7flac4513b691e3554F9.js:2:3355505)
at ec (https://retool-
edge.com/app.7flac4513b691e3554F9.js:2:3418954)
at Kc (https://retool-
edge.com/app.7flac4513b691e3554F9.js:2:3405874)
at Hc (https://retool-
edge.com/app.7flac4a513b691e3554F9.js:2:3405696)
at Zc (https://retool-
edge.com/app.7flac4513b691e3554F9.js:2:3405554)
at $c (https://retool-
edge.com/app.7flac4513b691e3554F9.js:2:3401984)
at Fc (https://retool-
edge.com/app.7flac4513b691e3554F9.js:2:3400541)
at E (https://retool-
edge.com/app.7flac4a513b691e3554F9.js:2:3660085)
at MessagePort.I (https://retool-
edge.com/app.7flac4513b691e3554F9.js:2:3660617)
Try refreshing the page
— 100%
<> Output A
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
@ Code Lo« = {getUsers o - ® No components L »
Showing 1 Q= + .
I-_V'Y General Response Advanced eee  Preview No components selected
{7+ getUsers o 0. Data
<> Resource query yund Resources / Users API
. (3 Import query from library
{i} ly when inputs change
Al Action New
O
JavaScript
0 Query . .
https://retoolapi.dev/qi0S3  ?
[ Transformer
atically whenever a parameter changes.
Variable
Utilities lue X
Import Workflow ~ New
2 Analytics tracking
lue X
| Folder
Body
None
Cookies
key value X
+ Add new
Transform results Enable
Enable transformers to transform the result of the query to a different format.
Event Handlers
Success +
Trigger queries, control components, or call other APIs in response to query
success. These are not run when the query is previewed.
— 100%
<> Output A
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ Code L« = getUsers &= query2 X = No components L o»
Showing 2 Q = + i
I—j General Response Advanced Preview Run ¢ No components selected
getUsers o
<> &= query2 Resource == Import from Query Library
0 . . Query is automatically executed when the page first loads or
! Run query automatically when inputs change A i
when a variable it depends on updates.
\9 Run query automatically when inputs change
@ Run query only when manually triggered
R )
Transform results Enable
Enable transformers to transform the result of the query to a different format.
Event Handlers
Success +
Trigger queries, control components, or call other APIs in response to query
success. These are not run when the query is previewed.
Failure +
Trigger queries, control components, or call other APIs in response to query
failure. These are not run when the query is previewed.
— 100%
<> Output A
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
@ Code L« = getUsers o &m X + ® No components L »
Showing 2 Q = + )
I-_V'Y General Response Advanced Preview No components selected
{7 getUsers 0.4s
<> &= query2 Resource &= Import from Query Library v
{i} Run query automatically when inputs change v
O
Select query
@ Choose a query v
Transform results Enable
Enable transformers to transform the result of the query to a different format.
Event Handlers
Success +
Trigger queries, control components, or call other APIs in response to query
success. These are not run when the query is previewed.
Failure +
Trigger queries, control components, or call other APIs in response to query
failure. These are not run when the query is previewed.
— 100%
<> Output A
© Latest No queries running & M Debug O @
|= O JMobbin Admin QB m
@ Code P« = getUsers « @m query2 o -+ (=) No components L o»
Showing 2 Q = + ;
I-_V'Y General Response Advanced Preview m No components selected
{7 getUsers 0.4s
<> = query2e Resource &= Import from Query Library v
{i} Run query only when manually triggered v
O
Select query
@ Choose a query v
Transform results Enable
Enable transformers to transform the result of the query to a different format.
Event Handlers
Success +
Trigger queries, control components, or call other APIs in response to query
success. These are not run when the query is previewed.
Failure +
Trigger queries, control components, or call other APIs in response to query
failure. These are not run when the query is previewed.
— 100%
<> Output A
© Latest No queries running & M Debug O @


Reordering table columns

screenKeywords:
= B JMobbin Admin Q8 m
@ table1 Q e 2 »
. .
I_—? JMObbln Admln Content =
v
° Data source getUsers
<D
ID  Email Blocked Name Primary key D
{i} 1 etexton2d@... Hershel McVittie
@ Columns e 8 O 4
) 2 ekeitley3v@.. v Gayel Coton D
@ 3 ckiddey64@... v Imogene Schirak ~ Email
4 tmordy6l@m... Anita Oliver Blocked
5 kesposilc@... v Costa Spata ¥ Name
6 uqueree69@... Catharina McQuarter Actions +
7 sloache34@... Booth Macquire No actions
~ R P ) - [ I N I Add_ons +
50 results Y & O
O o Toolbar Filter, Download, ..
Save actions patchUser.trigger()
Interaction =
Event handlers +
Select row getUsers.trigger()
Default filters 2 +
No filters
Default operator And Or
Row selection Single Multiple  None
Default row Index Key None
Default index 0
<> — 100% Index type Display Data
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ table1 Q e 2 »
. .
Iy JMobbin Admin Content =
° Data source getUsers
<D
ID Name Email Blocked Primary key D
{i} 1 Hershel McV... etexton2d@...
@ Columns e 8 O 4
) 2 Gayel Coton ekeitley3v@... v D
@ 3 Imogene Sch... ckiddey64@... v ~ Name e X
4 Anita Oliver tmordy6l@m... v N Email
5 Costa Spata kesposilc@... v Blocked
6 Catharina M...  uqueree69@... v Actions +
7 Booth Macq.. sloache34@... No actions
~ [ T N R P ) - Add_ons +
50 results Y &L O
O o Toolbar Filter, Download, ..
Save actions patchUser.trigger()
Interaction =
Event handlers +
Select row getUsers.trigger()
Default filters 2 +
No filters
Default operator And Or
Row selection Single Multiple None
Default row Index Key None
Default index 0
<> — 100% Index type Display Data
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q 8 m
@ 7 table1 Q - 2 »
I_—;? JMObbin Admin - Content =
: Data source 7 getUsers
o ID Name Email Blocked Primary key 1D
{i} 1 Hershel McV... etexton2d@... Columns R N
) 2 Gayel Coton ekeitley3v@... v #1p
@ 3 Imogene Sch... ckiddey64@... o
4 Anita Oliver tmordy6l@m... v 7™ Email
5 Costa Spata kesposilc@... v () Blocked
6 Catharina M... uqueree69@... Actions +
7 Booth Macq...  sloache34@... No actions
n [T - P - Add-ons +
50 results Y &L O
4 S Toolbar Filter, Download, ..
Save actions patchUser.trigger()
- Interaction =
Event handlers +
Select row getUsers.trigger()
Default filters 2 +
No filters
Default operator And Or
Row selection Single Multiple None
Default row Index Key None
Default index 0
<> — 100% Index type Display Data
© Latest No queries running & wDebug O @


Switching view

pageType: Application Application

screenKeywords:
-_ Jane Smith - Al Onboarding - Nov 8, 2023 6:00 PM Undeployed changes  (®) Run Deploy v
4% startTrigger @]
fetchWeather @
getWeather (R
<> generateActivities ) -
& sendEmail [
5? — 100% HH % ¢ X =2
@ production Run history
|-_ b Jane Smith - Al Onboarding - Nov 8, 2023 6:00 PM Latest version deployed ~ (®) Run Deploy v
® 8 s
@ This workflow fetches the current weather and '+ Retool Al Actions '
uses Al to suggest an activity.
O Press the P> play button to fetch the weather in San Francisco. Use Retool Al to sugg
&3 Scroll to your right to see the set up Reference the results of the previous block by Reference the previot
P Press play button in each block sequentially This fetches the data from the Open-Meteo API. using fetchWeather directly in code. 5
¢ startTrigger = - @ - {} fetchWeather = - @ » - getWeather = - o » - ¢ generateActivities
Enabled triggers RESTQuery (restapi) JavaScript Retool Al
No triggers enabled GET https://api.open- ; const weatherData = fetchWeather.data Action
meteo.com/vl/forecast?
Edit triggers latitude=37.6168longitude=-122.3833&cu 3 return weatherData.current_weather Cenerate text
rrent_weather=true&temperature_unit=fa Examples: Product desci
Test JSON Parameters hrenheit
. Inputs Settings o Input
{"webhookParaml": value"} + More opt|ons 1 What's a good
Explain your r
Inputs Settings o 2
3 Weather:
4 {{getWeather.c
Use Retool Vector:
Model
& gpt-4
Inputs
®
:@—100%*[] % ¢ X B3 jiul
® production O Run history


Sidebar

screenPatterns:
Settings & Preferences
Subscription & Paywall
Timeline & History

screenKeywords:
= O JMobbin Admin QB m
App settings X
@ PP g Inspector (8U) <«
I-_V'Y General Select atheme Business
° Custom CSS Upgrade to business plan to use theme
<I;
Preloaded JS Set canvas max width
{i} . . Set the maximum page width for this app
Libraries i
(accepts pixel values, percentages, or 100%
) Page Settings none ). An 800px minimum width is
enforced on desktops.
@ Custom shortcuts
Configure Markdown link behavior
Links outside your Retool organization
open in a new tab by default. You can Automatic
override this behavior to open all links in
either a new tab or the current tab.
Show query status to viewers
Query run status is always available to editors in the status bar.
Enable mobile layout
Hide or show components when viewport is less than 600px. Learn more.
Show loading state
Display a loading indicator while the data is being loaded.
Enable custom title g, ciness
Customize the text that is displayed in a browser's title bar and a page's tab.
<> — 100%
© Latest No queries running & fDebug O @
|= O JMobbin Admin QB m
@ Inspector (82U) <«
e
<2
{i}
O
<> — 100%
© Latest No queries running & fDebug O @
|= O JMobbin Admin Q B m
State Lo«

@ Inspector (8U) <«

getUsers @

Ij data [] 50 items
error null

<//' body ""
bodyType "none"

{i} cacheKeyTtl ""
changeset ""

(E) changesetIsObject false
changesetObject ""

533 confirmationMessage null
cookies ""
enableCaching false
enableErrorTransformer false
enableTransformer false
errorTransformer "// The vari..
finished 1699261713654
headers ""
id "getUsers"
isFetching false
isImported false
lastReceivedFromResourceAt 1é..
metadata {} 4 keys
notificationDuration ""
offlineQueryType "None"
offlineUserQueryInputs ""
overrideOrgCacheForUserCache f.
paginationDataField ""
paginationEnabled false
paginationLimit ""
paginationPaginationField ""
playgroundQueryId null
playgroundQuerySaveld "latest"
playgroundQueryUuid ""
query ""
queryDisabled ""
queryDisabledMessage ""
queryFailureConditions ""
queryRefreshTime ""
queryRunTime 769
queryThrottleTime 750
queryTimeout 10000
quer\yTrlggerDe‘La.y 0 — 100%

<C> rawData [] 50 items
requestSentTimestamp null

© Latest No queries running & fDebug O @
|= O JMobbin Admin QB m
Component Tree Lo«
@ Inspector (82U) <«
Frames +
&
Header
b4 Sidebar
Main
@ *
O
Main Components +
No components
<> — 100%
© Latest No queries running & fDebug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
Inspector (82U) <«
Q search components
€
Commonly used
«®
LN“JV
CE
{
Table Text Button
O
@ T—1 # I =
Text Input Number Select
Input
A B
-
Container Form Tabbed
Container
& ==
Modal Chart Key Value
(&) »--
Image Navigation
Text inputs
T $ T ke S —I
Editable Text Editable Text Email
Area
B/u”
0 51 ;
I
JSON Editor  Password Rich Text
Editor
T
- I T—1 I
<> — 100%
Text Area Text Input URL
© Latest No queries running & fDebug O @
|== JMobbin Admin m
Releases History
Inspector
Release management is not available on
your plan. Upgrade your plan to create
and manage releases.
®  Create query1 (REST)
Create app
O
<> 100
|= O JMobbin Admin QB m
Releases History 7 «

@ Inspector (82U) <«
Rename query... (current version)

I-_V'Y 3 minutes ago - You

</®  Ccreate query1 (REST) 2
4 minutes ago - You

{i}
Create app 2

@ 16 minutes ago - You

<> — 100%

© Latest No queries running & fDebug O @


View access list

screenElements: Dialog Banner

screenKeywords:
-—_ RethI Apps Resources Database Query Library Workflows Upgrade Q (s~
—_—
o 8 S]
Apps Database Resources
Create a web app or a native mobile app to build a custom Easily store data in a free SQL database and power your Securely connect your data and display it inside of Retool
internal tool for your business. Retool apps. apps.
Create aweb app -
Create a mobile app - Use Retool Database - Connect aresource -
s s o . Get started with Al
. © @ © O¢ Retool Al gives you powerful building blocks - like LLM connectors and a vector database - to create Al- Start building with Al > Learn more X
powered applications and workflows.
7+ Introducing Retool Storage
Retool storage is a Retool-hosted file store. Using Retool Storage, you can upload and download files and use Try Retool Storage > Learn more X
N them in your apps and workflows.
View access list
Rename
Duplicate
Tras h Export to JSON
Export to Toolscript ZIP
All  Recent Starred Modules Folders Trash
Move to folder
Name v Updated Last Editor Delete permanently
JMobbin Admin - copy a minute ago Edit View
o Title your first app a few seconds ago Jane Smith @
|Access list X
Users  Groups

2 groups have access to JMobbin Admin - copy. To modify this, go to .
GROUP PERMISSIONS
admin Oown

All Users Edit
|Access list X

Users Groups

1 user has access to JMobbin Admin - copy. To modify this, go to .

USER GRANTED THROUGH PERMISSIONS

e rlan_e Smith . . 2 groups Oown
jsmith.mobbin2@gmail.c...


Query library

screenKeywords:
== Retool Apps  Resources  Database  QueryLibrary  Workflows Upgrade [KORENEREN
A -
8 Private
Your Queries (1) Resource REST Variables (1)
S country_name
Country Search Action type ~ GET https://restcountries.com/v3.1/name/{{ country_name }+} united
24 minutes ago
URL parameters
Shared i 0
ared Queries (0) Headers
Schema
+ Add new
Body None
Cookies
+ Add new
Usage (0)
|-—_ RethI Apps Resources Database Query Library Workflows Upgrade Qs ~
Retool Playground Email Query el
&% Shared
Your Queries (1 Variables (0
™ Resource & Retool Email @
REST Add Reply-To
Country Search
2 days ago To
jsmith.mobbin2@gmail.com
Shared Queries (1) Add Cc/Bec
B retool_email Subject Schema
Retool Playground Email Query % Hello from Retool Email!
a minute ago by Jane Smith
Body
Text HTML Markdown Preview
1 This is a _test email_ from Retool Email.
2
3 You can now write emails in **plain text*x, *xHTMLx*, or **Markdown** formats. Use the Preview button to view your
email changes in real-time before sending.
4
5 Learn more about this feature [here](https://docs.retool.com/docs/send-emails)!
6
Attachment
+~ Query succeeded Download json
v accepted: [] 1 item
0: "jsmith.mobbin2@gmail.com"
rejected: [] © items
envelopeTime: 186
messageTime: 40
Usage (0)
messageSize: 851
response: "250 Great success"
v envelope: {} 2 keys °


Adding a user (permission group)

screenKeywords:
== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
Admin
AT For this default permissions group, access rules cannot be modified @
sers
In addition, members of this group can modify all aspects of Retool, including org-wide settings.
Admin
Members Apps Resources Workflows Additional
All users + Add new
@ Jane Smith
@ Jonsmith [}
Deselect Add to group
|== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
AT For this default permissions group, access rules cannot be modified @
sers
In addition, members of this group can modify all aspects of Retool, including org-wide settings.

Admin

Members Apps Resources Workflows Additional

All users + Add new
@ Jane Smith
|== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
AT For this default permissions group, access rules cannot be modified @
sers
In addition, members of this group can modify all aspects of Retool, including org-wide settings.

Admin

Members Apps Resources Workflows Additional

All users + Add new
@ Jane Smith
© Jon smitn
|== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
Admin
AT For this default permissions group, access rules cannot be modified @
sers
In addition, members of this group can modify all aspects of Retool, including org-wide settings.
Admin
Members Apps Resources Workflows Additional
All users + Add new
@ Jane Smith Select all
@ Jonsmith


Adding a chatbox component

screenKeywords:
- . .
a B JMobbin Admin QB m
@ Components Modules 57 <«
= chat1 Q e X »
. .
Q search compnents JMobbin Admin
I'_"Y Content
¢)® Dateandtimeinputs Placeholder Type a message
ID Name Email Blocked
. T I B8—1I Al name Retool AL
{i . . 1 Hershel McV... etexton2d@...
. Sender name
O] CTLe’Ldtar Date  Date Range 2 Gayel Coton ekeitley3v@... v
P! {{ current_user.fullName }}
@ 3 Imogene Sch... ckiddey64@... v
1 31 Mar Actions
4 Anita Oliver tmordy6l@m...
Date Time Day Month @ Copy
5 Costa Spata kesposilc@... v
Add-ons
D—I 1990 6 Catharina M...  uqueree69@... v +
Avatar {{ current_user.pr..
Time Year 7 Booth Macq... sloache34@...
Header Title, Download, C..
Special inputs 50 results Y &L O Empty state Enabled
-cn [%1 . Timestamp true
- >
Unblock user v
Annotated  Boundi Chat .
i R @ Interaction
Query to trigger
1) | e a Chat RO
1 chat1_query1
ColorInput ~ C t Feat
olor Inpu ommen :Iaa;;e Disable send false
Event handlers +
File Add file
Trigger queries, control components, or call
File Button File File Input other APIs in response to component events.
Dropzone No messages here yet
Send a message to chat with Al
And || Or Appearance =
5 nne
& Record _—
— fliem Hidden false
Microphone Query Scanner
Builder Styles rl +
. None
00:00
& A — 100%
Start
© Latest No queries running & wDebug O @
|- . .
a B JMobbin Admin QB m
@ Components Modules 57« = Vame blockAll blockAllUsers <> chatl_queryl X -+ [
= chat1 Q e X »
. .
I-_Y Q' search components General Response Advanced eee  Preview JMObbln Admln
g Content
/> ~ Dateandtimeinputs Resource <> Retool Al Edit Placeholder Type a message
ID Name Email
© Tt I B8—1I Al name Retool AL
! - Run query only when manually triggered 1 Hershel McV... etexton2d@...
. Sender name
O] CTLe’Ldtar Date  Date Range 2 Gayel Coton ekeitley3v@...
P! Acti {{ current_user.fullName }}
ction
@ 3 Imogene Sch... ckiddey64@...
e—1 31 Mar Generate chat response Actions
4 Anita Oliver tmordy6l@m...
Date Time Day Month Input 7] Copy
5 Costa Spata kesposilc@...
{{ chatl.lastMessage }}
Add-ons
D—I 1990 6 Catharina M...  uqueree69@... +
Avatar {{ current_user.pr..
Time Year M hist 7 Booth Macq... sloache34@...
essage history Header Title, Download, C..
- {{ chatl.messageHistory }} oM e .
Special inputs 5¢  Empty state Enabled
-cn [%1 . Timestamp true
- > Use Retool Vectors to provide more context to your query Unblock user >
Annotated  Boundi Chat .
i R @ Model Interaction
& gpt-4 Query to trigger
1) | e = Chat RO i
I System Prompt chat1_query1
ColorInput ~ C t Feat i
olor Inpu omment :Iaa;;e You are a helpful assistant Disable send false
Event handlers +
File Add file
Transform results Enable Trigger queries, control components, or call
Fi . . other APIs in response to component events.
ile Button File File Input
Dropzone Enable transformers to transform the result of the query to a different format. No messages here yet
Send a message to chat with Al
And || Or Appearance =
5 nne
& Record _—
= e Event Handlers Hidden false
Microphone Qqery Scanner Success +
Builder Styles rl +
Trigger queries, control components, or call other APIs in response to query
00:00 ctinnnee Thaen ara nat rin whan tha atans ic neavicuad None
A — 100%
<> Start Output A
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
Components Modules 57 <«
@ Inspector (8U) <«
. .
ry | Q ssarncomponans JMobbin Admin
'-
2 Date and time inputs
ID Name Email Blocked
) MTWTF o 51
{i . = . 1 Hershel McV... etexton2d@...
O] CTLep’Ldtar Date  Date Range 2 Gayel Coton ekeitley3v@... v
@ 3 Imogene Sch... ckiddey64@... v
E—I 31 Mar
4 Anita Oliver tmordy6l@m...
Date Time Day Month
5 Costa Spata kesposilc@... v
D—I 1990 6 Catharina M...  uqueree69@... v
Time Year 7 Booth Macq... sloache34@...
Special inputs 50 results Yy L O
an L]
- L]
= Iy &
Unblock user v
Annotated Bounding Chat
Text Box
L]
I B ©
I
Color Input  Comment Feature
Flags
File Add file
File Button File File Input
Dropzone
B And/jjlOr e
& Record _—
—_ e
Microphone Query Scanner
Builder
<> Q/u 00:00 — 100%
Start
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
= chat1 Q e X »
I__Y Q search components Unblock user -
g Content
Lo Q o)
¢/® Dateandtimeinputs Placeholder Type a message
B Chat LW
i T 21 Al name Retool AL
{i} o I =
»
\9 Calendar Date Date Range Sender name
Input {{ current_user.fullName }}
@ 1 3 Mar Actions
Date Time Day Month No messages here yet ) Copy
Send a message to chat with Al
Add-ons
O—I 1990 +
Avatar {{ current_user.pr..
Time Year
Header Title, Download, C..
Special inputs Empty state Enabled
i true
= I&l 3 Type a message > Timestamp
- >
Annotated Bounding Chat .
Text Box O O Interaction
5 Query to trigger
I B ©
I chat1_query1
Color Input  Comment F:Iaat;;e Disable send false
Event handlers +
File Add file . .
Trigger queries, control components, or call
File Button File File Input other APIs in response to component events.
Dropzone
And/jjOr nne Appearance =
& Record _llllll
Hidden false
Microphone Query Scanner
Builder Styles rl +
. None
00:00
& A — 100%
Start
© Latest No queries running & wDebug O @


Hiding fields

screenKeywords:
-—_ Resources / Retool Database Feedback? e
= transactions v +
Add row Import CSV v & Fields (2 hidden) Y/ Filters $ Sort 1 Q_ Quick find & Refresh 51 records

@] # id PRIMARY KEY Pinned v (@ transaction_date v |+
1 1 i # id Primary key Jan 13,2023 12:02:00 AM

2 2 Fields Jan 15, 2023 5:00:00 PM

3 3 A account_number o© Jan 08, 2023 8:02:00 PM

4 4 i A company o© Jan 30, 2023 8:23:00 AM

5 5 i © transaction_date © Jan 21, 2023 12:16:00 AM

i A payment_type
6 6 Jan 02, 2023 4:02:00 PM
A plan

7 7 Jan 06, 2023 5:01:00 AM

8 8 Jan 05, 2023 8:25:00 AM

9 9 up Jan 07,2023 2:07:00 AM

10 10 Jan 21, 2023 12:58:00 AM

11 11 account_y4b rrogressive Jan 18,2023 7:26:00 AM

12 12 account_232 Citigroup Jan 04, 2023 8:00:00 PM

13 13 account_227 Stripe Jan 17,2023 12:29:00 PM

14 14 account_586 Oracle Jan 17,2023 10:52:00 PM

15 15 account_789 JP Morgan Chase Jan 01, 2023 1:31:00 PM

16 16 account_495 Gamestop Jan 11,2023 4:40:00 AM

17 17 account_120 Kroger Jan 04, 2023 6:55:00 AM

18 18 account_405 Nationwide Jan 17,2023 6:42:00 AM

19 19 account_305 UnitedHealth Group Jan 07,2023 1:10:00 AM

20 20 account_20 Costco Wholesale Jan 17,2023 5:17:00 PM

21 21 account_669 CVS Health Jan 13,2023 3:58:00 PM
|-—_ Resources / Retool Database Feedback? e
= transactions - +
Add row Import CSV v @ Fields Y/ Filters { Sort 1 Q_ Quick find & Refresh 51 records
O # id PRIMARY KEY v~ = A account_num.. v A company v (® transaction_date v A payment_.. v A plan v |+
1 51 account_jsmobbin1 JMobbin Nov 01, 2023 5:00:00 PM NULL NULL
2 50 account_713 Salesforce Jan 11,2023 4:36:00 AM Credit Enterprise
3 49 account_885 Oracle Jan 04, 2023 4:46:00 AM Credit Basic
4 48 account_280 Walt Disney Jan 05, 2023 8:06:00 PM Invoice Pro
5 47 account_453 Costco Wholesale Jan 01,2023 7:12:00 PM Debit Enterprise
6 46 account_248 Front Jan 26,2023 12:27:00 AM Invoice Pro
7 45 account_778 Comcast Jan 02, 2023 8:35:00 AM Credit Basic
8 44 account_961 Nike Jan 08, 2023 5:50:00 PM Invoice Basic
9 43 account_766 Brex Jan 23,2023 12:29:00 PM Debit Pro
10 42 account_984 Bumble Jan 24,2023 9:10:00 AM Invoice Enterprise
11 41 account_805 CVS Health Jan 13,2023 5:26:00 AM Invoice Pro
12 40 account_137 Berkshire Hathaway Jan 01, 2023 5:57:00 PM Debit Basic
13 39 account_781 Nike Jan 03,2023 10:47:00 PM Invoice Pro
14 38 account_849 Procter & Gamble Jan 15,2023 9:42:00 AM Credit Enterprise
15 37 account_740 General Motors Jan 31,2023 2:58:00 AM Invoice Basic
16 36 account_418 Goldman Sachs Group Jan 26, 2023 5:22:00 AM Invoice Pro
17 35 account_565 FedEx Jan 17,2023 10:02:00 AM Debit Pro
18 34 account_748 Gamestop Jan 05, 2023 10:41:00 AM Debit Pro
19 33 account_998 Comcast Jan 20, 2023 7:55:00 AM Credit Pro
20 32 account_733 Target Jan 13,2023 12:35:00 PM Debit Pro
21 31 account_631 UPS Jan 06, 2023 7:42:00 AM Debit Pro
|-—_ Resources / Retool Database Feedback? e
= transactions v +
Add row Import CSV v @ Fields Y/ Filters { Sort 1 Q_ Quick find & Refresh 51 records
@] # id PRIMARY KEY Pinned v (@ transaction_date v A payment_. v A plan v |+
1 1 i # id Primary key Jan 13,2023 12:02:00 AM Credit Pro
2 2 Fields Jan 15,2023 5:00:00 PM Invoice Basic
3 3 :: A account_number [ o) Jan 08, 2023 8:02:00 PM Invoice Pro
4 4 i A company © Jan 30, 2023 8:23:00 AM Credit Basic
5 5 ¥ O transaction_date © Jan 21, 2023 12:16:00 AM Invoice Enterprise
i A payment_type o©
6 6 Jan 02,2023 4:02:00 PM Debit Basic
A plan o©
7 7 Jan 06, 2023 5:01:00 AM Invoice Pro
8 8 Jan 05, 2023 8:25:00 AM Credit Pro
9 9 up Jan 07,2023 2:07:00 AM Credit Pro
10 10 Jan 21,2023 12:58:00 AM Invoice Enterprise
11 11 account_y4b rrogressive Jan 18,2023 7:26:00 AM Invoice Basic
12 12 account_232 Citigroup Jan 04, 2023 8:00:00 PM Invoice Basic
13 13 account_227 Stripe Jan 17,2023 12:29:00 PM Invoice Basic
14 14 account_586 Oracle Jan 17,2023 10:52:00 PM Debit Pro
15 15 account_789 JP Morgan Chase Jan 01, 2023 1:31:00 PM Credit Enterprise
16 16 account_495 Gamestop Jan 11,2023 4:40:00 AM Invoice Basic
17 17 account_120 Kroger Jan 04, 2023 6:55:00 AM Invoice Basic
18 18 account_405 Nationwide Jan 17,2023 6:42:00 AM Credit Basic
19 19 account_305 UnitedHealth Group Jan 07,2023 1:10:00 AM Invoice Basic
20 20 account_20 Costco Wholesale Jan 17,2023 5:17:00 PM Debit Enterprise
21 21 account_669 CVS Health Jan 13,2023 3:58:00 PM Credit Pro


Using AI to write code

screenElements: Select Tooltip Popover

screenPatterns:
Confirmation
Select
Code Editor

screenKeywords:
= O JMobbin Admin QB m
@ Code P« = getUsers [ transformer1 x - ® No components L o»
Showing 2 Q = + .
I__;" Code Preview No components selected
{7} getUsers 0.6s
<> B transformer1 1 // Reference external variables with curly brackets or using JS
variables

{} 2 const name = {{ current_user.firstName || 'world' }}
]

3

4 return 'Hello ' + name
O
@ Run a Preview Query. When you preview your query, Al is able to use the Esc

exact response to write code.

Generate v <« e

L |8

Generate

Explain

Add comments to explain the query

— 100%
<> Output A
© Latest No queries running & fDebug O @
|= O JMobbin Admin QB m
@ Code P« = getUsers ) transformerl o -+ (=) No components L o»
Showing 2 Q = + :
e Code ** || Preview No components selected
{7} getUsers 0.6s
<> B transformer1 o 1 // Reference external variables with curly brackets or using JS
variables
{} 2 + [*x
! The code is assigning the value of ‘current_user.firstName®
to the variable “name’. If "current_user.firstName™ is
\9 3 undefined or null, it assigns the string “'world'" to
4 “name’ . After that, it returns the string ' 'Hello '
@ Run a Preview Query. When you preview your query, Al is able to use the Esc
AvAant racnAnen tA wiritA AndA

‘ ) Accept R e

 fi Reject Esc .

Learn more about JS transformers here.

— 100%
<> Output A
© Latest No queries running & fkDebug O @
|- . .
a B JMobbin Admin QB m
@ Code P« = getUsers [ transformer1 x - ® No components L o»
Showing 2 Q = + ;
e Code ** || Preview No components selected
{7} getUsers 0.6s
<> transformer1 1 ternal variables with curly brackets or using JS
8 @ Explain %E v ¢
{} 2 const name = {{ current_user.firstName || 'world' }}
]
3
4 return 'Hello ' + name
O
@ Run a Preview Query. When you preview your query, Al is able to use the Esc
exact response to write code.
Explain v Select code to explain... <« e
Learn more about JS transformers here.
— 100%
<> Output A
© Latest No queries running & fDebug O @
|= O JMobbin Admin QB m
@ Code P« = getUsers [ transformer1 x - ® No components L o»
Showing 2 Q = + :
e Code ** || Preview No components selected
{7} getUsers 0.6s
<> B transformer1 1 // Reference external variables with curly brackets or using JS
variables
{} 2 const name = {{ current_user.firstName || 'world' }}
]
3
4 return 'Hello ' + name
O
Learn more about JS transformers here.
— 100%
<> Output A
© Latest No queries running & M Debug O @
|= O JMobbin Admin Q B m
@ Code P« = getUsers ) transformerl o -+ (=) No components L o»
Showing 2 Q = + :
e Code ** || Preview No components selected
{7} getUsers 0.6s
<> B transformer1 o 1 // Reference external variables with curly brackets or using JS
variables
{} 2v [*
! 3 The code is assigning the value of “current_user.firstName® to
the variable “name’. If “current_user.firstName® is undefined
\9 or null, it assigns the string “'world'® to “name’. After that,
it returns the string "'Hello ' concatenated with the value of
“name” .
3 4 %/
5 const name = {{ current_user.firstName || 'world' }}
6
7  return 'Hello ' + name (&)
Learn more about JS transformers here.
— 100%
<> Output A
© Latest No queries running & fkDebug O @
|= O JMobbin Admin QB m
@ Code P« = getUsers [ transformer1 x - ® No components L o»
Showing 2 Q = + ;
e Code ** || Preview No components selected
{7} getUsers 0.6s
<> B transformer1 1 // Reference external variables with curly brackets or using JS
variables
{} 2 const name = {{ current_user.firstName || 'world' }}
]
3
4 return 'Hello ' + name
O
@ Run a Preview Query. When you preview your query, Al is able to use the Esc
exact response to write code.
Explain v Select code to explain... <« e
Learn more about JS transformers here.
— 100%
<> Output A
© Latest No queries running & fDebug O @


Resources

screenElements:
Table
Stacked List

screenKeywords:
Playground Resources
[3 Playground Re...
Name Type Created Usage

@ [demo resource] BigQuery BigQuery 23 minutes ago 0
b [demo resource] Firebase Firebase 23 minutes ago 0
© [demo resource] Google Cloud Storage Google Cloud Storage 23 minutes ago 0
Q [demo resource] Google Sheets Google Sheets 23 minutes ago 0
7% [demo resource] GraphQL GraphQL 23 minutes ago 0
@ [demo resource] Microsoft SQL Microsoft SQL 23 minutes ago 0
0 [demo resource] MongoDB MongoDB 23 minutes ago 0
W\, [demo resource] MySQL MySQL 23 minutes ago 0
! [demo resource] PostgreSQL PostgreSQL 23 minutes ago 0

[demo resource] REST API REST API 23 minutes ago 0
8 [demo resource] S3 Amazon S3 23 minutes ago 0
3% [demo resource] Snowflake Snowflake 23 minutes ago 0 °
|== Retool Apps  Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
) Playground Re...

8 Retool Database PostgreSQL

3  Retool Storage File Storage

B  Retool Email Email

<>  Retool Al Al

< Retool Vectors Beta Al

Name Type Created Usage

[ Playground Resources Folder 23 minutes ago 0

onboarding_api REST API 23 minutes ago 0

! onboarding_db PostgreSQL 23 minutes ago 0


Uploading an image

screenKeywords:
= B JMobbin Admin Q8 m
@ Components Modules 57 <«
image1 Q e X »
Iy JMobbin Admin
\g Content
Commonly used
<//. Image source URL Storage Js
New i ID Name Email Blocked
{} m File input 4109ue.png
! 1  Hershel McV... etexton2d@... v
Table Text Button
) 2 Gayel Coton ekeitley3v@... v
— G
I I — 3 Imogene Sch... ckiddey64 v
@ 9 iddey64@. Upload bmp, gif, jpg, png, svg or webp files.
Text Input Nlumbter Select 4 Anita Oliver tmordy6l@m... v Max 40MB.
npu
5 Costa Spata kesposilc@... v Use legacy files
A B
- 6 CatharinaM... uqueree69@... Alt text
Container Form Tabbed
Container 7 Booth Macg... sloache34@... Add-ons +
PR TUPS bt ataaan . None
Il D 50 results Y &L O
[ ] 1
Modal Chart Key Value Interaction
Unblock user > Event handlers +
Trigger queries, control components, or call
other APIs in response to component events.
Image Navigation
Text inputs l » l Appearance =
- Height Auto Fixed
! - 4
{ Aspect ratio
Editable Text Editable Text Email
Area Hidden false
BIu”
; 1 I Styles 2 +
None
JSON Editor  Password Rich Text
Editor
I I I
<> — 100%
Text Area Text Input URL
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
(4 image1 Q s X »
. .
Q search compnents JMobbin Admin
I'_"Y Content
Commonly used
(//. Image source URL Storage Js
New i ID Name Email Blocked
{} m File input FX | No files have been upl...
! 1  Hershel McV... etexton2d@... v
Table Text Button
) 2 Gayel Coton ekeitley3v@... v
— G
T—I) [#—1 — 3 Imogene Sch... ckiddey64 v
@ 9 y64@- Upload bmp, gif, jpg, png, svg or webp files.
Textinput  Number  Select 4 AnitaOliver  tmordy6l@m.. Max 40MB.
npu
5 Costa Spata kesposilc@... v Use legacy files
A B
- 6 CatharinaM... uqueree69@... Alt text
Container Form Tabbed
Container 7 Booth Macg... sloache34@... Add-ons +
& A e n . None
Il D 50 results Yy &L O
[ ] 1
Modal Chart Key Value Interaction
Unblock user > Event handlers +
Trigger queries, control components, or call
R S other APIs in response to component events.
Image Navigation i 1
. | i -
Text inputs i : Appearance =
I Height Auto Fixed
T— ¢ T=¢ |[S—I ! ;
| Aspect ratio
Editable Text Editable Text Email i i
Area : ! Hidden false
O BIu”
; Pl I Styles 2 +
None
JSON Editor  Password Rich Text
Editor
| IE=D R=T
<> — 100%
Text Area Text Input URL
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
(4 image1 Q s X »
. .
Q search compnents JMobbin Admin
I'_"Y Content
Commonly used
(//. Image source URL Storage Js
L"ﬂjf i ID Name Email Blocked
{i} 1 Hershel McV... etexton2d@... v https://placekitten.com/400/300
Table Text Button
) 2 Gayel Coton ekeitley3v@... v Alt text
9y =i # —1 5 i
@ 3 Imogene Sch... ckiddey64@... v Add-ons +
Text Input Nlumbter Select 4 Anita Oliver tmordy6l@m... v None
npu
5 Costa Spata kesposilc@... v
-4 Interaction
- 6 Catharina M...  uqueree69@... v
Container Form Tabbed Event handlers +
Container 7 Booth Macg... sloache34@... . .
Trigger queries, control components, or call
PN T PR e taa . other APIs in response to component events.
Il D 50 results Y &L O
[ ] 1
-
Modal Chart Key Value Appearance o
Unblock user v Height Auto Fixed
Aspect ratio
Image Navigation w; Hidd fal
idden alse
Text inputs l l Styles 2 +
s None
T ¢ T ke S —I x -
Editable Text Editable Text Email
Area
BIu”
{3 : XT3 I
JSON Editor  Password Rich Text
Editor
| IE=D R=T
<> — 100%
Text Area Text Input URL
© Latest No queries running & wDebug O @


Adding a url parameter

screenKeywords:
= O JMobbin Admin QB m
@ Code L« = () getUsers X -+ (=]
Inspector (82U) <«
I-_Y Showing 1 Q= + General Response Advanced ees  Preview
'-
{7} getUsers
<> Resource  {} Playground Resources / Users API v
{i} Run query automatically when inputs change v
O
Action type
@ GET v https://retoolapi.dev/qi0S3  api/v2/endpoint. json
(GET req) Will run automatically whenever a parameter changes.
URL parameters
key value X
Headers
key value X
+ Add new
Body
None v
Cookies
key value X
+ Add new
Transform results Enable
Enable transformers to transform the result of the query to a different format.
Event Handlers
Success +
Trigger queries, control components, or call other APIs in response to query
success. These are not run when the query is previewed.
— 100%
<> Output A
© Latest No queries running & fkDebug O @
|= O JMobbin Admin QB m
@ Code Lo« = {getUsers o - ® No components L »
Showing 1 Q = + :
I-_V'Y General Response Advanced eee  Preview No components selected
{7 getUsers ® 0.8s
<> Resource  {} Playground Resources / Users API
{i} Run query automatically when inputs change
O
Action type
@ GET https://retoolapi.dev/qi0S3  ?mobbin=
(GET req) Will run automatically whenever a parameter changes.
URL parameters
String O vatve X
"mobbin"
Headers
key value X
+ Add new
Body
None
Cookies
key value X
+ Add new
Transform results Enable
Enable transformers to transform the result of the query to a different format.
Event Handlers
Success +
— 100%
<> Output A
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
@ Code L« = {1l getUsers o - ® No components L »
Showing 1 Q = + :
I-_V'Y General Response Advanced eee  Preview No components selected
{7 getUsers ® 0.8s
<> Resource  {} Playground Resources / Users API
{i} Run query automatically when inputs change
O
Action type
@ GET https://retoolapi.dev/qi0S3  ?mobbin=yay
(GET req) Will run automatically whenever a parameter changes.
URL parameters
Key String 0| «
"yay"
Headers
key value X
+ Add new
Body
None
Cookies
key value X
+ Add new
Transform results Enable
Enable transformers to transform the result of the query to a different format.
Event Handlers
Success +
— 100%
<> Output A
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
@ Code L« = {1l getUsers o - ® No components L »
Showing 1 Q = + :
I-_V'Y General Response Advanced eee  Preview No components selected
{7 getUsers ® 0.8s
<> Resource  {} Playground Resources / Users API
{i} Run query automatically when inputs change
O
Action type
@ GET https://retoolapi.dev/qi0S3  ?mobbin=yay
(GET req) Will run automatically whenever a parameter changes.
URL parameters
mobbin yay X
key value X
Headers
key value X
+ Add new
Body
None
Cookies
key value X
+ Add new
Transform results Enable
Enable transformers to transform the result of the query to a different format.
Event Handlers
Success +
— 100%
<> Output A
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q 8 m
® Code L o« = {)getUsers » -+ =] No components L »
Showing 1 Q = + .
m General Response Advanced Preview w No components selected
| getUsers » 0.8s
<> Resource {} Playground Resources / Users API v
{i} Run query only when manually triggered v
O
Action type
@ PATCH v https://retoolapi.dev/qi0S3 | [{tablel.changesetArray
['e'].idHj )
By default, PATCH will only run in response to a user © Error a
URL parameters TypeError: Cannot read
properties of undefined
key value (reading 'id')
Headers
key value X
+ Add new
Body
JSON v
key value X
+ Add new
Cookies
key value X
+ Add new
Transform results Enable
Enable transformers to transform the result of the query to a different format.
Fuvant Handlere
— 100%
<> Output A
© Latest No queries running & wDebug O @


Moving code

screenKeywords:
= O JMobbin Admin QB m
@ Code L« = {1} getUsers X - ® No components L o»
Showing 1 Q = + )
I-_V'Y General Response Advanced Preview No components selected
v folderl (1)
< {7} getUsers 0.6s Resource  {} Playground Resources / Users API v
{i} Run query automatically when inputs change v
O
Action type
@ GET v https://retoolapi.dev/qi0S3  ?
(GET req) Will run automatically whenever a parameter changes.
URL parameters
key value X
Headers
key value X
+ Add new
Body
None v
Cookies
key value X
+ Add new
Transform results Enable
Enable transformers to transform the result of the query to a different format.
Event Handlers
Success +
Trigger queries, control components, or call other APIs in response to query
success. These are not run when the query is previewed.
— 100%
<> Output A
© Latest No queries running & fkDebug O @
|= B JMobbin Admin Q 8 m
@ Code L« = () getUsers X - = No components L »
Showing 1 Q = + ; e
I—: General Response Advanced Preview No components selected
~  folder1 (0)
<> No code Resource  {} Playground Resources / Users API v
. getUsers
{i} Run query automatically when inputs change v
O
Action type
@ GET v https://retoolapi.dev/qi0S3 2
(GET req) Will run automatically whenever a parameter changes.
URL parameters
key value X
Headers
key value X
+ Add new
Body
None v
Cookies
key value X
+ Add new
Transform results Enable
Enable transformers to transform the result of the query to a different format.
Event Handlers
Success +
Trigger queries, control components, or call other APIs in response to query
success. These are not run when the query is previewed.
— 100%
<> Output A
© Latest No queries running & fEDebug O @
|= O JMobbin Admin QB m
@ Code L« = {1} getUsers X - ® No components L o»
Showing 1 Q = + )
I-_V'Y General Response Advanced Preview No components selected
v folder1 (0)
<> No code Resource  {} Playground Resources / Users API v
) {7} getUsers 0.6s
{'} Run query automatically when inputs change v
O
Action type
@ GET v https://retoolapi.dev/qi0S3  ?
(GET req) Will run automatically whenever a parameter changes.
URL parameters
key value X
Headers
key value X
+ Add new
Body
None v
Cookies
key value X
+ Add new
Transform results Enable
Enable transformers to transform the result of the query to a different format.
Event Handlers
Success +
Trigger queries, control components, or call other APIs in response to query
success. These are not run when the query is previewed.
— 100%
<> Output A
© Latest No queries running & fkDebug O @


Selecting an icon

screenElements: Combobox Popover

screenKeywords:
= B JMobbin Admin Q8 m
@ Edit state x B Status indicator <= 5 >
. .
I_—? JMObbln Admln Jontent
\g Show when true
tates 2+
<> i * Label NilL
ID Name Email Blocked Comments Nill
{} Color
! 1 Hershel McV... etexton2d@... 1 Nill
B . i Icon 4 Interface Arrows Up ... €@
) 2 Gayel Coton ekeitley3v@... v + Nill
B 3 Imogene Sch.. ckiddey64@.. + Nill Tooltip
4 Anita Oliver tmordy6l@m... v 4 Nill
5 Costa Spata kesposilc@... v 4 Nill
6 Catharina M...  uqueree69@... 4 Nill
7 Booth Macg... sloache34@... 4 Nill
50 results Y &L O
O O
<> — 100%
© Latest No queries running & wDebug O @
|= B Select icon X a & m
. .
Iy JMobbin Admin . _— - Sontent
M o7 0 ow when rue
L 8 v b v € 9 - ol +
<D Label Nill
ID  Name Emal l w (Y \9 M g r° P t ﬁ Nill
{} Color
! 1  Hershel McV... etex
\9 2 Gayel Coton ekeit t t a 6\ .T j\ (a4 ﬂ i ! lcon {U Interface Arrows But... €
& 3 Imogene Sch.. ckide % v <4 4 » > (w7 {l 1> o Tooltip
4 Anita Oliver tmor
A A Y NN KX K
5 Costa Spata kesp
N N 7/ 7/
6 Catharina M...  uque 7' A A h h x K x X 5
7 Booth Macq... sloac...e—.. — - - . - -— a - -
50 results Y & O
<> — 100%
© Latest No queries running & wDebug O @
|= B Selecticon X QB m
. .
Iy JMobbin Admin . _— - Sontent
M o7 0 ow when rue
T G P I e € 9 - ol +
<D Label Nill
ID Name Emal l w (Y \9 M g r° P t ﬁ Nill
{} Color
! 1  Hershel McV... etex
o) 2 Gayel Goton ekl t t “ 6\ .T j\ (ad ﬂ i ! Icon G Interface Arrows Syn... @
& 3 Imogene Sch.. ckide % v <4 4 » > (w7 {l 1> o Tooltip
4 Anita Oliver tmor
A AU ¥ £ My YN K/
5 Costa Spata kesp
N N 7/ 7/ K K
6 Catharina M...  uque 7' A A h h K A x X 5
7 Booth Macq... sloac...e—.. — - - - - a - -
50 results Y & O
<> — 100%
© Latest No queries running & wDebug O @
|-_- B Selecticon X QB m
@ Edit state x B Status indicator <= 5 >
. .
m JMObbln Admln Bold C C ) b o ) ~ - ~ ~ Show when e ontent
W W U
= - tates o+
o € 0 T T O < T I 0 . i '
ID Name Emal Nill
ke — x4
{i} 1 Hershel McV... etex l_. T_’ I_) = 2 tl Tl + « I color
o) 2 Gayel Goton ekl @ e @ o 9 O C :: :: ‘K Icon 4 Interface Arrows Up ... €@
@ 3 Imogene Sch...  ckid¢ N < v v Tooltip
e kA 2 8 @ ) ] X 8 2%
4 Anita Oliver tmor
5 Costa Spata kesp 1 G C ; 3 7;‘ b (3 o o
6 Catharina M...  uque
v dtoe o o 2
7 Booth Macg... sloat...o ... P
50 results Y & O
<> — 100%
© Latest No queries running & wDebug O @
|-_- B Selecticon X QB m
@ Bold . Edit state x B Status indicator <= 5 >
. .
m JMObbln Admln Y Y e o ) ~ - ~ ~ Show when e ontent
W W U
= - tates o+
o € 0 T T O < T I 0 ., i '
ID Name Emal Nill
ke — x4
{i} 1 Hershel McV... etex l_. T_’ I_) = 2 tl Tl + « I color
o) 2 Gayel Goton ekl @ e @ o 9 O C :: :: ‘K Icon 4 Interface Arrows Up ... €@
@ 3 Imogene Sch...  ckid¢ N < v v Tooltip
e kA 2 8 @ ) ] X 8 2%
4 Anita Oliver tmor
5 Costa Spata kesp 1 G C ; 3 7;‘ b (3 o o
6 Catharina M...  uque
v dtoe o o 2
7 Booth Macg... sloat..co ... P
50 results Y & O
<> — 100%
© Latest No queries running & wDebug O @
|-_- B Selecticon X QB m
@ Edit state x B Status indicator <= 5 >
. .
r+  JMobbin Admin - - -~ -~ - - - Sontent
W Wi Ul
<> Line v 0 4 7 J d b Label Nill peree T
ID Name Emal Nill
A — -
{i} 1 Hershel McV... etex l_. T_’ I_) = 2 tl Tl + « I color
o) 2 Gayel Goton ekl @ e @ o 9 O C :: :: ‘K Icon 4 Interface Arrows Up ... €@
@ 3 Imogene Sch...  ckid¢ N < v v N Tooltip
o K = 2 e 8 J ] X 3 2
4 Anita Oliver tmor
5 Costa Spata kesp 1 G C ; 3 7;‘ b (3 o o
6 Catharina M...  uque
v dtoe o o 2
7 Booth Macg... sloat...o ... P
50 results Y & O
<> — 100%
© Latest No queries running & wDebug O @


Adding a new query

pageType: Application Application Application Application Application Application Application Application

screenKeywords:
== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [NORENERES
Retool Playground Email Query | B m
& Private
Yo ies (2 Variables (0
our Queries (2) Resource & Retool Email ariables (0)
B retool_email ) Add Reply-To
Retool Playground Email Query
a minute ago To
REST
Country Search Add Cc/Bcc
2 days ago
Subject
Schema
Shared Queries (0)
Body
Text HTML Markdown Preview
Attachment
Usage (0)
|== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [NORNERES
Retool Playground Email Query | B m
& Private
Y ies (2 Variables (0
our Querles (2) Resource & Retool Email ariables (0)
B retool_email ) Add Reply-To
Retool Playground Email Query
a minute ago To
jsmith.mobbin2@gmail.com
REST
Country Search Add Cc/Bcc
2 days ago
Subject
Schema
%) Hello from Retool Email!
Shared Queries (0)
Body
Text HTML Markdown Preview
Attachment
Usage (0)
|== Retool Apps  Resources  Database  QueryLibrary  Workflows Upgrade [KORENEREN
A -
8 Private
Your Queries (1) Resource REST Variables (1)
S country_name
Country Search Action type ~ GET https://restcountries.com/v3.1/name/{{ country_name }+} united
24 minutes ago
URL parameters
Shared i 0
ared Queries (0) Headers
Schema
+ Add new
Body None
Cookies
+ Add new
Usage (0)
|== Retool Apps  Resources  Database  QueryLlibrary  Workflows Upgrade [NORENERES
3 Private
Y ies (2 Variables (0
our Queries (2) Resource & Retool Email ariables (0)
B retool_email ) Add Reply-To
Retool Playground Email Query
a minute ago To
REST
Country Search Add Cc/Bcc
2 days ago
Subject
Schema
Shared Queries (0)
Body
Text HTML Markdown Preview
Attachment
Usage (0)
|== Retool Apps  Resources  Database  QueryLlibrary  Workflows Upgrade [NORENERES
& Private
Y ies (2 Variables (0
our Queries (2) Resource & Retool Email ariables (0)
B retool_email Add Reply-To
Retool Playground Email Query
a minute ago To
REST
Country Search Add Cc/Bcc
2 days ago .
Subject seh
chema
Shared Queries (0)
Body
Text HTML Markdown Preview
Attachment
Usage (0)
|-—_ RethI Apps Resources Database Query Library Workflows Upgrade Qs ~
Retool Playground Email Query Ml -
8 Private
Your Queries (2) . Variables (0)
Resource & Retool Email
8 retool_email ) Add Reply-To
Retool Playground Email Query
a minute ago To
jsmith.mobbin2@gmail.com
REST
Country Search Add Cc/Bcc
2 days ago
Subject
Schema
1/ Hello from Retool Email!
Shared Queries (0)
Body
Text HTML Markdown Preview
This is a _test email_ from Retool Email.
You can now write emails in **plain textxx, **xHTML**, or *xMarkdown** formats. Use the Preview button to view your
email changes in real-time before sending.
Learn more about this feature [here](https://docs.retool.com/docs/send-emails)!
Attachment
Usage (0)
|== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [NORENERES
Retool Playground Email Query | B m
& Private
Yo ies (2 Variables (0
our Queries (2) Resource & Retool Email ariables (0)
B retool_email ) Add Reply-To
Retool Playground Email Query
a minute ago To
jsmith.mobbin2@gmail.com
REST
Country Search Add Cc/Bcc
2 days ago
Subject
Schema
Shared Queries (0)
Body
Text HTML Markdown Preview
Attachment
Usage (0)
|== Retool Apps  Resources  Database  QueryLlibrary  Workflows Upgrade [NORENERES
& Private
Your Queries (2) Resource € Retool Email Variables (0)
B retool_email Add Reply-To
Retool Playground Email Query
a minute ago To
REST
Country Search Add Cc/Bcc
2 days ago
Subject
Schema
Shared Queries (0)
Body
Text HTML Markdown Preview
Attachment
Usage (0)


Renaming a query

hotspotType: Right Click

screenKeywords:
= O JMobbin Admin QB m
@ Code L« = () getUsers X -+ (=]
Inspector (82U) <«
I-_Y Showing 1 Q= + General Response Advanced ees  Preview
'-
{7} getUsers
<> Resource  {} Playground Resources / Users API v
{i} Run query automatically when inputs change v
O
Action type
@ GET v https://retoolapi.dev/qi0S3  api/v2/endpoint. json
(GET req) Will run automatically whenever a parameter changes.
URL parameters
key value X
Headers
key value X
+ Add new
Body
None v
Cookies
key value X
+ Add new
Transform results Enable
Enable transformers to transform the result of the query to a different format.
Event Handlers
Success +
Trigger queries, control components, or call other APIs in response to query
success. These are not run when the query is previewed.
— 100%
<> Output A
© Latest No queries running & fkDebug O @
|= B JMobbin Admin Q 8 m
® Code L o« = getUsers patchUser o {3} X + (=]
Inspector (8U) <«
1—9 Showing 3 Q=+ General Response Advanced ees  Preview
‘
{1 getUsers 0.8s
<> {1 patchUser Resource  {} Playground Resources / Users API v
o {7 query3 . .
! Run query automatically when inputs change v
O
Action type
@ GET v https://retoolapi.dev/qi0S3  api/v2/endpoint. json
(GET req) Will run automatically whenever a parameter changes.
URL parameters
key value X
Headers
key value X
+ Add new
Body
None v
Cookies
key value X
+ Add new
Transform results Enable
Enable transformers to transform the result of the query to a different format.
Event Handlers
Success +
Trigger queries, control components, or call other APIs in response to query
success. These are not run when the query is previewed.
— 100%
<> Output A
© Latest No queries running & fEDebug O @
|= B JMobbin Admin Q 8 m
® Code L« = getUsers patchUser o {3 query3 X -+ e
Inspector (8U) <«
I—? Showing 3 Q=+ General Response Advanced ees  Preview
v
{1 getUsers 0.8s
<> {1 patchUser Resource  {} Playground Resources / Users API v
{} {7 query3 o . .
! Run query automatically when inputs change v
_ View state
O
Rename Action type
@ Duplicate ¥®D GET v https://retoolapi.dev/qi0S3  api/v2/endpoint.json
Extract to Query Library (GET req) Will run automatically whenever a parameter changes.
URL parameters
Delete key value X
Headers
key value X
+ Add new
Body
None v
Cookies
key value X
+ Add new
Transform results Enable
Enable transformers to transform the result of the query to a different format.
Event Handlers
Success +
Trigger queries, control components, or call other APIs in response to query
success. These are not run when the query is previewed.
— 100%
<> Output A
© Latest No queries running & fEDebug O @
|= B JMobbin Admin Q 8 m
® Code Lo« = getUsers patchUser « {3} blockUser X + ®
Inspector (8U) <«
1—9 Showing 3 Q=+ General Response Advanced ees  Preview
‘
{1 getUsers 0.8s
<> {1 patchUser Resource  {} Playground Resources / Users API v
. £+ blockUser
{i} Run query automatically when inputs change v
O
Action type
@ GET v https://retoolapi.dev/qi0S3  api/v2/endpoint. json
(GET req) Will run automatically whenever a parameter changes.
URL parameters
key value X
Headers
key value X
+ Add new
Body
None v
Cookies
key value X
+ Add new
Transform results Enable
Enable transformers to transform the result of the query to a different format.
Event Handlers
Success +
Trigger queries, control components, or call other APIs in response to query
success. These are not run when the query is previewed.
— 100%
<> Output A
© Latest No queries running & fEDebug O @
|= B JMobbin Admin Q 8 m
® Code L« = getUsers patchUser o {3 query3 X -+ e
Inspector (8U) <«
1—9 Showing 3 Q=+ General Response Advanced ees  Preview
‘
{1 getUsers 0.8s
<> {1 patchUser Resource  {} Playground Resources / Users API v
o {7 |blockUser
! Run query automatically when inputs change v
O
Action type
@ GET v https://retoolapi.dev/qi0S3  api/v2/endpoint. json
(GET req) Will run automatically whenever a parameter changes.
URL parameters
key value X
Headers
key value X
+ Add new
Body
None v
Cookies
key value X
+ Add new
Transform results Enable
Enable transformers to transform the result of the query to a different format.
Event Handlers
Success +
Trigger queries, control components, or call other APIs in response to query
success. These are not run when the query is previewed.
— 100%
<> Output A
© Latest No queries running & fEDebug O @
|= B JMobbin Admin Q 8 m
® Code L« = getUsers patchUser o {3 query3 X -+ e
Inspector (8U) <«
1—9 Showing 3 Q=+ General Response Advanced ees  Preview
‘
{1 getUsers 0.8s
<> {1 patchUser Resource  {} Playground Resources / Users API v
o @
! Run query automatically when inputs change v
O
Action type
@ GET v https://retoolapi.dev/qi0S3  api/v2/endpoint. json
(GET req) Will run automatically whenever a parameter changes.
URL parameters
key value X
Headers
key value X
+ Add new
Body
None v
Cookies
key value X
+ Add new
Transform results Enable
Enable transformers to transform the result of the query to a different format.
Event Handlers
Success +
Trigger queries, control components, or call other APIs in response to query
success. These are not run when the query is previewed.
— 100%
<> Output A
© Latest No queries running & fEDebug O @


Importing an app

screenKeywords:
= O JMobbin Admin QB m
Components Modules 57 <«
@ Inspector (8U) <«
. .
ry (O ssarncomponans JMobbin Admin
'-
Commonly used
[ J
<I;
L"ﬂj! i ID Name Email Blocked
{i} 1 Hershel McV... etexton2d@... v
Table Text Button
) 2 Gayel Coton ekeitley3v@... v
& T—I) |[#—TI — 3 Imogene Sch... ckiddey64@... v
Text Input Nlumbter Select 4 Anita Oliver tmordy6l@m... v
npu
5 Costa Spata kesposilc@... v
A B
- 6 Catharina M...  uqueree69@... v
Container Form Tabbed
Container 7 Booth Macg... sloache34@...
Il D 50 results Y &L O
[ ] 1
Modal Chart Key Value
Unblock user v
Image Navigation
Text inputs
T $£ T & < —1I
Editable Text Editable Text Email
Area
BIu”
{3 : XT3 I
JSON Editor  Password Rich Text
Editor
| IE=D R=T
<> — 100%
Text Area Text Input URL
© Latest No queries running & wDebug O @
|= O JMobbin Admin Q B m
Components Modules 57 <«
@ Inspector (8U) <«
Note this page uses fake data from https://jsonplaceholdeT-typICOUE.CO
Q search components b R
o User dashboard
Commonly used
[ J
<I; -
Ne " Vs N
[ o Mo m Apply filters ~ : . :
{ -
Table Text Button Search by name Filter by status
\9 Logic in the filter_users transformer Just an example! This doesn't work. 2 About £ Posts 43 Albums
T—1 #—1 — Q_ Search here... Unknown x  Active X  Inactive x
@ o - info
Any x .
Text Input Number Select Email
et
i table1 Website
D5 Phone 55 text38 @
= Username
Container Form Tabbed NO rOWSfOUnd E-------------------------------------------------------------------------------------E
Container b oo e
Showing 0 results ¢ 1 of1 » +y = C Address
Ill D Street 55 text19 @
= suite
Modal Chart Key Value City el
Zip code
Image Navigation Company
Name 55 text27 @
Textinputs Catchphrase
Passcode
Editable Text Editable Text ~ Email S Refresh data
Area
BIu”
{3 : Pl I
JSON Editor  Password Rich Text
Editor
W Mark as VIP
T.
- I av l; ®—I
<> — 100%
Text Area Text Input URL
© Latest No queries running & M Debug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <« App actions
. .
I_Y Q_ Search components IMObbln Admln Import app from JSON/ZIP
'-
Commonly used Export to JSON
b4
e ID Name Email Blocked Export to Toolscript ZIP
W=
{
1 Hershel McV... etexton2d@... v Duplicate app
Table Text Button
) 2 Gayel Coton ekeitley3v@... v Clone to module
T—I) |[#—TI — 3 Imogene Sch... ckiddey64@.. v
@ Reset app state
Text Input Number Select 4 Anita Oliver tmordy6l@m... v
Input Upgrade components
5 Costa Spata kesposilc@... v
A B
- 6 Catharina M...  uqueree69@... v
Container Form Tabbed
Container 7 Booth Macq... sloache34@...
Il D 50 results Y &L O
[ ] 1
Modal Chart Key Value
Unblock user v
Image Navigation
Text inputs
T $£ T & S —I
Editable Text Editable Text Email
Area
BIu”
{3 : XT3 I
JSON Editor  Password Rich Text
Editor
| IE=D R=T
<> — 100%
Text Area Text Input URL
© Latest No queries running & wDebug O @


Opening block in sidebar

screenKeywords:
= [ Jane Smith - Al Onboarding - Nov 8, 2023 6:00 PM saving.. () Run [EDIIEAVAN ...
o -} fetchWeather > g = 5
fetchWeather » Run >
h RESTQuery (restapi)
p GET https://api.open-meteo.com/vl/forecast?
v latitude=37.616&Llongitude=-122.3833&current_we
ather=true&temperature_unit=fahrenheit
— More options This workflow fetches the.C}.lrrent weather and
uses Al to suggest an activity.
@ URL parameters Press the P> play button to fetch the weather in San Francisco.
latitude 37.616 X &3 Scroll to your right to see the set up Referer
P Press play button in each block sequentially This fetches the data from the Open-Meteo API. using f
longitude -122.3833 X
current_weather true “ ¢ startTrigger = - @ - 1} fetchWeather = - @ » - O get!
temperature_unit fahrenheit X i |
Enabled triggers ' RESTQuery (restapi)
ey value X |
No triggers enablec | GET https://api 1 ¢
Headers | ps://api.open- 2
o | meteo.com/vl/forecast?
cey value X Edit triggers | latitude=37.616&Longitude=-122.3833&cu i
| rrent_weather=true&temperature_unit=fa
Inputs Data JSON Settings [] Test JSON Parameters | hrenheit
: - —_ | Inputs
object = @ {"webhookParaml1": "value"} | + More options 4
latitude 37.626106 | .
. | Inputs Data JSON Settings [v]
longitude -122.40018
generationtime_ms 0.06306171417236328
vtc_offset_seconds 0
timezone GMT
timezone_abbreviation GMT
elevation 10
current_weather_units {"time":"iso8601","interval”:"seconds","temp
erature":"°F","windspeed":"km/h", "winddirect
ion":"°", "is_day":"","weathercode":"wmo
code"}
current_weather {"time":"2023-11-
08710:00", "interval":900, "temperature":50.5,
(?) "windspeed":10.2,"winddirection":302,"is_day
- ":0,"weathercode":0}
:@ - 100% + O3 % ¢ X B2 jiul
® production O Run history
|= (] Jane Smith - Al Onboarding - Nov 8, 2023 6:00 PM saving.. () Run (DI ...
(o) L7 fetchWeather o8 e N
fetchWeather » Run > -
RESTQuery (restapi)
F
GET https://api.open-meteo.com/v1l/forecast?
& latitude=37.616&Llongitude=-122.3833&current_we
ather=true&temperature_unit=fahrenheit
— More options This workflow fetches the.c}.lrrent weather and
uses Al to suggest an activity.
'@ URL parameters Press the P> play button to fetch the weather in San Francisco.
latitude 37.616 X &3 Scroll to your right to see the set up Referer
P Press play button in each block sequentially This fetches the data from the Open-Meteo API. using f
longitude -122.3833 X
current_weather true X ¢ startTrigger = - @ - {1 fetchWeather = + @ » O get!
temperature_unit fahrenheit X .
P Enabled triggers | Inputs Data JSON Settings Q
key value X
No triggers enabled 1 e
Headers 2
key value X Edit triggers 3or
Inputs Data JSON Settings o Test JSON Parameters
ubjGCt i= r—l; {"webhookParaml": "value"} InpUtS
latitude 37.626106
longitude -122.40018
generationtime_ms 0.06306171417236328
vtc_offset_seconds 0
timezone GMT
timezone_abbreviation GMT
elevation 10
current_weather_units {"time":"iso8601","interval”:"seconds","temp
erature":"°F","windspeed":"km/h", "winddirect
ion":"°", "is_day":"","weathercode":"wmo
code"}
current_weather {"time":"2023-11-
08T10:80", "interval":900, "temperature":50.5,
@ "windspeed":10.2,"winddirection":302,"is_day
":0,"weathercode":0}
:@ - 100% + (3 % ¢ X B2 ]
® production O Run history
|-_ b Jane Smith - Al Onboarding - Nov 8, 2023 6:00 PM Latest version deployed ~ (®) Run Deploy v
® 8 s
@ This workflow fetches the current weather and '+ Retool Al Actions '
uses Al to suggest an activity.
O Press the P> play button to fetch the weather in San Francisco. Use Retool Al to sugg
&3 Scroll to your right to see the set up Reference the results of the previous block by Reference the previot
P Press play button in each block sequentially This fetches the data from the Open-Meteo API. using fetchWeather directly in code. 5
¢ startTrigger = - @ - {} fetchWeather = - @ » - getWeather = - o » - ¢ generateActivities
Enabled triggers RESTQuery (restapi) JavaScript Retool Al
No triggers enabled GET https://api.open- ; const weatherData = fetchWeather.data Action
meteo.com/vl/forecast?
Edit triggers latitude=37.6168longitude=-122.3833&cu 3 return weatherData.current_weather Cenerate text
rrent_weather=true&temperature_unit=fa Examples: Product desci
Test JSON Parameters hrenheit
. Inputs Settings o Input
{"webhookParaml": value"} + More opt|ons 1 What's a good
Explain your r
Inputs Settings o 2
3 Weather:
4 {{getWeather.c
Use Retool Vector:
Model
& gpt-4
Inputs
®
:@—100%*[] % ¢ X B3 jiul
® production O Run history