Searching cells

screenKeywords:
-—_ 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 comp mobbin 2/2 ~ ~ X  payment_. v A plan v |+
1 51 account_jsmobbin1 | JMobbin I Nov 01, 2023 5:00:00 PM NULL NULL
2 33 account_998 Comcast Jan 20, 2023 7:55:00 AM Credit Pro
3 4 account_991 Dropbox Jan 30, 2023 8:23:00 AM Credit Basic
4 42 account_984 Bumble Jan 24,2023 9:10:00 AM Invoice Enterprise
5 44 account_961 Nike Jan 08, 2023 5:50:00 PM Invoice Basic
6 30 account_954 Target Jan 15,2023 10:32:00 PM Invoice Basic
7 11 account_945 Progressive Jan 18,2023 7:26:00 AM Invoice Basic
8 28 account_940 Palentir Technologies Jan 04, 2023 9:53:00 PM Invoice Basic
9 49 account_885 Oracle Jan 04, 2023 4:46:00 AM Credit Basic
10 38 account_849 Procter & Gamble Jan 15,2023 9:42:00 AM Credit Enterprise
11 41 account_805 CVS Health Jan 13,2023 5:26:00 AM Invoice Pro
12 15 account_789 JP Morgan Chase Jan 01, 2023 1:31:00 PM Credit Enterprise
13 39 account_781 Nike Jan 03,2023 10:47:00 PM Invoice Pro
14 45 account_778 Comcast Jan 02, 2023 8:35:00 AM Credit Basic
15 43 account_766 Brex Jan 23,2023 12:29:00 PM Debit Pro
16 34 account_748 Gamestop Jan 05, 2023 10:41:00 AM Debit Pro
17 37 account_740 General Motors Jan 31,2023 2:58:00 AM Invoice Basic
18 32 account_733 Target Jan 13,2023 12:35:00 PM Debit Pro
19 50 account_713 Salesforce Jan 11,2023 4:36:00 AM Credit Enterprise
20 29 account_704 Uber Jan 17,2023 5:38:00 AM Invoice Pro
21 10 account_69 Procter & Gamble Jan 21,2023 12:58:00 AM Invoice Enterprise
|-—_ 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 comp Find in view A~ v X payment_.. v A plan v |+
1 51 account_jsmobbin1 JMobbin Nov 01, 2023 5:00:00 PM NULL NULL
2 33 account_998 Comcast Jan 20, 2023 7:55:00 AM Credit Pro
3 4 account_991 Dropbox Jan 30, 2023 8:23:00 AM Credit Basic
4 42 account_984 Bumble Jan 24,2023 9:10:00 AM Invoice Enterprise
5 44 account_961 Nike Jan 08, 2023 5:50:00 PM Invoice Basic
6 30 account_954 Target Jan 15,2023 10:32:00 PM Invoice Basic
7 11 account_945 Progressive Jan 18,2023 7:26:00 AM Invoice Basic
8 28 account_940 Palentir Technologies Jan 04, 2023 9:53:00 PM Invoice Basic
9 49 account_885 Oracle Jan 04, 2023 4:46:00 AM Credit Basic
10 38 account_849 Procter & Gamble Jan 15,2023 9:42:00 AM Credit Enterprise
11 41 account_805 CVS Health Jan 13,2023 5:26:00 AM Invoice Pro
12 15 account_789 JP Morgan Chase Jan 01, 2023 1:31:00 PM Credit Enterprise
13 39 account_781 Nike Jan 03,2023 10:47:00 PM Invoice Pro
14 45 account_778 Comcast Jan 02, 2023 8:35:00 AM Credit Basic
15 43 account_766 Brex Jan 23,2023 12:29:00 PM Debit Pro
16 34 account_748 Gamestop Jan 05, 2023 10:41:00 AM Debit Pro
17 37 account_740 General Motors Jan 31,2023 2:58:00 AM Invoice Basic
18 32 account_733 Target Jan 13,2023 12:35:00 PM Debit Pro
19 50 account_713 Salesforce Jan 11,2023 4:36:00 AM Credit Enterprise
20 29 account_704 Uber Jan 17,2023 5:38:00 AM Invoice Pro
21 10 account_69 Procter & Gamble Jan 21,2023 12:58:00 AM Invoice Enterprise
|-—_ 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 33 account_998 Comcast Jan 20, 2023 7:55:00 AM Credit Pro
3 4 account_991 Dropbox Jan 30, 2023 8:23:00 AM Credit Basic
4 42 account_984 Bumble Jan 24,2023 9:10:00 AM Invoice Enterprise
5 44 account_961 Nike Jan 08, 2023 5:50:00 PM Invoice Basic
6 30 account_954 Target Jan 15,2023 10:32:00 PM Invoice Basic
7 11 account_945 Progressive Jan 18,2023 7:26:00 AM Invoice Basic
8 28 account_940 Palentir Technologies Jan 04, 2023 9:53:00 PM Invoice Basic
9 49 account_885 Oracle Jan 04, 2023 4:46:00 AM Credit Basic
10 38 account_849 Procter & Gamble Jan 15,2023 9:42:00 AM Credit Enterprise
11 41 account_805 CVS Health Jan 13,2023 5:26:00 AM Invoice Pro
12 15 account_789 JP Morgan Chase Jan 01, 2023 1:31:00 PM Credit Enterprise
13 39 account_781 Nike Jan 03,2023 10:47:00 PM Invoice Pro
14 45 account_778 Comcast Jan 02, 2023 8:35:00 AM Credit Basic
15 43 account_766 Brex Jan 23,2023 12:29:00 PM Debit Pro
16 34 account_748 Gamestop Jan 05, 2023 10:41:00 AM Debit Pro
17 37 account_740 General Motors Jan 31,2023 2:58:00 AM Invoice Basic
18 32 account_733 Target Jan 13,2023 12:35:00 PM Debit Pro
19 50 account_713 Salesforce Jan 11,2023 4:36:00 AM Credit Enterprise
20 29 account_704 Uber Jan 17,2023 5:38:00 AM Invoice Pro
21 10 account_69 Procter & Gamble Jan 21,2023 12:58:00 AM Invoice Enterprise


Home

appName: Retool

appCategory: Developer Tools

appTagline: The best way to develop effective software

companyHqRegion: US & Canada

companyStage: Growth Stage

platform: web

pageType: Application

hotspotType: Click

screenPatterns:
Home
Feature Info

screenElements:
Top Navigation Bar
Logo
Card
Banner
Floating Action Button
Stacked List

screenPatterns:
Multi-Column Layout
Home
Feature Info
Empty State
Bookmarks & Collections

pageType: Application Application Application Application Application Application

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 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 Apps Resources Database  QueryLibrary = Workflows Upgrade [KORENEREN
Workiows
Current usage period: Nov 01 to Dec 01
Bandwidth used Total workflow runs Active workflows
0B 0 0
|-—_ 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.
M View documentation
a% Ask Retool Developers
A" B Email support
@ Submit feedback
All  Recent Starred Modules Folders Trash o Report abuse
Name v Updated Last Editor What's new?
Component reference
(mm] [Sample App] Users Dashboard a minute ago Jane Smith
DS Admin Module 2 hours ago Jane Smith
El Fowl x Pottery 2 hours 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
|-—_ Resources / Retool Database Feedback? e
= transactions v +
Add row Import CSV v @ Fields Y/ Filters { Sort 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 1 account_63 MetLife Jan 13,2023 12:02:00 AM Credit Pro
2 2 account_267 FedEx Jan 15, 2023 5:00:00 PM Invoice Basic
3 3 account_458 Cisco Systems Jan 08, 2023 8:02:00 PM Invoice Pro
4 4 account_991 Dropbox Jan 30, 2023 8:23:00 AM Credit Basic
5 5 account_241 General Electric Jan 21, 2023 12:16:00 AM Invoice Enterprise
6 6 account_682 Gong Jan 02, 2023 4:02:00 PM Debit Basic
7 7 account_175 Stripe Jan 06, 2023 5:01:00 AM Invoice Pro
8 8 account_676 Home Depot Jan 05, 2023 8:25:00 AM Credit Pro
9 9 account_615 Goldman Sachs Group Jan 07,2023 2:07:00 AM Credit Pro
10 10 account_69 Procter & Gamble Jan 21,2023 12:58:00 AM Invoice Enterprise
11 1 account_945 Progressive 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


Adding a chart component

hotspotType: Drag

hotspotType: Hover

screenPatterns: Charts Charts

pageType: Application Application Application Application Application Application Application

screenKeywords:
- . .
a B JMobbin Admin QB m
@ Components Modules 57 <«
4 chart1 Q e X »
. .
Q search compnents JMobbin Admin
I'_"Y ~ Content
Commonly used
4 Ul Form Plotly JSON
New i ID Name Email Blocked
{i} m Data source FX
1 Hershel McV... etexton2d@.. v . R .
Table Text Button regron” : "bastt,
- . "sales": 3700
O] 2 Gayel Coton ekeitley3v@... v nspend": 4600
= oA
av l; #* I 4 ' .
@ " 3 Imogene Sch... ckiddey64@... v "region" : "West",
"sales": AAAA.
Text Input Number Select 4 Anita Oliver tmordy6l@m... v
Input Chart type % Piechart
5 Costa Spata kesposilc@... v
A B Value labels  rx  region
- 6 Catharina M...  uqueree69@... v
Datasets
Container Form Tabbed
Container 7 Booth Macg... sloache34@... . sales cum
& A e n . N
Il D 50 results Yy &4 5 @ spend sum XD
[ ] 1
Modal Chart Key Value
-~ Interaction
Unblock user v
A BC Ul Form Plotly JSON
O O
Image Navigation Title Title
Legend position
Text inputs
- B E3 hd -
2B 30.9% I I
T ST 4 S Event handlers +
Editable Text Editable Text ~ Email Trigger queries, control components, or call
Area 19% other APIs in response to component events.
BIu”
{3
1 poel I - Appearance =
JSON Editor  Password Rich Text Hidden false
Editor B West Central M South [ East
DN O O
- I av l; ®—I
<> — 100%
Text Area Text Input URL
© Latest No queries running & wDebug O @
|- . .
a B JMobbin Admin QB m
@ Components Modules 57 <«
4 chart1 Q e X »
. .
Q searchcomponents JMobbin Admin
I'_"Y ~ Content
Commonly used
4 Ul Form Plotly JSON
New i ID Name Email Blocked
{i} m Data source FX
1 Hershel McV... etexton2d@.. v . R .
Table Text Button regron” : "bastt,
. "sales": 3700
O] 2 Gayel Coton ekeitley3v@... v nspend": 4600
= oA
av l; #* I 4 ' .
@ " 3 Imogene Sch... ckiddey64@... v "region" : "West",
"sales": AAAA.
Text Input Number Select 4 Anita Oliver tmordy6l@m... v
Input Chart type +2° Scatterplot
5 Costa Spata kesposilc@... v
A B X-axis values Fx region
- 6 Catharina M...  uqueree69@... v
Container Form Tabbed Group by FX | Selecta value
Container 7 Booth Macq... sloache34@...
~ [ T N R P ) - Datasets Add new
50 results v sales sum
- 1 ES Y & 05 e
Modal Chart Key Value . spend sum
Unblock user v
°
ABC =
—
A Lo o Interaction
Image Navigation Ul Form Plotly JSON
6000 °
Text inputs . Title Title
° X-axis title
T ST K4 S —I 5000
. X-axis tick
Editable Text Editable Text Email
Area o .
4000 ° . X-axis type Default
BIU” .
% Pl I Y-axis title
I East West South Central
JSON Editor  Password  Rich Text Y-axis tick
Editor ® sales ® spend
Legend position
| =0 &= ' i L .
> — 100% - .
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 @
|- . .
a B JMobbin Admin QB m
@ Components Modules 57 <«
4 chart1 Q e X »
. .
Q searchcomponents JMobbin Admin
I'_"Y ~ Content
Commonly used
4 Ul Form Plotly JSON
New i ID Name Email Blocked
{i} m Data source FX
1 Hershel McV... etexton2d@.. v . R .
Table Text Button regron” : "bastt,
. "sales": 3700
O] 2 Gayel Coton ekeitley3v@... v nspend": 4600
= oA
& T—I #—1 — 3 Imogene Sch... ckiddey64@... v '"region" : "West",
"sales": AAAA.
Text Input Number Select 4 Anita Oliver tmordy6l@m... v
Input Chart type «* Line chart
5 Costa Spata kesposilc@... v
A B X-axis values Fx region
- 6 Catharina M...  uqueree69@... v
Container Form Tabbed Group by FX | Selecta value
Container 7 Booth Macg... sloache34@...
~ [ T N R P ) - Datasets Add new
50 results v sales sum
- 1 ES Y & 05 e
Modal Chart Key Value . spend sum
Unblock user v
°
ABC =
—
A Lo o Interaction
Image Navigation Ul Form Plotly JSON
6000
Text inputs Title Title
X-axis title
T ST K4 S —I 5000
X-axis tick
Editable Text Editable Text Email
A .
rea 4000 X-axis type Default
BIu”
% Pl I Y-axis title
I East West South Central
JSON Editor  Password  Rich Text Y-axis tick
Editor —e&— sales —e— spend
Legend position
| =0 &= ' i L .
& — 100% - .
Text Area Text Input URL
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ Components Modules 57 <«
chart1 Q e X »
. .
1y JMobbin Admin
\g Content
Commonly used
<2 Ul Form Plotly JSON
New i ID Name Email Blocked
{i} m Data source FX
1 Hershel McV... etexton2d@.. v . R .
Table Text Button regron” : "bastt,
. "sales": 3700
O] 2 Gayel Coton ekeitley3v@... v wspend": 4600
I I = , oA
@ —_— 3 Imogene Sch... ckiddey64@... v "region" : "West",
"sales": AQAA.
Text Input Number Select 4 Anita Oliver tmordy6l@m... v
Input Chart type |y Barchart
5 Costa Spata kesposilc@... v
bt X-axis values |yl Barchart
- 6 Catharina M...  uqueree69@... v
#* Line chart
Container Form Tabbed Group by =
Container 7 Booth Macq... sloache34@...
Datasets +%° Scatterplot
Il D 50 results Y &L O @ sales 2 Pie chart
[ ] 1
Modal Chart Key Value . spend sum
Unblock user v
D
ABC =
:
A Lo o Interaction
Image  Navigation Ul Form Plotly JSON
6000
Text inputs Title Title
4000 X-axis title
I
X-axis tick
Editable Text Editable Text Email 2000
Area X-axis type Default
BIu”
I 0 Y-axis title
I
I East West South Central
JSON Editor  Password  Rich Text Y-axis tick
Editor MW sales M spend
Legend position
I I I - 7 I T L 5| -
<> — 100% _ . = .
Text Area Text Input URL
© Latest No queries running & wDebug O @
|- . .
a B JMobbin Admin QB m
@ Components Modules 57 <«
4 chart1 Q e X »
. .
Q search compnents JMobbin Admin
I'_"Y Content
Commonly used
4 Ul Form Plotly JSON
New i ID Name Email Blocked
{i} m Data source FX
1 Hershel McV... etexton2d@.. v . R .
Table Text Button regron” : "bastt,
- . "sales": 3700
O] 2 Gayel Coton ekeitley3v@... v nspend": 4600
= oA
9y =i # —1 i ! .
@ " 3 Imogene Sch... ckiddey64@... v "region" : "West",
"sales": AAAA.
Text Input Number Select 4 Anita Oliver tmordy6l@m... v
5 Costa Spata kesposilc@... v
A B Value labels  rx  region
- 6 Catharina M...  uqueree69@... v
Datasets
Container Form Tabbed
Container 7 Booth Macg... sloache34@... . sales cum
PR TUPS bt ataaan . N
Il D 50 results Yy L O @ spend sum &
[ ] 1
Modal Chart Key Value
Interaction
Unblock user v
A BC Ul Form Plotly JSON
O O
Image Navigation Title Title
Legend position
Text inputs West
- B E3 hd -
2B 30.9% - 6000 : :
» , 30.9%
T s|T s S - Event handlers +
Editable Text Editable Text Email Trigger queries, control components, or call
Area 19% other APIs in response to component events.
BIu”
{3
I Ll I Appearance =
JSON Editor  Password Rich Text Hidden false
Editor B West Central M South [ East
DN O O
= I 9y =i I
<> — 100%
Text Area Text Input URL
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ Components Modules 57 <«
chart1 Q e X »
. .
1y JMobbin Admin
\g Content
Commonly used
<2 Ul Form Plotly JSON
New i ID Name Email Blocked
{i} m Data source FX
1 Hershel McV... etexton2d@.. v . R .
Table Text Button regron” : "bastt,
. "sales": 3700
O] 2 Gayel Coton ekeitley3v@... v wspend": 4600
I I = , oA
@ —_— 3 Imogene Sch... ckiddey64@... v "region" : "West",
"sales": AQAA.
Text Input Number Select 4 Anita Oliver tmordy6l@m... v
Input Chart type |y Barchart
5 Costa Spata kesposilc@... v
A B X-axis values region
- 6 Catharina M...  uqueree69@... v
Container Form Tabbed Group by Select a value
Container 7 Booth Macg... sloache34@...
~ [ T N R P ) - Da‘asets Add new
50 results v sales sum
IESHE == T e .
Modal Chart Key Value . spend sum
Unblock user v
D
ABC =
:
A Lo o Interaction
Image Navigation Ul Form Plotly JSON
6000
Text inputs Title Title
4000 X-axis title
I
X-axis tick
Editable Text Editable Text Email 2000
Area X-axis type Default
BIu”
I 0 Y-axis title
I
I East West South Central
JSON Editor  Password  Rich Text Y-axis tick
Editor MW sales M spend
Legend position
I I I - 7 I T L 5| -
& — 100% - .
Text Area Text Input URL
© Latest No queries running & wDebug O @


Adding a key value component

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

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 QB m
@ Components Modules 57 <«
5 keyValue1 Q e X »
. .
Q searchcomponents JMobbin Admin
I'_"Y Content
Commonly used
4 Data
L"ﬂj! i ID Name Email Blocked K
{i} 1 Hershel McV... etexton2d@... v :::: ;'
Table Text Button "c": 3'
) 2 Gayel Coton ekeitley3v@... v ' .
T—I) |[#—TI — 3 Imogene Sch... ckiddey64@... v
@ Ha
Text Input Number Select 4 Anita Oliver tmordy6l@m... v
Input Eﬂ b
5 Costa Spata kesposilc@... v Be
A B
- 6 CatharinaM... uqueree69@... Key title Key
Container Form Tabbed B
Container 7 Booth Macg... sloache34@... Value title Value
||| D 50 results Y &L O Appearance =
[ ]
Modal Chart Key Value Hidden false
Unblock user v
[ mme [ +
None
O O
Image Navigation Key Value
Text inputs a 1
b 2
5 5 =
T K4 T K4 S —I c 3
Editable Text Editable Text Email
Area
BIu”
{3
I I I O O
JSON Editor  Password Rich Text
Editor
| IE=D R=T
<> — 100%
Text Area Text Input URL
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ Components Modules 57 <«
keyValue1 Q e X »
. .
1y JMobbin Admin
\g Content
Commonly used
<2 Data
LNe\]' . ID Name Email Blocked <
{i} 1 Hershel McV... etexton2d@... v :::: 2'
Table Text Button "C": 3'
) 2 Gayel Coton ekeitley3v@... v ' .
& I I — 3 Imogene Sch... ckiddey64@... v
a
Text Input Number Select 4 Anita Oliver tmordy6l@m... v
Input b
5 Costa Spata kesposilc@... v c
A B
- 6 CatharinaM... uqueree69@... Key title Key
Container Form Tabbed A
Container 7 Booth Macg... sloache34@... Value title Value
|I| D 50 results Y &L O Appearance =
[ ]
Modal Chart Key Value Hidden false
Unblock user v
[ mme [ +
O Background Default
Image Navigation Key Value
Text inputs a 1
b 2
L c 3
Editable Text Editable Text Email
Area
Bru”
I L I O O o HN 4
JSON Editor  Password Rich Text
a8 aees
] =0 &= O
<> — 100%
Text Area Text Input URL
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
5 keyValue1 Q e X »
. .
Q search compnents JMobbin Admin
I'_"Y ~ Content
Commonly used
4 Data
L"ﬂj! i ID Name Email Blocked K
{i} 1 Hershel McV... etexton2d@... v :::: i'
Table Text Button "C": 3'
) 2 Gayel Coton ekeitley3v@... v ' .
T—I) |[#—TI — 3 Imogene Sch... ckiddey64@.. v
@ Ha
Text Input Number Select 4 Anita Oliver tmordy6l@m... v
Input Eﬂ b
5 Costa Spata kesposilc@... v Be
A B
- 6 CatharinaM... uqueree69@... Key title Key
Container Form Tabbed B
Container 7 Booth Macg... sloache34@... Value title Value
||| D 50 results Y &L O - Appearance =
[ ]
Modal Chart Key Value Hidden false
Unblock user v
[ mme [ +
o Header background
Image Navigation Key Value Header foreground .
Text inputs a 1 Background
b 2 Text e
T ST K4 S —I
c 3 Border
Editable Text Editable Text Email
Area
BIu”
{3
I I I O O
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 <«
5 keyValue1 Q e X »
. .
Q searchcomponents JMobbin Admin
I'_"Y ~ Content
Commonly used
4 Data
L"ﬂj! i ID Name Email Blocked K
{i} 1 Hershel McV... etexton2d@... v :::: 2'
Table Text Button "c": 3'
) 2 Gayel Coton ekeitley3v@... v ' .
T—I) |[#—TI — 3 Imogene Sch... ckiddey64@... v
@ Ha
Text Input Number Select 4 Anita Oliver tmordy6l@m... v
Input Eﬂ b
5 Costa Spata kesposilc@... v Be
A B
- 6 CatharinaM... uqueree69@... Key title Key
Container Form Tabbed B
Container 7 Booth Macg... sloache34@... Value title Value
||| D 50 results Y &L O - Appearance =
[ ]
Modal Chart Key Value Hidden false
Unblock user v
[ mme [ >+
° Background () #017823 100% X
Text inputs
T ST K4 S —I
Editable Text Editable Text Email
Area
BIu”
{3
I I I O O
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 <«
5 keyValue1 Q e X »
. .
Q searchcomponents JMobbin Admin
I'_"Y Content
Commonly used
4 Data
L"ﬂj! i ID Name Email Blocked K
{i} 1 Hershel McV... etexton2d@... v :::: 2'
Table Text Button "c": 3'
) 2 Gayel Coton ekeitley3v@... v ' .
T—I) |[#—TI — 3 Imogene Sch... ckiddey64@... v
@ Ha
Text Input Number Select 4 Anita Oliver tmordy6l@m... v
Input Eﬂ b
5 Costa Spata kesposilc@... v Be
A B
- 6 CatharinaM... uqueree69@... Key title Key
Container Form Tabbed B
Container 7 Booth Macg... sloache34@... Value title Value
||| D 50 results Y &L O Appearance =
[ ]
Modal Chart Key Value Hidden false
Unblock user v
[ mme [ >+
° Background () #017823 100%
Text inputs
T ST K4 S —I
Editable Text Editable Text Email
Area
BIu”
{3
I
I L I O O
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 <«
5 keyValue1 Q e X »
. .
Q searchcomponents JMobbin Admin
I'_"Y Content
Commonly used
4 Data
L"ﬂj! i ID Name Email Blocked K
{i} 1 Hershel McV... etexton2d@... v :::: ;'
Table Text Button "c": 3'
) 2 Gayel Coton ekeitley3v@... v ' .
T—I) |[#—TI — 3 Imogene Sch... ckiddey64@... v
@ Ha
Text Input Number Select 4 Anita Oliver tmordy6l@m... v
Input Eﬂ b
5 Costa Spata kesposilc@... v Be
A B
- 6 CatharinaM... uqueree69@... Key title Key
Container Form Tabbed B
Container 7 Booth Macg... sloache34@... Value title Value
||| D 50 results Y &L O Appearance =
[ ]
Modal Chart Key Value Hidden false
Unblock user v
[ mme [ +
o Background
Image Navigation Key Value
Text inputs a 1
b 2
5 5 =
T K4 T K4 S —I c 3
Editable Text Editable Text Email
Area
BIu”
{3
I I I O O
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 <«
5 keyValue1 Q e X »
. .
Q searchcomponents JMobbin Admin
I'_"Y ~ Content
Commonly used
4 Data
L"ﬂj! i ID Name Email Blocked K
{i} 1 Hershel McV... etexton2d@... v :::: ;'
Table Text Button "c": 3'
) 2 Gayel Coton ekeitley3v@... v ' .
T—I) |[#—TI — 3 Imogene Sch... ckiddey64@... v
@ Ha
Text Input Number Select 4 Anita Oliver tmordy6l@m... v
Input Eﬂ b
5 Costa Spata kesposilc@... v Be
A B
- 6 CatharinaM... uqueree69@... Key title Key
Container Form Tabbed B
Container 7 Booth Macg... sloache34@... Value title Value
||| D 50 results Y &L O - Appearance =
[ ]
Modal Chart Key Value Hidden false
Unblock user v
[ mme [ +
O Background Customize X
Image Navigation Key Value
Text inputs a 1
b 2
5 5 =
T K4 T K4 S —I c 3
Editable Text Editable Text Email
Area
BIu”
{3
I I I O O
JSON Editor  Password Rich Text
Editor
| IE=D R=T
<> — 100%
Text Area Text Input URL
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ Components Modules 57 <«
keyValue1 Q e X »
JMobbin Admin
I;? Content
Commonly used
<2 Data
LNe\]' i ID Name Email Blocked K
{i} 1 Hershel McV... etexton2d@... v :::: 2'
Table Text Button "C": 3'
) 2 Gayel Coton ekeitley3v@... v ' .
& I I — 3 Imogene Sch... ckiddey64@... v
a
Text Input Number Select 4 Anita Oliver tmordy6l@m... v
Input b
5 Costa Spata kesposilc@... v c
A B
- 6 CatharinaM... uqueree69@... Key title Key
Container Form Tabbed A
Container 7 Booth Macg... sloache34@... Value title Value
|I| D 50 results Y &L O Appearance =
[ ]
Modal Chart Key Value Hidden false
Unblock user v
[ mme [ >+
° Background () #017823 100%
Image Navigation Key Value
Text inputs
I
Editable Text Editable Text Email
Area
BIu”
I
I I O O @e)
. . E——____ (
JSON Editor  Password Rich Text e
a8 aees
] =0 &= O
<> — 100%
Text Area Text Input URL
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
5 keyValue1 Q e X »
. .
Q searchcomponents JMobbin Admin
I'_"Y Content
Commonly used
4 Data
L"ﬂj! i ID Name Email Blocked K
{i} 1 Hershel McV... etexton2d@... v :::: ;'
Table Text Button "c": 3'
) 2 Gayel Coton ekeitley3v@... v ' .
T—I) |[#—TI — 3 Imogene Sch... ckiddey64@... v
@ Ha
Text Input Number Select 4 Anita Oliver tmordy6l@m... v
Input Eﬂ b
5 Costa Spata kesposilc@... v Be
A B
- 6 CatharinaM... uqueree69@... Key title Key
Container Form Tabbed B
Container 7 Booth Macg... sloache34@... Value title Value
||| D 50 results Y &L O Appearance =
[ ]
Modal Chart Key Value Hidden false
Unblock user v
[ mme [ +
O Background Default
Image Navigation Key Value
Text inputs a 1
b 2
5 5 =
T K4 T K4 S —I c 3
Editable Text Editable Text Email
Area
BIu”
{3
I I I O O
JSON Editor  Password Rich Text
Editor
| IE=D R=T
<> — 100%
Text Area Text Input URL
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ Components Modules 57 <«
keyValue1 Q e X »
JMobbin Admin
I;? Content
Commonly used
<2 Data
L"ﬂjf i ID Name Email Blocked K
{i} 1 Hershel McV... etexton2d@... v :::: ;'
Table Text Button "C": 3'
) 2 Gayel Coton ekeitley3v@... v ' .
& T—I) |[#—TI — 3 Imogene Sch... ckiddey64@.. v
a
Text Input Number Select 4 Anita Oliver tmordy6l@m... v
Input b
5 Costa Spata kesposilc@... v c
A B
- 6 CatharinaM... uqueree69@... Key title Key
Container Form Tabbed B
Container 7 Booth Macq... sloache34@... Value title Value
|I| D 50 results Y &L O Appearance
L Reset all styles. To reset an individual
Modal Chart Key Value Hidden style, click the X next to the style.
Unblock user v
[ mme [ o+
° Background () #017823 100%
Image Navigation Key Value
Text inputs
T ST K4 S —I
Editable Text Editable Text Email
Area
BIu”
{3
I I I O O
JSON Editor  Password Rich Text
Editor
| IE=D R=T
<> — 100%
Text Area Text Input URL
© Latest No queries running & wDebug O @


Workflows

pageType: Marketing

hotspotType: Scroll Vertically

screenElements:
Progress Indicator
Top Navigation Bar

pagePatterns:
Features Page
CTA Section
Features Page
Features Page
Social Proof (Logo Cloud) Section
Social Proof (Testimonial) Section

pageType: Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing

screenKeywords:
-_ Retool Products v  Enterprise Integrations Pricing Docs Book a demo
Workflows features
Building blocks that stand up to
professional development
Safe and secure data access Professional-level debugging
Need to tunnel into your VPC, query an on-prem database, or Pop out the debug console to explore logs down to the block
tackle odd authentication methods? Unlike most automation level. Step into historical run data to pinpoint exactly where errors
tools, Workflows can handle it. occur.
Run history & =  Blocks = Logs
[ ] —_
' )‘0‘2 @ ...:.' . X < Running. .. @ Global (all blocks) Starting run for workf
4h © 1 minute ago ¢ starttrigger --- Running query: sta
A @ 12/15/2023 2:00 PM W getcustomers @ --- Successfully fit
. stripe M O % @ ‘ l @ filterList --- Running query: get
Enterprise-ready Custom error handling & automatic retries
Full audit logs, source control, dev and prod environments, per- Get notified in tools like Slack, PagerDuty, or email for every
user and per-workflow run and edit permissions, secrets pause, failure, or exception. Define contingency paths at each
management with AWS and Hashicorp Vault, and more. step with per-block error handling. Maintain resiliency with
automated retries and exponential backoffs.
o
PR, " const weatherData = fetchWeather.data 6‘)
|-_ Retool Products v  Enterprise Integrations Pricing Docs Book a demo Start for free
Required parameter char Retry 2 times with an interval of 1000ms, 2000ms
No-fuss scalable infrastructure Reusable and composable
Forget the scaffolding. Workflows gives you a highly scalable Create reusable groups of logic by calling workflows from other
execution engine with built-in support for long running jobs. Self- workflows, and document your process with notes in Markdown.
host Workflows within your own VPC to keep your data in your
network.
-~ B e
. 88 groupl - B e
Feature Flag Expiration Undeployed changes @ Run avaScript Python o
ier.data F getCustomerData Edit 7
H & 0 @«
Work visually or in code -
== D ETL Workflow
Dock the editor for a fullscreen code
editing experience, edit directly in W sourceDb @ processData X W destinationDb @ » Run
the DAG, or use split screen for the
Javascript Python .
best of both worlds. Workflows & Trigger
adapts to your preferred style of 1 const sanitizedRecords = []
d | t 2 const sensitiveFields = ['first_name', 'last_name', 'email']
evelopment. 5 for (const record of sourceDb.data) { W sourceDB ©
4 const cleanedRecord = {...record}
5 for (const sensitiveData of sensitiveFields) {
6 cleanedRecord[sensitiveData] = sanitize(record[sensitiveData])
7 } s processData @
8 sanitizedRecords.push (cleanedRecord)
9 }
10 return sanitizedRecords {
| W destinationDb o
|-_ Retool Products v  Enterprise Integrations Pricing Docs Book a demo Start for free
Workflows use cases
Automation for any team
Turn one off scripts, manual tasks, and brittle integrations into
repeatable processes across your org.
Support  Product Engineering  Operations
Ticket routing & assignment getTickets >
Build support systems bespoke to your business, and your team. Intercom (restapi) v
Stack rank issue severity, ticket age, and customer segment © GET v https://api.intercon.con/con
alongside your team’s topic knowledge, current workload, and
i . . Output JSON Log @ AccountTriage >
calendar availability to create custom impact assessments. — )
type id createrd at nnda
Conversation 7436457 9/22/ @ createLinearTicket 4
Email 2436328 9/21/ :
Browse template gallery -» Conversation 1923933 o/21) © Linear (raphal) v
1 mutation IssueCreate($title: String,
2 $description: String) {
3 issuveCreate {
|-
- Retool Products v  Enterprise Integrations Pricing Docs Book a demo Start for free
How it works
Query data using dozens of built-in connectors: databases, third-party
services, and anything with a REST, GraphQL or gRPC API. Workflows
even has native integrations with OpenAl models, so you can start
leveraging generative Al with zero config.
@ semmeme ) W) getOrders @ seizeo=D 7 newOrders » -:-----"2 ¢ Branch » D
v ordersDb (postgresq|) v sqL GUI é Filter expression If :
: moment (order.created_at) neworders.data. length > @ b
v 1 SELECT * .isAfter(moment().subtract(1, "day"))) N
2 FROM orders H
- 3 WHERE status = 'placed’ E it Addlbranch
; @ Success: 32 records returned E
name location status I‘\Q
*> ¥ ordersToEscalate » 2 @ sortedOrders »
Darlene Robertson Coppell, Virginia placed
Cameron Williams.. Portland, Illino.. placed Filter expression Query JSON with SQL v
Ronald Richards Syracuse, Connec.. placed moment (order. created_at)
Eleanor Pena Corona, Michigan placed .isBefore(moment().subtract(1, "day")) 1 SELECT *
Leslie Alexander Great Falls, Mar.. placed 2 FROM {{ordersToEscalate.data}}
3 ORDER BY charge_total DESC
|-_ Retool Products v  Enterprise Integrations Pricing Docs Book a demo Start for free
Put Al to work in any of your
- - - - -
automations with built-in Al Actions
Integrate with any LLM out of the box, token
‘ getDocuments - =3 s
costs on us. Get native support for OpenAl,
Anthropic, Azure, and more for free. Or, bring
your own model and API keys. 3% getletadata =
) Combine - 2 e
== ® A\
1 const docs = {{ getDocuments }} .
Use dozens of pre-built Al actions as steps in § const metadata = {{ getMetadata }}
your automated processes. Summarize text, ; return docs.map(d = ({
q q q n doc: d.data,
describe images, or classify requests in one <7> netadata: metadata.data & Retoot 41 o
click. )
Summarize text v
Summarize each document:
{{ combine.data }}
Power intelligent Al chatbots, trained on your
business data. Create vector embeddings in Model
seconds with no additional infrastructure G cpT4 v
required.
Learn more about Retool Al »
|-_ Retool Products v  Enterprise Integrations Pricing Docs Book a demo

Retool Workflows

Workflow automation built

Every Retool plan comes with full access to automation use cases of all

kinds - first 500 monthly runs are on us.

Start for free - Book ademo -

-_ Retool Use Cases Integrations Developers Resources Company
Admin panels PostgreSQL Changelog Contact Support About
Firebase GUI MySQL Documentation Community home Customers
MongoDB GUI DynamoDB Status Support forum Careers
GraphQL GUI Firebase Self-hosted deployment  Join our Discord Blog
Dashboards GraphQL APl Generator Show & Tell
SQL GUI Amazon S3 RegEx Generator Retool for startups
React components Google Sheets Developer utilities State of Al Report m
Google Sheets GUI MongoDB Developer network Internal tools report
Customer support Engineering time report
|-
- Retool Products v  Enterprise Integrations Pricing Docs Book a demo Start for free
How it works
Define
Workflows are composed of a series of blocks: interconnected queries
or JavaScript. Start by choosing how you want your workflow to run,
either on a cron schedule or triggered via an API call or webhook.
© Trigger @ seomeme ) getOrders » rioooo20 Y newOrders [ 3 CErh) I
Timezone Local (GMT+3) v ordersDb (postgresq|) v sQL GUI i Filter expression I
: moment (order.created_at)
Run every Day v 1 SELECT x* : .isAfter(moment().subtract(1, "day")))
2 FROM orders H
at 12:00 AM v 3 WHERE status = 'placed’ :
Runs at 12:00 AM, every day i
"> % ordersToEscalate > § 2 (¢
Filter expression
moment(order.created_at)
.isBefore(moment().subtract(1, "day"))
|-
- Retool Products v  Enterprise Integrations Pricing Docs Sign in Start for free
Retool Workflows
iIsual workflow automation.
ow with code.
Try Workflows for free -» Book ademo -
CO Workflow X og > Run
£ trigger w & » ——> W getUndeliveredOrders « & v ——> [ sendEmail loop R = I
Retool Database v SQL GUI Mode GUI Code
1 select * from deliveries Iterable ¢ Retool Database v
\9 2 where % delivered = FALSE
3 AND * from delivery_date < now()
£ Retool Email v
To
warehouse@company.com
Add Cc/Bcc
Output JSON Log ©® 0O Subject
|-
- Retool Products v  Enterprise Integrations Pricing Docs Book a demo Start for free
1 select * from deliveries Iterable ¢ Retool Database v
\9 2 where % delivered = FALSE
3 AND * from delivery_date < now()
£ Retool Email v
To
warehouse@company.com
Add Cc/Bcc
Output JSON Log ©® 0O Subject
order_... vendor_... order_date deliver Undelivered order: {{ value.order_id }}
1 1 Jul 2, 2023 Jul 10,
Body Text HTML Markdown
2 3 Jul 9, 2023 Jul 14,
Order from {{ value.vendor_name }} looks
3 7 Jul 27, 2023 Jul 30, imAdAY deimmnd  mYammn simdada ama-
® Staging @ v1.0.0 All queries completed D1 ®0 [cConsole (@ Help
Run history & =  Blocks = Logs
In progress @ Global (all blocks)
© 09/15/2023 2:30 PM ¢ starttrigger
© 19/14/2023 1:00 PM W getUndeliveredOrders
® 09/14/2023 9:00 AM £ sendEmail
-
RE/MAX stripe BW | Best Wester. @ 0openAl QL eoene € EquipmentShare
From startups to enterprises, customers of all sizes trust Retool Workflows for automating business logic
|- - . . . .
- Retool Products Enterprise Integrations Pricing Docs Book demo Signin Get started
Components
Workflows
Mobile
Al Apps
a Database
\ | Portals D
Embed
Templates
a p
\ | Self-hosted = Get ademo Start for free
Workflow X og » Run
4 trigger « B » =——> W getUndeliveredOrders « B v =——> [ sendEmail loop O = I
Retool Database v SQL GUI Mode GUI Code
1 select * from deliveries Iterable W Retool Database v
2 where * delivered = FALSE
3 AND * from delivery_date < now()
£ Retool Email v
To
warehouse@company.com
Add Cc/Bcc
, Output JSON Log © 0 Subject
order_... vendor_. .. order_date deliver Undelivered order: {{ value.order_id }}
|-_ Retool Products v  Enterprise Integrations Pricing Docs Book a demo
-4 modern milkman EAST FORK RE/MAX
With Workflows, we have the flexibility of Our company is small and has very We needed an efficient way to translate
code to interact with our data exactly how we specific requirements for how we want to product data in our warehouse into timely,
want, and critically tight feedback loops to parse and display data to make decisions. insightful reporting in Slack. With Retool
build, test, and ship faster. Where rewriting a Workflows allows me to keep our internal Workflows, my team can easily configure our
script for sending customer-facing coupons data systems clean and up-to-date with resources in one place and focus only on
would have taken 3+ months, we were able to our warehouse and storefront softwares writing the logic unique to our business.
create an entirely custom process in by allowing me to write Javascript to
Workflows in just one day. easily tailor the data we need from clunky

JSON objects.
John Hughes Kyle Crowder Joel McLean
Chief Strategy Officer Data Engineer Director of Product Growth
Retool AI


Chatting with chatbox

hotspotType: Keyboard Input

pageType: Application Application Application

screenKeywords:
= O JMobbin Admin QB m
@ Components Modules 57 <«
= chat1 Q e X »
I_Y Q search components Unblock user -
\a i Content
Lo Q o
¢/® Dateandtimeinputs Placeholder Type a message
— Chat LW
i T 21 Al name Retool AL
{i} o I =
»
Jane Smith less th inut
) oo - . Js ess than a minute ago Sender name
@ TnerLtar ate ate Range hi how are you
P! {{ current_user.fullName }}
@ <> Retool Al |ess than a minute ago
e—1 31 Mar Hello! I'm an artificial intelligence and don't have Actions
feelings, but I'm here and ready to assist you.
Date Time Day Month How can | help you today? [7) Copy
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 @
|= 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 @
|= 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
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 . hi how are you| > 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 @


Editing field settings

screenKeywords:
-—_ Resources / Retool Database Feedback? e
= transactions v +
Add row Import CSV v @ Fields Y/ Filters { Sort Q Quick find & Refresh 50 records
O # id PRIMARY KEY v | A account_num. v A company v (@ transaction_date v A payment_.. v A plan v | +
1 £ Settings account_63 MetLife Jan 13,2023 12:02:00 AM Credit Pro
2 # Rename field account_267 FedEx Jan 15, 2023 5:00:00 PM Invoice Basic
3 I account_458 Cisco Systems Jan 08, 2023 8:02:00 PM Invoice Pro
-1 Insert field right
4 account_991 Dropbox Jan 30, 2023 8:23:00 AM Credit Basic
241 Sort Ascending
5 account_241 General Electric Jan 21,2023 12:16:00 AM Invoice Enterprise
12: Sort Descending
6 account_682 Gon Jan 02, 2023 4:02:00 PM Debit Basic
Y Filter by this field - 9 '
7 account_175 Stripe Jan 06, 2023 5:01:00 AM Invoice Pro
1ir Delete field
8 B account_676 Home Depot Jan 05, 2023 8:25:00 AM Credit Pro
9 9 account_615 Goldman Sachs Group Jan 07,2023 2:07:00 AM Credit Pro
10 10 account_69 Procter & Gamble Jan 21,2023 12:58:00 AM Invoice Enterprise
11 1 account_945 Progressive 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
|-—_ Resources / Retool Database Feedback? e
= transactions v ar
Add row Import CSV v @ Fields Y/ Filters { Sort Q Quick find &' Refresh 50 records
O # id PRIMARY KEY v~ = A account_num.. v A company v (@ transaction_date v A payment_.. v A plan v | +
58 38 account_say Procter & Gambple Jan 15, 2023 Y:42:00 AM Credit Enterprise
39 39 account_781 Nike Jan 03,2023 10:47:00 PM Invoice Pro
40 40 account_137 Berkshire Hathaway Jan 01, 2023 5:57:00 PM Debit Basic
41 41 account_805 CVS Health Jan 13,2023 5:26:00 AM Invoice Pro
42 42 account_984 Bumble Jan 24,2023 9:10:00 AM Invoice Enterprise
43 43 account_766 Brex Jan 23,2023 12:29:00 PM Debit Pro
44 44 account_961 Nike Jan 08, 2023 5:50:00 PM Invoice Basic
45 45 account_778 Comcast Jan 02, 2023 8:35:00 AM Credit Basic
46 46 account_248 Front Jan 26, 2023 12:27:00 AM Invoice Pro
47 47 account_453 Costco Wholesale Jan 01,2023 7:12:00 PM Debit Enterprise
48 48 account_280 Walt Disney Jan 05, 2023 8:06:00 PM Invoice Pro
49 49 account_885 Oracle Jan 04, 2023 4:46:00 AM Credit Basic
50 50 account_713 Salesforce Jan 11, 2023 4:36:00 AM Credit Enterprise
51 51 account_jsmobbin1 JMobbin Nov 01, 2023 5:00:00 PM NULL NULL
|Field name
s|
A field using snake_case will be easier to work with
when writing SQL queries.
Field type
A Text
PostgreSQL type
TEXT M
Nullable Unique
true v false v
Default value
No Default v
Cancel
|Field name

source
Field type

A Text
PostgreSQL type

TEXT v
Nullable Unique

true v false v
Default value

No Default v

Cancel
|-—_ 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
|Field name

id
Field type

4 Number
Number type

integer v
PostgreSQL type

INT4 v
Nullable Unique

false v true v
Default value

Default value v transactions_id_seq

Cancel
|Field name
Field type

A Text
PostgreSQL type

TEXT v
Nullable Unique

true v false v
Default value

No Default v

Cancel


Searching table properties

screenPatterns:
Search
Command Palette

pageType: Application Application Application Application

screenKeywords:
= B JMobbin Admin Q8 m
@ BlockTable Q e 2 »
. .
I_—? JMObbln Admln Content =
v
° 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
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
A Ml A Cesta A . 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 @
|JMobbin Ad... BlockTable »  edit]
Top result
‘(% Select in editor
Actions
" Edit always show in edit mode
" Edit automatic column width
& Edit cell selection
" Edit clear changeset on successful save
&' Edit disable edits
&' Edit disable save
" Edit enable case sensitive filtering
|= B JMobbin Admin Q8 m
@ BlockTable Q e 2 »
JMobbin Admin
e Select row getUsers.trigger()
<> " " Default filters 2 +
ID Name Email Blocked
No filters
{i} 1 Hershel McV... etexton2d@...
Default operator And Or
) 2 Gayel Coton ekeitley3v@... v
Row selection Single Multiple  None
@ 3 Imogene Sch... ckiddey64@... v
Default row Index Key None
4 Anita Oliver tmordy6l@m... v
. Default index 0
5 Costa Spata kesposilc@... v
6 Catharina M...  uqueree69@... v Index type Display BEiE
7 Booth Macq.. sloache34@... Persist row selection
0 Mo Sheeste s - Cell selection Single None
50 results Y & O
O O Search Fuzzy match
Search term
Advanced X Appearance =
Show column headers Height s Fixed
Show footer Row height Small (32px)
Show column borders Show table border
. . Row color
Automatic column width
Hidden false
Maintain space when hidden
Styles 2 +
Always show in edit mode
None
Margin type Normal None
Show on desktop
<> — 100%
Show on mobile
© Latest No queries running & wDebug O @
|JMobbin Ad... BlockTable x Type a command

‘[ Selectin editor

- Add Pagination

<~ Add Summary row

& Default filters

" Default selected row

& Default sort

" Dynamic columns

" Edit always show in edit mode

" Edit automatic column width
\J di: o alocting


Importing a new table

screenElements: Button Table Breadcrumbs Tab

screenElements:
Button
Table
Breadcrumbs
Tab
Skeleton
Dialog
File Upload

screenPatterns:
Loading
Import & Export
Upload & Download
Add & Create

screenKeywords:
-—_ Resources | Retool Database Feedback? e
= feature requests csv v transactions ar
Add row ImportCSV v @ Fields Y/ Filters { Sort Q Quickfind A This table is read only. Add a primary key to enable editing. & Refresh 5 records
O A no v A featur.. PRIMAR v A description v A post_sta. v A tags v +
1 1 In-App Translator Integrate a built-in translator to enable users to translate text wit...  Completed Localization, Language, New Feature
2 2 Customizable Themes Provide users with the ability to customize the app's appearance ... Planned Personalization, Ul, Enhancement
3 3 Push Notifications Implement push notifications to deliver real-time updates, remin... Implemented Notifications, Communication
4 4 Smart Search Introduce an intelligent search functionality that offers relevant s...  Under Review Search, Al, Enhancement
5 5 Dark Mode Scheduler Allow users to schedule the automatic activation of Dark Mode b... In Progress Dark Mode, Customization, Enhancement
|- Retool Database Feedback? @
feature requests csv transactions
¥ CSVimport success! Done
|CSV Import
New table name
feature requests csv
I Atable using snake_case will be easier to work with when
writing SQL queries.
Convert to snake case?
Schema mapping
CSV column Database field Field type
= No. > no > text v X
= Feature Request > feature_request > text v X
= Description > description > text v X
= Post Status > post_status > text v X
= Tags > tags > text v X
Import settings
Column heading ©
Treat first row as headers
Create a primary key (Recommended) fo )
Create a new primary key column on import
|Click to select a file to import
or drag and drop it here
|CSV Import
New table name
feature requests csv
I Atable using snake_case will be easier to work with when
writing SQL queries.
Convert to snake case?
Schema mapping
CSV column Database field Field type
= No. > no > text v X
= Feature Request > feature_request > text v X
= Description > description > text v X
= Post Status > post_status > text v X
= Tags > tags > text v X
Import settings
Column heading ©
Treat first row as headers
Create a primary key (Recommended) ©
Create a new primary key column on import
|-—_ 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 33 account_998 Comcast Jan 20, 2023 7:55:00 AM Credit Pro
3 4 account_991 Dropbox Jan 30, 2023 8:23:00 AM Credit Basic
4 42 account_984 Bumble Jan 24,2023 9:10:00 AM Invoice Enterprise
5 44 account_961 Nike Jan 08, 2023 5:50:00 PM Invoice Basic
6 30 account_954 Target Jan 15,2023 10:32:00 PM Invoice Basic
7 11 account_945 Progressive Jan 18,2023 7:26:00 AM Invoice Basic
8 28 account_940 Palentir Technologies Jan 04, 2023 9:53:00 PM Invoice Basic
9 49 account_885 Oracle Jan 04, 2023 4:46:00 AM Credit Basic
10 38 account_849 Procter & Gamble Jan 15,2023 9:42:00 AM Credit Enterprise
11 41 account_805 CVS Health Jan 13,2023 5:26:00 AM Invoice Pro
12 15 account_789 JP Morgan Chase Jan 01, 2023 1:31:00 PM Credit Enterprise
13 39 account_781 Nike Jan 03,2023 10:47:00 PM Invoice Pro
14 45 account_778 Comcast Jan 02, 2023 8:35:00 AM Credit Basic
15 43 account_766 Brex Jan 23,2023 12:29:00 PM Debit Pro
16 34 account_748 Gamestop Jan 05, 2023 10:41:00 AM Debit Pro
17 37 account_740 General Motors Jan 31,2023 2:58:00 AM Invoice Basic
18 32 account_733 Target Jan 13,2023 12:35:00 PM Debit Pro
19 50 account_713 Salesforce Jan 11,2023 4:36:00 AM Credit Enterprise
20 29 account_704 Uber Jan 17,2023 5:38:00 AM Invoice Pro
21 10 account_69 Procter & Gamble Jan 21,2023 12:58:00 AM Invoice Enterprise
|Create table Import from CSV X
Name
table_name
Fields
id | PRIMARY Auto Incrementing Integer ID
Add field
Generate Schema With Al Cancel


Adding a transformer

pageType: Application Application

screenKeywords:
= 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 @
|= 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 @


Suggesting a resource

screenElements:
Search Bar
Grid List
Dialog

screenElements:
Search Bar
Grid List
Dialog
Text Field

pageType: Application Application Application Application Application

screenKeywords:
Suggest a resource X
What resource would you like to connect to?
|
2
Cancel
|X
Select a resource type
Q_ Search for a resource
Popular
[ RESTAPI B Google Sheets ]} PostgresaL R MySQL
‘ Firebase o MongoDB @ GraphQL
Databases
AlloyDB ‘ Amazon Athena .5 Amazon DynamoDB Ill Amazon Redshift
BigQuery “9* Cassandra Cloud Datastore :j CosmosDB
=) CouchDB @ Databricks & Elasticsearch @ JDBC
@ Microsoft SQL o MongoDB R MysQL % OracleDB
]} PostgresaL “  Presto & Redis @ RethinkDB
= SAP Hana Snowflake Vertica
|X
Select a resource type
Q_ Search for a resource
Popular
[ RESTAPI B Google Sheets ]} PostgresaL R MySQL
‘ Firebase o MongoDB @ GraphQL
Databases
AlloyDB ‘ Amazon Athena .5 Amazon DynamoDB Ill Amazon Redshift
BigQuery “9* Cassandra Cloud Datastore :j CosmosDB
=) CouchDB @ Databricks & Elasticsearch @ JDBC
@ Microsoft SQL o MongoDB R MysQL % OracleDB
]} PostgresaL “  Presto & Redis @ RethinkDB
= SAP Hana Snowflake Vertica
|= SAP Hana Snowflake Vertica
X

APIs

. Amazon S3 ‘.. Asana '3,:@ BiglD 3 CircleCl

@ Close a Datadog ‘ Firebase ' Front

Q GitHub J' Google Analytics Google Cloud Storage v Google Maps

B Google Sheets @ GraphQL "% HubSpot Jira

@ Lambda K9 Microsoft Teams @ Notion HQ @ OneSignal

@ OpenAl @ OpenAPI {“} RESTAPI ] SMTP

Salesforce SendGrid ..? Slack Stripe

() Twilio ‘G oreC
Suggest

<= Suggest a resource
|Suggest a resource X
What resource would you like to connect to?
Mobbin
Z
Cancel


Deleting a row

screenElements: Checkbox Toolbar

screenKeywords:
- Retool Database Feedback? G
feature requests csv transactions
Add row Import CSV v Fields Filters Sort Quick find Refresh 51 records
O id PRIMARY KEY account_num.. company transaction_date payment_.. plan

40 account_137 Berkshire Hathaway Jan 01, 2023 Debit Basic
41 account_805 CVS Health Jan 13,2023 Invoice Pro
42 account_984 Bumble Jan 24,2023 Invoice Enterprise
43 account_766 Brex Jan 23, 2023 Debit Pro
44 account_961 Nike Jan 08, 2023 Invoice Basic
45 account_778 Comcast Jan 02, 2023 Credit Basic
46 account_248 Front Jan 26, 2023 Invoice Pro
47 account_453 Costco Wholesale Jan 01, 2023 Debit Enterprise
48 account_280 Walt Disney Jan 05, 2023 Invoice Pro
49 account_885 Oracle Jan 04, 2023 Credit Basic
50 account_713 Salesforce Jan 11, 2023 Credit Enterprise
|-—_ Resources |/ Retool Database Feedback? e
= feature requests csv transactions v +
Add row Import CSV v @ Fields Y/ Filters { Sort 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 |+
41 41 account_805 CVS Health Jan 13,2023 5:26:00 AM Invoice Pro
42 42 account_984 Bumble Jan 24,2023 9:10:00 AM Invoice Enterprise
43 43 account_766 Brex Jan 23,2023 12:29:00 PM Debit Pro
44 44 account_961 Nike Jan 08, 2023 5:50:00 PM Invoice Basic
45 45 account_778 Comcast Jan 02, 2023 8:35:00 AM Credit Basic
46 46 account_248 Front Jan 26,2023 12:27:00 AM Invoice Pro
47 47 account_453 Costco Wholesale Jan 01,2023 7:12:00 PM Debit Enterprise
48 48 account_280 Walt Disney Jan 05, 2023 8:06:00 PM Invoice Pro
49 49 account_885 Oracle Jan 04, 2023 4:46:00 AM Credit Basic
50 50 account_713 Salesforce Jan 11,2023 4:36:00 AM Credit Enterprise
4] 51 account_jsmobbin1 JMobbin Nov 01, 2023 5:00:00 PM NULL NULL
1 selected
|-—_ Resources / Retool Database Feedback? e
= transactions v ar
Add row Import CSV v @ Fields Y/ Filters { Sort Q Quick find &' Refresh 50 records
O # id PRIMARY KEY v~ = A account_num.. v A company v (@ transaction_date v A payment_.. v A plan v | +
58 38 account_say Procter & Gambple Jan 15, 2023 Y:42:00 AM Credit Enterprise
39 39 account_781 Nike Jan 03,2023 10:47:00 PM Invoice Pro
40 40 account_137 Berkshire Hathaway Jan 01, 2023 5:57:00 PM Debit Basic
41 41 account_805 CVS Health Jan 13,2023 5:26:00 AM Invoice Pro
42 42 account_984 Bumble Jan 24,2023 9:10:00 AM Invoice Enterprise
43 43 account_766 Brex Jan 23,2023 12:29:00 PM Debit Pro
44 44 account_961 Nike Jan 08, 2023 5:50:00 PM Invoice Basic
45 45 account_778 Comcast Jan 02, 2023 8:35:00 AM Credit Basic
46 46 account_248 Front Jan 26, 2023 12:27:00 AM Invoice Pro
47 47 account_453 Costco Wholesale Jan 01,2023 7:12:00 PM Debit Enterprise
48 48 account_280 Walt Disney Jan 05, 2023 8:06:00 PM Invoice Pro
49 49 account_885 Oracle Jan 04, 2023 4:46:00 AM Credit Basic
50 50 account_713 Salesforce Jan 11, 2023 4:36:00 AM Credit Enterprise
51 51 account_jsmobbin1 JMobbin Nov 01, 2023 5:00:00 PM NULL NULL
|-—_ Resources |/ Retool Database Feedback? e
= feature requests csv transactions v +
Add row Import CSV v @ Fields Y/ Filters { Sort 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 |+
41 41 account_805 CVS Health Jan 13,2023 5:26:00 AM Invoice Pro
42 42 account_984 Bumble Jan 24,2023 9:10:00 AM Invoice Enterprise
43 43 account_766 Brex Jan 23,2023 12:29:00 PM Debit Pro
44 44 account_961 Nike Jan 08, 2023 5:50:00 PM Invoice Basic
45 45 account_778 Comcast Jan 02, 2023 8:35:00 AM Credit Basic
46 46 account_248 Front Jan 26,2023 12:27:00 AM Invoice Pro
47 47 account_453 Costco Wholesale Jan 01,2023 7:12:00 PM Debit Enterprise
48 48 account_280 Walt Disney Jan 05, 2023 8:06:00 PM Invoice Pro
49 49 account_885 Oracle Jan 04, 2023 4:46:00 AM Credit Basic
50 50 account_713 Salesforce Jan 11,2023 4:36:00 AM Credit Enterprise
g . 51 account_jsmobbin1 JMobbin Nov 10, 2023 10:29:27 AM NULL NULL


Creating a workflow (template)

screenPatterns:
Timeline & History
Multi-Column Layout

screenElements: Drawer Dialog Card

screenPatterns:
Empty State
Timeline & History
Multi-Column Layout
Browse & Discover
Code Editor
Empty State

pageType: Application Application Application Application Application Application Application Application Application

screenKeywords:
'—_ Jane Smith - Send Slack Message When Google Sheet Rows Added - Nov 8, 2023 6:43 PM Undeployed changes
8
Add any additional data processing below. Ensure
Modify Google Sheet inputs below and press ». Ensure there is there is an addedOn field in your Google Sheet to
Schedule the cron job to run at your desired an addedOn field in your Google Sheet to identify new records identify new records and the timestamp is in UTC
interval. and the timestamp is in UTC with Z at end. with Z at end.
¢ startTrigger = - @ - E getRowsFromGoogleSheet = - @ » - processData = - @ » -
Enabled triggers [demo resource] Google Sheets Edit JavaScript
Action type 1 let data = getRowsFromGoogleSheet.data
2
Edit triggers Read data from a spreadsheet 3 return data.filter(x =>
S dsheet moment(x.addedOn) .unix() <=
readshee! 3
Test JSON Parameters P moment ().unix() &&
fx _
Inputs Settings
Sheet name
YOUR-SHEET -NAME
Leave blank to select the first sheet
Data Range Use A1 notation
Limit Offset
Data Types
Read data as
Typed values
® production v Inputs Settings
@ staging (not available) e X B jLul
@® production {9 Run history
|Create from template X
) send
Select aresource
. Send Google Analytics data to BigQuery
Airtable "' Google Analytics - BigQuery - ETL
Retool DB
Shopify
AlloyDB O w Send GitHub repository information to Postgres
o5 Asana ¥ GitHub - PostgreSQL - APIs
ahl Amazon Athena
BigQuery
<= Cassandra B 0. Send a Slack notification when a Google Sheets row is updated
" Google Sheets - Slack - Notifications
& Close
¥ Datadog
Google Cloud Storage
O GitHub B St Send a Slack message when a Google Sheet row is added
(3 Google Sheets - Slack - Notifications
.1l Google Analytics
% Google Maps
B Google Sheets 1. B Send a Slack Message When a Google Sheets Row is Updated
7\ GraphQL " Slack - Google Sheets - Notifications
Jira
@ OpenAPI
'-""' PostgreSQL . Send a Slack notification on new custom query matches in Google
b B Sheets
2 Python Slack - Google Sheets - Notifications
£+ RESTAPI
<> Retool Al
Salesforce
S Slack
L] SMTP
Snowflake
Select a category
[ ADIl~
|== Retool Apps Resources Database  QueryLibrary = Workflows Upgrade [KORENEREN
Workiows
Current usage period: Nov 01 to Dec 01
Bandwidth used Total workflow runs Active workflows
0B 0 0
|Create from template X
) send
Select aresource
. Send Google Analytics data to BigQuery
Airtable "' Google Analytics - BigQuery - ETL
Retool DB
Shopify
AlloyDB O w Send GitHub repository information to Postgres
o5 Asana ¥ GitHub - PostgreSQL - APIs
ahl Amazon Athena
BigQuery
<= Cassandra B 0. Send a Slack notification when a Google Sheets row is updated
" Google Sheets - Slack - Notifications
& Close
¥ Datadog
Google Cloud Storage
O GitHub B St Send a Slack message when a Google Sheet row is added
(3 Google Sheets - Slack - Notifications
.1l Google Analytics
% Google Maps
B Google Sheets 1. B Send a Slack Message When a Google Sheets Row is Updated
7\ GraphQL " Slack - Google Sheets - Notifications
Jira
@ OpenAPI
'-""' PostgreSQL . Send a Slack notification on new custom query matches in Google
b B Sheets
2 Python Slack - Google Sheets - Notifications
£+ RESTAPI
<> Retool Al
Salesforce
S Slack
L] SMTP
Snowflake
Select a category
[ ADIl~
|== Retool Apps Resources Database  QueryLibrary = Workflows Upgrade [KORENEREN
Workdiows
+ Workflow
Current usage period: Nov 01 to Dec 01 B From JSON
{3 From Template
Bandwidth used Total workflow runs Active workflows
[ Folder
17.1KB 2 (0]
Name Status Trigger Last Deployed Runs In Period Resources
Jane Smith - Al Onboarding - Nov 8 i 16 minutes ago
' Disabled
<3 2023 6:00 PM isabled @ 0 RestAPI, Retool Err
|'—_ b Jane Smith - Send Slack Message When Google Sheet Rows Added - Nov 8, 2023 6:43 PM Undeployed changes  (») Run Deploy v
® °g s
Add any additional data processing below. Ensure
LS
O Modify Google Sheet inputs below and press ». Ensure there is there is an addedOn field in your Google Sheet to
Schedule the cron job to run at your desired an addedOn field in your Google Sheet to identify new records identify new records and the timestamp is in UTC
interval. and the timestamp is in UTC with Z at end. with Z at end.
¢ startTrigger = - @ - E getRowsFromGoogleSheet = - @ » - processData = - @ » -
Enabled triggers [demo resource] Google Sheets Edit JavaScript
@ - 100% + (3 8 ¢ X B3 i}
- n Action type 1 let data = getRowsFromGoogleSheet.dat
Run history & =  Blocks = Logs Timestamps @0 &2 @4 4 X
@ 11/08/2023 17:59 0B @ Global (all blocks) 843ms Filter entries
% startTrigger 15ms > Starting run for workflow: af5e5128-090e-453b-8f22-0473befbaa8f in environment production We 11/08/2023 17:59:29
Workflow Run Id: 4cchObfc-0460-4482-90b5-1e64633601d1 We 11/08/2023 17:59:29
Triggered from: manual We 11/08/2023 17:59:29
--- Running query: startTrigger --- We 11/08/2023 17:59:29
@ --- Successfully finished running query: startTrigger --- We 11/08/2023 17:59:29
@ --- Successfully finished running the workflow --- We 11/08/2023 17:59:29
® production {9 Run history
|Create from template X
Q Search templates
Select aresource
. Get slack messages on new custom query matches
o 1.
Airtable w " PostgreSQL - Slack - Notifications
Retool DB
Shopify
AlloyDB ' Send Google Analytics data to BigQuery
o5 Asana o Google Analytics - BigQuery - ETL
ahl Amazon Athena
BigQuery
«r Cassandra o w Send GitHub repository information to Postgres
B GitHub - PostgreSQL - APls
& Close
¥ Datadog
Google Cloud Storage Query GitHub repository information with GraphQL and send to
¢) GitHub O at Slack
.'| Google Analytics GitHub - Slack - Notifications
% Google Maps
B Google Sheats w B Append Postgres row data to Google Sheets
7\ GraphQL ¥ PostgreSQL - Google Sheets - ETL
Jira
@ OpenAPI
l_v‘;". PostgreSQL £} 1. Process FullStory alerts and send to Slack
* REST API - Slack - APIs
2 Python
£+ RESTAPI
<> Retool Al
Salesforce
S Slack
L] SMTP
Snowflake
Select a category
[ ADIl~
|-—_ Jane Smith - Send Slack Message When Google Sheet Rows Added - Nov 8, 2023 6:43 PM Undeployed changes
8
Add any additional data processing below. Ensure
Modify Google Sheet inputs below and press ». Ensure there is there is an addedOn field in your Google Sheet to
Schedule the cron job to run at your desired an addedOn field in your Google Sheet to identify new records identify new records and the timestamp is in UTC
interval. and the timestamp is in UTC with Z at end. with Z at end.
¢ startTrigger = - @ - E getRowsFromGoogleSheet = - @ » - processData = - @ » -
Enabled triggers [demo resource] Google Sheets Edit JavaScript
Action type 1 let data = getRowsFromGoogleSheet.data
2
Edit triggers Read data from a spreadsheet 3 return data.filter(x =>
S dsheet moment(x.addedOn) .unix() <=
readshee! 3
Test JSON Parameters P moment ().unix() &&
fx _
Inputs Settings
Sheet name
YOUR-SHEET -NAME
Leave blank to select the first sheet
Data Range Use A1 notation
Limit Offset
Data Types
Read data as
Typed values
Inputs Settings
ﬁ@ — 100% 3 % ¢ X B3 1ul
@ production Run history
|'—_ tD Jane Smith - Send Slack Message When Google Sheet Rows Added - Nov 8, 2023 6:43 PM Undeployed changes  (*) Run Deploy v
® °g s
Add any additional data processing below. Ensure
L
O Modify Google Sheet inputs below and press ». Ensure there is there is an addedOn field in your Google Sheet to
Schedule the cron job to run at your desired an addedOn field in your Google Sheet to identify new records identify new records and the timestamp is in UTC
interval. and the timestamp is in UTC with Z at end. with Z at end.
¢ startTrigger = - @ - E getRowsFromGoogleSheet = - @ » - processData = - @ » -
Enabled triggers [demo resource] Google Sheets Edit JavaScript
4@ - 100% + 3 % ¢ X B3 1}
. n Action type 1 let data = getRowsFromGoogleSheet.dat
Run history $ = Logs X
Run is not selected
Select a run to view its logs
® production {9 Run history


State of AI

pagePatterns:
Landing Page
Footer Section

pagePatterns:
Header Section
Misc

screenElements: Tooltip Logo

screenPatterns: Charts Charts Charts Charts

pagePatterns:
Stats Section
Stats Section
Header Section
Misc
Landing Page
Footer Section
Stats Section
Misc
Misc
CTA Section
Stats Section

pageType: Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing

screenKeywords:
\\\\\\\\\ =
\
™ Top models Used Most Frequently ./ Used Semi-Frequently
\
GPT-2.5 [OpenAIl o
GPT-4 [OpenAIl 31.6% 19 e
3m2% ana Heta
0.5%
o
LaMDA [Google]
\ 0s °
Claude [Anthropic]
\\ ' 05%
2 Openh \ o PalLM [Google]
3% DALL-E [OpenAI] 08%
13% /
() °
Text-embedding-ada [OpenA
lamaz a 0.8%
36% ’
\ y / Retool- State of AL 2023
|average rating of 5 (fairly rated), and e C-suite averaged 5.3. K
ICs—often closer to the actual i v\\\w ii} ation work—skewed a
little more toward overrated, '\il v/ﬁ evel employees giving
an average rating of 5.9 and mid-to-senior ICs 5.
}\
\
*. Breakdown: How fairly rated is AL? i /
< Hide Data [-]
/ [data viz 1.2] - % by category /
Way Undertated Fairly rated Way Overrated
|W rratt eiii o™ AL ,Uwuu, MY A R AL = K
ty significantly.
= S
. Expectations around AI's impact on roleindustry
ST ' vk'
S ‘ A
/ )
1 2 = 4 S B 7 8 a 10
Not very much Somewhat Completely
i - % by category Retool - State of AT 2023
Slicing by job function, those in operations roles had the highest
expectations of change [7.2], followed by product [7.5], and
|= B e \
*. How Fairly rated is AT?
Underrated Z 5 I E
. -
/ .
ated
o
NS I

[data viz 1.1] * % by category Retool - State of AT 2023
Upper management had the most favorable views: VPs gave an
average rating of 5 (fairly rated), and the C-suite averaged 5.3.
ICs—often closer to the actual implementation work—skewed a
|>
S AN
S/ O\ .
-_ Retool Products Enterprise Integrations Pricing Docs ) AN “Book demo Signin
[\ N\ X A OO\
| // N N / \ | O
[\ \\\\ \ /] \\\\i\
| \/ )/ / aaan
MRS | SRR
N\ \ \77 M / / \\\\\\\:};:g;:: —
NN N — Yy NN )
\\ \\\\l\ R / /// \s\i\ // ~ - =
\\/\‘»\\ ::”' ;77;"""'\—\,\,\,\75;%7& /\/;f //,,,,\
/ \ A 2023 REPORT ON AT — —~ = )
e o / J /] _ // /\
\\ /] / / = /// /\
‘ ‘< . s J
/a YA . _ NN ANEERNJIY A VAN
N ) ) )\ \ - \¢ ) .
/ \ \ B / \T \ AN AN N\ \ \\ y
/\ /N s | | /
l X ’“*/*\ X M \ |
[ ) AN N \ | \ |
N/~ N NN ‘s
{ N // i \\ \\\ \ —_—
\ N 7 | \ N\
AN [ o I~ \\\\\\ == 7’\\\\
\ | = DRNANNY
\\;\ \ /\ \W\”\"\:j:— ;;“{ . J/ / ( \\T‘ :
N — A — — =]\ — ) |
S~ / e /“\ \ [ -
= s [ AN i
L ) /J ~_
) / \
s
\ /
|\;“ | fromb (geyéxgrﬁéng WW 23 m resources). \\\ ;
Vi I N \
—— *fwf%,,,,,,, I N\ . —C
S e — Respondents also had some predictions about what those AN ~__
S @ O @O OO O \ \ \ \\\\ \\NK \77777 R
N char&ges coulti‘lloolg\hke\ .
iii:’i?i’:%::,:,i —_— . AN
- [ s m N
LIC1ency . less bot "1TNE WOl k /IIGW
\\% e ‘ | /
——— 1 t 1 ] o / //
) p g p / E .-,‘/
u | e
\ \ \ P -
/ S~ ya ya
4 /
/ / ‘ / / /
/ | / / [
/ / | / / [
/ / q / S/ \ ——
// \‘ “ / y S/ \\\
//,// B /———""*’\\ [ “ // S/ //'
\| ‘\‘ / // + Not so bad! / \x—a,, e
\ | a4 [
“‘\ ‘\“ / / : // . -~ But they also had a big, important ask: Investment in AF
\ g‘ / // / governance and ethics to ensure that the technology’s future
\| / ///// : goes in a positive direction. \
Ay NN /NN —
/ / 7 NN NN\ —
/ / /x\ \\ / PV N N T
|(A e e e e e @D

-_ Ret00| Use Cases Integrations Developers Resources Company
Admin panels PostgreSQL Changelog Contact Support About
Firebase GUI MySQL Documentation Community home Customers
MongoDB GUI DynamoDB Status Support forum Careers
GraphQL GUI Firebase Self-hosted deployment Join our Discord Blog
Dashboards GraphQL API Generator Show & Tell
SQL GUI Amazon S3 RegEx Generator Retool for startups
React components Google Sheets Developer utilities State of Al Report
Google Sheets GUI MongoDB Developer network Internal tools report
Customer support Engineering time report
Financial operations Guide to building secure internal tools

© Retool,Inc. Privacy Terms Security II.'] X @
|) \\\\ \l /// / // : AR
_ ,777777777%7%%%\ s SO \\‘ e L
Is AT actually changing
:;::;77777 7777777777777””””'“f———\;\x: h ] d /// “‘\ 1 1
—  — ow developers learn
J ?
“ ana work /A
- @ * \ pd
" =
. 7 A You’ve probably heard the rumblings that StackOverflow traffic ///
jﬁiii::: *”’:{ is down, and various theories about why. //
S~ 2 ///
7 ‘J
+ 57 +10.2% S
/ S & ) / - | s‘ e /
/ \ | | /
/ // “‘ “\ /,’ “/
/ of respdndents say they’ve been using StackOverflow \ ‘ ...who are no longer using it at all. L
‘ “ / ‘
S/ less/s{nce 2022, That includes... \ // I )
p N \ | | / AN == <
N \‘ They cited GitHub Copilot, along with ChatGPT, as the /
N\ | / / ‘
‘\‘ ﬂ;‘)verv/&hel ing reason [Q/Z{.?%]. “‘
e L I / AN z
/
|// . \\\\\\ internal use case using GPT-4 (or 2.5... or 3...).
/ // / TN \\\ As the landscape evolves, will companie ,;'él?sfﬁ?ftgﬁﬁéjtuning their
/| w ‘ VNN D
/ / ‘ P! 4\7\4\ “\ models, augmenting them with vector databases, and iterating
[ \ </ L
‘w“/ \ / L \X/ ,‘ \ ‘ on their LM prompts? Will they develop thoughtful policies
l‘ ’/ X\\f i / ‘ / andg r/gifs for the use of AT and encourage employees using
‘ ‘ \\\/ \(/ / LLMé i /s/eeret to use them openly? We'll see.
\ | ) D
O\ \”**% . / / 4 \ SN )
\ \\ \\7 . e / / ‘ \\\ , ) ey V/ . .
N \14\\ P . For \W\t e’s a lot of big stuff on everyone’s minds,
““‘ 7:7;7/:;"/,,, S Pz ///,,, ‘\‘
w\ . anda;lbt\ spondents want to talk about: )
Existential anxiety “. Promptengineering .~ Opportunity “ Costs & . Rate l/iﬁ'\it;”iy'"y"“,t-,.,;;,af;;;kesl(i]]ing # AI
/ ,‘//V ;\ ‘ N w““;\\,,,,ﬂ—rr' (="
. / // : . . \\ . . / 5 . . (1] “‘ ‘ \—7:———" - .
Bias ™. a}bfan emissions . | Ethics ™. Security . Hallucihations < ™. gver-rehance < Deep learning
/ [ | \ /
// ( (/ \\\ | \ / / / ,// \\\
lity - Workforce adaptation .~ Iyaom B\~ \B,és}/prg/a‘tlces # Under-utilization ™. Convenience .~ Qutput
I S~ 7\\ /] AN ‘ /// / \k /
| i Q Vo oo N NN S o QLA P . i
ogies “. Jo mar&et changes -~ E;u_}/lmng\m\rib%/l{)g/ . Expanding thinking - abmetalﬂwpacts . Feelz %%
" P , N / .
N // , TN B |\
D yay N \\ \\\ “‘ / / | ‘
/ [\ \\ \\Tt’\s clear that whether they’re bullish, bearish, or just going with
) TN N ‘
/ Lo ﬁé’ﬁ&v{ te}folks across industries and roles are thinking/ /
— 77,@,\ w“ // égrnés{ly about the possibilities and im\pl‘CQtions of AI:;//
\ “:_teéhl‘\long'{es and how they’ll shap%aﬂy,,fgceisigf the future. In
k ‘ 6ur V{éw, this dynamic chapter is only the beginning.
|= o= ‘ [ \\\\\ ‘\\\7:‘7%777/,,, B 7
. /4
~ Real talkon a |
. — I\
S . I
- AT Sentiment
N — A [\ e
\—;,,,7 _ ‘\\7777”
. //
Let’s start cutting through the noise. Vs
“‘ e “,“’ .
v / | / “ )
P ~ Isthe AT hypeallit’s
- hyped up to be? B .
N AN U T / i
\\\\ \\ With all fhe duzz Pnd emoware out there, it’s eéf&s&to ge7t swept
\ \ | e
’ 77;*77\;\\ \\\\\ \\ up in exci‘t\enf\ent]‘—b t respondents were more discer\rﬁﬁg@{{ i
s 7\\\ \\\\\ \\\ AN " easily blown &“Wé‘i’- “ —_—
s N N ~ N \ N
/ p N\ N N\ \ |
// / B ”\\ \\E\ \\\ \\ \\‘ \\ ‘\ \\\ P
/ / TN\ A Infact, they generally considered AT a bit overrated, '
/ a4 N\ — ‘ R 1T / —
Y / A — ~though not dramatically so.
|‘ They cite ilot, along with ChatGPT, as the \%
0 helming re 93.7%].
" How much less have you used StackOverflow this year? i
- Hide Data [-] |~
.}
100% less—I don't use it anymore
?
S50% less
D e
10% less >
. ]
About the same
L]
T use StackOverFflow more
. ]
/\
I've hever used StackOverflow
/ [data viz 1.3] - % by category
|\‘

*. Another way to look at those top models

H I P-4 [OpenAI] .

GPT-3.5 [OpenAT]

Claude [Anthropic]

) GPT-2 [OpenATI]

s |

- Text-embedding-ada [OpenATI]

. Llama2 (Meta]

DALL-E [OpenAI] /

| o a
. PalLM [Googlel ‘
Llama [Meta,

e PORULARTRY ey

[data viz 3.2] - np@é by category ) % Retool # State of AL 2023
|ﬁ D
1‘@\‘
'—Retool v"’ ,',[ . . ,
' \y
. i 1. ii“fﬁfﬁ
(,_\ ////
’\ +
Qf"/;é‘ = —
|average rating of 5 (fairly rated), and the uite averaged 5.3. %
-. ICs—often closer to the actual im x‘\\‘\‘u’/ tion work—skewed a
little more toward overrated, with e -\\M,- employees giving
an average rating of 5.9 and mid-to-senior ICs 6.
*. Breakdown: How fairly rated is AL? i /
< Hide Data [-]
/ [data viz 1.2] - % by category /
Way Undertated Fairly rated Way Overrated
|\
A=) —
CN oy /|7 =
oY, ’ i
|F " ’II -.
’\ 20.6% 19.3% 14.8% 13.4%
We haven' arted We're getting the -//! e have some ad-hoc use We have several us es We're leading the industry
adopting AT il p cases in production in productio in AT adoption
[data viz 21] - % by category ’ Retool - State of AT 2023
|// “ ‘\\ //\\ |\ [N \\\ \\\ N\ > S W
4 “ S \\ ‘ \\\ NN RN ) ) ™\
{ \ T e FNC RN \\ // //, / —
/ N \\ // \ \\: RN v - /
| / N Vs \ DR NN 7 N
‘ / S P3¢ A oy / / o - e
. \\—7;7 — AN / | \\t\\\;\g;;;g (/~ = // \
. \ /| In 2023, AI— cifically generative Al—has |
; s ~ Voo R AN e/ / L
\7/\ A / unequivocally gone main i, m. Its ems like Yoy / \\//
N — )/ everyone has played 'éfbi;/ d with larggiang,,,, ge // //
\\ ,/ / models (LLMs)—and, with upwards of 100 1’1’1111101’/1/ \// /
. : / / \. -~ / S
\(\ weekly active users, C,l’ia{tGPT has pract}calllbgc/éme ( P
\ B p / (
I\ a household name. } v
/ | \777;\K77ﬂ/
\\ \“
/ T Teachers, politicians, talk show hosts, the bus driver, and your
/ _ /
e grandparents may be using LLMs for going bey‘/ nd Googling
-~ // . and oddball comedy bits—but those day-to-c}!yo use cé@]ysg
S 7\\ / scratch the surface of the possible. Diggingéeeper, folks
AN \ yd /
/ N working close to the tech are using a breadth of Al tools to
e 7,,,,;,%F\ \\\ transform products, reimagine businesses ar;d,deli er customer
P I N\ /
e = — I N N \ ier s s s s / SR
/ — \\\\ \\\\ \\\ N eXpér ler%ces in ways previously unimaginable... Or, at least, \\
/ / N . \ \ AN that’s thé; promise. “‘ O
/ / / / \\ - ’*""'\ \\ . Sowhat’sthe real story? We surveyed over 1,500 tech /peop}g— \
/ / / e : \“\\ \ \\\ \ - software engineers, eng and business l%ders, execs, fproduct' /f *”‘\\
/ / “ // | : I\ \\\ \ . folks, designers, ?nd more—in a variety of industrie/s/f&ﬁnd < \ \
[ \ / - J | OO N / ‘ \
[ “ ‘ \ / / . ‘\‘ \‘ \ \\\ out. Read on to %éarn how they're actually using a}'{d building -/
o // N\ | o N AN \ / |
‘ \f N 4 \ \ . A \\\ﬁ{h\ AT | // / [
| \( ~N_ A ) ‘ / — | SN\ |/ | /
\ ( | —_— / |/ — S o / / \
- \ f °o / | Yy NN 1/ N ///
N N s B e NEa S~ = 7
\ Ny N ~___~ /) AN — '/j/ (1ARN {: =
NN O\ ' S S P 7T AN *


Switching calendar views

screenKeywords:
= O JMobbin Admin QB m
@ Components Modules 57 <«
calendar1 Q e X »
Q search components
I'_"Y Unblock user v Content
¢</® Data . Mode Manual Mapped
{i} |I| === JSON November 8, 2023 Month Week Day List Today ¢ > Events 82+
— »
Event1
\9 Chart Filter JSON 08 Wed
Explorer
All-Day Event2
by I New o Event3
7AM Event4
Reorderable Table Standup
List 7-8am
8AM
Interaction =
Presentation
9AM Default date {{ new Date() }}
1= [ e .
: - es s Default view Week v
10AM
Alert Avatar Avatar Group List type Week .
11AM
New . :
@ —_ Event handlers +
: } 12PM i i
i - Lunch Trigger queries, control components, or call
Calendar ‘i:;‘;“':r Divider 12-1pm other APIs in response to component events.
< 1PM
8 @ ) ou Appearance =
. 2@
: Hidden false
Icon Image Image Grid
3PM
Styles 2 +
o 30%
PDF 30% [ 4PM None
PDF Progress Bar  Progress
Circle 5PM
i~ $1000a 6PM
—
QR Code Spacer Statistic 7DM
O O
g Tag Tag MJ
<> ° Tag Tag — 100%
atus Taas Text
© Latest No queries running & M Debug O @
|- . "
a B JMobbin Admin QB m
@ Components Modules 57 <«
calendar1 Q e X »
Q search components
I'_"Y Unblock user v Content
¢</® Data . Mode Manual Mapped
{i} |I| === JSON Nov5-11, 2023 Month Week Day List Today ¢ > Events 82+
— »
. . . Event1
@ Chart Filter JSON 05 Sun 06 Mon 07 Tue 08 Wed 09 Thu 10 Fri 11 Sat
Explorer
All-Day l Offsite Event2
by I New o Event3
7AM Event4
Reorderable Table Standup Busy
List 7-8am 7 am-3pm
8AM
Interaction =
Presentation
9AM Default date {{ new Date() }}
Y= e 222 Default view Week -
10AM
Alert Avatar Avatar Group List type Week .
11AM
New . :
@ —_ Event handlers +
: } 12PM i i
i - Lunch Trigger queries, control components, or call
Calendar ‘i:;‘;“':r Divider 12-1pm other APIs in response to component events.
< 1PM
8 @ ) ou Appearance =
. 2@
: Hidden false
Icon Image Image Grid
3PM
Styles 2 +
o 30%
PDF 30% [ 4PM None
PDF Progress Bar  Progress
Circle 5PM
i~ $1000a 6PM
—
QR Code Spacer Statistic 7DM
O O
g Tag Tag MJ
<> ° Tag Tag — 100%
atus Taas Text
© Latest No queries running & M Debug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
calendar1 Q e X »
Q search components
I'_"Y Unblock user v Content
¢</® Data . Mode Manual Mapped
{i} |I| e JSON November 2023 Month ~ Week Day List Today < > Events 82+
— »
@ Chart Filter JSON Sun Mon Tue Wed Thu Fri Sat Event
Explorer Event2
1 2 3 4
by I New Event3
Event4
Reorderable Table
List
5 6 7 8 9 10 1
Interaction =
Presentation l Standup 7-8 am l Offsite All-Day
Default date {{ new Date() }}
l Lunch 12-1pm l Busy 7 am-3 pm
Y= e 222 Default view Week -
12 13 14 15 16 17 18
Alert Avatar Avatar Group List type Week .
New ' :
@ —_ Event handlers +
' = Trigger queries, control components, or call
Calendar ‘i"‘“"ar Divider 19 20 21 22 23 24 25 other APIs in response to component events.
Image
8 @ ) Appearance =
. 2@
: Hidden false
Icon Image Image Grid 26 27 28 29 30
Styles 2 +
o 30%
PDF 30% J None
PDF Progress Bar  Progress
Circle
i~ $1000a
—
QR Code Spacer Statistic
O O
g Tag Tag MJ
<> ° Tag Tag — 100%
atus Taas Text
© Latest No queries running & M Debug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
calendar1 Q e X »
Q search components
I'_"Y Unblock user v Content
¢</® Data . Mode Manual Mapped
{i} |I| —— JSON Nov5-11, 2023 Month Week Day List Today ¢ > Events 82+
— »
. ) Event1
@ Chart Filter JSON Wednesday November 8, 2023
Explorer Event2
7-8am Standup
@ New | Event3
D | 12-1pm Lunch Eventd
Reorderable Table
List Thursday November 9, 2023
. Interaction =
Presentation | All-Day Offsite
Default date {{ new Date() }}
| 7 am-3pm Busy
Y= e 222 Default view Week
Friday November 10, 2023
Alert Avatar Avatar Group List type Week
| A-Day Offsite
New ' :
@ —_ Event handlers +
i ' » = Trigger queries, control components, or call
Calendar ‘i:;‘;‘;':r Divider other APIs in response to component events.
8 @ ) Appearance =
. 2@
: Hidden false
Icon Image Image Grid
Styles 2 +
o 30%
PDF 30% / None
PDF Progress Bar  Progress
Circle
i~ $1000a
—
QR Code Spacer Statistic
O O
g Tag Tag MJ
<> ° Tag Tag — 100%
atus Taas Text
© Latest No queries running & wDebug O @


App settings

screenElements: Banner Select

screenPatterns:
Settings & Preferences
Settings & Preferences

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
App settings X
@ PP g Inspector (8U) <«
17 cenera JMobbin Admin
v css
< ® Custom CSS Add custom style overrides for this app. Use with caution as classes and
7
DOM structure may change as new features are introduced. Set styles in the ID Name Email Blocked
Preloaded JS . ;
{} component inspector when possible.
|
Libraries 1 Hershel McV... etexton2d@... v
. m . le-cl lor: red; ,
@ Page Settings SEACGEES < GEAERS Geih L 2 Gayel Coton ekeitley3v@... v
@ Custom shortcuts 3 Imogene Sch... ckiddey64@... v
4 Anita Oliver tmordy6l@m... v
5 Costa Spata kesposilc@... v
6 Catharina M...  uqueree69@... v
7 Booth Macg... sloache34@...
50 results Y & O
Unblock user v
<> — 100%
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
A tti
@ pp settings X Inspector (8£U) <«
JMobbin Admin
Y General Custom keyboard shortcuts
¢/® CustomCSS + Add new
Preloaded JS ID Name Email Blocked
{i} f : 1 Hershel McV etexton2d v
Libraries Shortcut syntax ® @.-
O Page Settings Single keys: Most keys can be specified directly like a, /, or $. Keys 2 Gayel Coton ekeitley3v@... v
I —— without a printable character are referenced by name, like backspace, 3 Imogene Sch.. ckiddey64@..
@ tab, enter, and esc. The space and plus keys are also referenced by
name. 4 Anita Oliver tmordy6l@m... v
Combinations: Use a + to specify a combination of keys (e.g., mod+a).
Available modifier keys are shift, ctrl, alt/option, meta/command, and 5 Costa Spata kesposilc@.. v
mod (ctrl or meta depending ?n 'Fhe platform). 6 CatharinaM.. uquerce69@..
Sequences: Use a space to signify a sequence of keys (e.g., up up
down down left right left right). 7 Booth Macq...  sloache34@...
View documentation
50 results Y & O
Unblock user v
<> — 100%
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
App settings
@ PP g x Inspector (8U) <«
. .
1y JMobbin Admin
v General Select atheme Business
° Custom CSS Upgrade to business plan to use theme
<I;
ID Name Email Blocked
Preloaded JS Set canvas max width
{i} . . Set the maximum page width for this app 1  Hershel McV etexton2d@. v
Libraries i
(accepts pixel values, percentages, or 100%
@ Page Settings none ). An 800px minimum width is 2 Gayel Coton ekeitley3v@... v
enforced on desktops.
@ Custom shortcuts 3 Imogene Sch... ckiddey64@... v
Configure Markdown link behavior
4 Anita Oliver tmordy6l@m... v
Links outside your Retool organization vel@
open in a new tab by default. You can Automatic 5 Costa Spata kesposi1c@... v
override this behavior to open all links in
either a new tab or the current tab. 6 CatharinaM...  uqueree69@..
Show query status to viewers 7 BoothMacq..  sloache34@...
Query run status is always available to editors in the status bar. A M B -
50 results Y & O
Enable mobile layout
Hide or show components when viewport is less than 600px. Learn more.
Unblock user v
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 & wDebug O @
|= B JMobbin Admin Q8 m
App settings X
@ PP ng Inspector (8U) <«
7 Gonera . JMobbin Admin
\g enera Page SettingsuRL Parameters
<//. Custom CSS Choose which values on the page to store in the URL
Preloaded JS ID Name Email Blocked
{i} Libraries 1 Hershel McV... etexton2d@... v
\9 Page Settings Connect properties on the page to values in the URL 2 Gayel Coton ekeitley3v@... v
@ Custom shortcuts Choose a propert... 3 Imogene Sch... ckiddey64@... v
@ View documentation 4 Anita Oliver tmordy6l@m... v
5 Costa Spata kesposilc@... v
6 Catharina M...  uqueree69@... v
7 Booth Macg... sloache34@...
50 results Y & O
Unblock user v
<> — 100%
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
App settings X
@ PP g Inspector (8U) <«
17 cenera JMobbin Admin
v Libraries
< ® Custom CSS Add access to custom libraries in this application. Retool includes out-of-the-
7
box access to lodash, moment.js, uuid, and numbro. Note that this will ID Name Email Blocked
Preloaded JS o
{i} reinitialize the app.
Nibrares 1 Hershel McV... etexton2d@... v
) Page Settings 2 Gayel Coton ekeitley3v@... v
@ Custom shortcuts 3 Imogene Sch... ckiddey64@... v
No libraries added
Click Add new to add a new library. 4 Anita Oliver tmordy6l@m... v
5 Costa Spata kesposilc@... v
6 Catharina M...  uqueree69@... v
7 Booth Macg... sloache34@...
50 results Y & O
Unblock user v
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
App settings X
@ PP g Inspector (8U) <«
Iy JMobbin Admin
v General Select atheme Business
° Custom CSS Upgrade to business plan to use theme
<I;
ID Name Email Blocked
Preloaded JS Set canvas max width
{i} Libraries Set the maximum page width for this app 1 Hershel McV... etexton2d@... v
(accepts pixel values, percentages, or 100%
@ Page Settings none ). An 800px minimum width is 2 Gayel Coton ekeitley3v@... v
enforced on desktops.
@ Custom shortcuts 3 Imogene Sch... ckiddey64@... v
Configure Markdown link behavior
4 Anita Oliver tmordy6l@m... v
Links outside your Retool organization vel@
open in a new tab by default. You can 5 Costa Spata kesposilc@... v
override this behavior to open all links in
either a new tab or the current tab. v Automatic 6 CatharinaM... uqueree69@..
Only links outside of your Retool
Show query status to viewers organization open in a new tab. 7 BoothMacq..  sloache34@..
Query run status is always available to editor P - A .
Always open links in a new tab 50 results Y &L 0O
Enable mobile layout All links open in a new tab.
Hide or show components when viewport is |
Never open links in a new tab Unblock user -
Show loading state All links open in the current tab.
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 & wDebug O @


Moving a component

screenPatterns: Move Canvas

screenKeywords:
= 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 =
v Loadin false
Untoe ey | Label Select an option v | g
Disabled false
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 @
|= B JMobbin Admin Q 8 m
@ Component Tree L«
e e R »
Frames + ! . . f -] select1 Q R
w ‘JMobbin Admin |
Header Content
4 Sidebar Mode Manual Mapped
i ID Name Email Blocked i
o 11 Main ! 1 Options | o +
! ! 1 Hershel McV... etexton2d@... v !
- Option 1
) ! 2 Gayel Coton ekeitley3v@... v {
i i Option 2
@ i 3 Imogene Sch... ckiddey64@... | o 5
: H ption
Main Components + 4 Anita Oliver tmordy6l@m... v
i i Default value
T text1 ! 5 Costa Spata kesposilc@... v 1
; ! Placeholder Select an option
@ table i 6 CatharinaM... uqueree69@... i
(s splitButton1 Add-ons +
| 7 Booth Macg... sloache34@... 1
select1 i i 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% Qhulae ~ L
© 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 @