Settings

screenElements:
Table
Segmented Control
Tab

screenPatterns:
Subscription & Paywall
Pricing

screenElements:
Table
Segmented Control
Tab
Top Navigation Bar
Logo
Card
Banner
Floating Action Button
Banner

screenPatterns:
Subscription & Paywall
Pricing
Home
Feature Info
Delete & Deactivate Account
Settings & Preferences
Settings & Preferences
Subscription & Paywall

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

screenKeywords:
== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
Advanced
Account
Preloaded JavaScript
Users
P, Add preloaded JavaScript to all applications in the organization by assigning them to the window scope.
Environments Note: Adding preloaded JavaScript to all applications may negatively impact performance. We recommend adding preloaded JavaScript to individual applications when
IAM Credentials possible to avoid potential issues. Learn More
Billing
Branding Business
Themes Business
Source Control Enterprise
Advanced
Beta
Retool Events
Retool Al
Save
Preloaded CSS
Apply preloaded CSS to the homepage
|== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
Advanced
Account
! Deploy Retool at scale.
Users Upgrade to get
L. version control with Git
Permissions
Environments ' Ul mers
identity management with SAML SSO
IAM Credentials
,and
Billing directory sync via SCIM.
Branding Business
Themes Business Authentication Options
Source Control Enterprise
Require Two Factor Authentication
Advanced
Beta This applies to the entire organization, not limited to one domain.
Retool Events
Retool Al
Auto-join domains
Users with emails from these domains can join this organization.
Add domain
Allow anyone to request to join
This adds a link on the login screen to allow any user to request access.
Preloaded JavaScript @
Add preloaded JavaScript to all applications in the organization by assigning them to the window scope. G
|-—_ RethI Apps Resources Database Query Library Workflows Upgrade Qs ~
Beta
Account
Features
Users
Permissions Custom auth open URL in new tab
. Enables creating custom auth step that opens a URL in a new tab
Environments
IAM Credentials
Deprecated components
Billing Show deprecated versions of components.
Branding Business
. Enable Source Control On Prem Temporal
Themes Business
Enables converting Jobs Runner into a temporal worker for source control deployments
Source Control Enterprise
Advanced GitHub Personal Access Token
Beta Allow users to configure Source Control with GitHub Personal Access Token
Retool Events
Google Search Console Integration
Retool Al Show the Google Search Console OpenAPI integration in the create a resource Ul
@ Hide userlist
Hide user lists when user does not have adequate permissions
Include Authorization header for OAuth requests
For OAuth requests, include Base encoded client_id and client_secret in the Authorization header
Enable parent window communication
Allow embedded Retool apps to use the parent.postWindow() APl in Javascript queries
@ Use Public API for Permissions
@D Prevent query variable spoofing @
Prevent spoofing of expressions that refer to the current_user global in queries.
@) Ratanl Fmail G
|== Retool Apps  Resources  Database  QueryLibrary  Workflows Upgrade [KOREN-IEM

IAM Credentials

Account
Retool can fetch your RDS and S3 resource configurations from AWS directly to help create resources faster.

Users For Retool to access these resources, provide your AWS |AM credentials that have the necessary permissions to list your RDS and
S3 resources. Learn more.

Permissions

Environments AWS |IAM Access key

IAM Credentials

Eillnd AWS IAM Secret

Branding Business

Themes Business

Source Control Enterprise w

Advanced

Beta

Retool Events

Retool Al
|All users
Invited
Users
Permissions G Jane Smith e Pending
Environments Hide disabled users
IAM Credentials
Billing
Branding Business
Themes Business
Source Control Enterprise
Advanced
Beta
Retool Events
Retool Al
|rccount Environments
! Environments are not enabled in your plan.
q 8 Upgrade now
Users Upgrade to create multiple environments.
Permissions
Environments
IAM Credentials © production
Billing
Branding Business
Themes Business
Source Control Enterprise
Advanced
Beta
Retool Events
Retool Al
|Account ! Retool pricing is based on user type
With Retool paid plans, you pay different rates for different user types: standard users who build and edit in
Retool, and end users who only use apps. Learn more
Users
Permissions Plans Billing Annual
Environments
IAM Credentials Free Team Business Enterprise
Billing
Branding EBusiness $0 $10/mo $50/mo Custom pricing
Themes Business up to 5 users per standard user per standard user
Source Control Enterprise $5/mo $15/mo
P per end user per end user
Retool Events
billed annually billed annually
Retool Al
Web apps
Web apps
Modules
Custom React components (] (] (] (]
App themes (] (]
Authenticated, embedded apps (] (]
Branding
Mobile apps
Mobile apps
App themes O Q Q 0 @
Offline mode (] (]
Push notifications (] (] Q
White-label apps (]
|-—_ 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
|-—_ RethI Apps Resources Database Query Library Workflows Upgrade Q (s~
e Jane Smith
Welcome to Retool, Jane! Settings
Audit logs
Logout
o 8 S] 9
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 o Get started with Al
b @ y Start building with Al > Learn more X
. © © O¢ Retool Al gives you powerful building blocks - like LLM connectors and a vector database - to create Al- 9
powered applications and workflows.
Al
All  Recent Starred Modules Folders Trash
Name v Updated Last Editor
(mm] [Sample App] Users Dashboard 6 days ago Jane Smith
ogo Block Form Request 4 days ago Jane Smith
El Fowl x Pottery 6 days ago
o Jane - Al Template App - November 10th 2023, 5:59:31 pm 4 days ago @
o Jane - Al Template App - November 10th 2023, 6:09:07 pm 4 days ago
o Jane - Al Template App - November 8th 2023, 5:54:37 pm 6 days ago °
|- .
- RethI Apps Resources Database Query Library Workflows Upgrade Q (s~
Personal Th
emes
Account
U Promo code )
L pd state (optional)
Permissions MRR Revenue i tion
Environments $32,123 $2,892 .
a 10% v 6% n business @
e Custom theme, anywhere :
Billing Customize the look of any Retool app. g CLOCTHEw
Branding Business Upgrade -
checked checkbox
Themes  Business Years in business Focused state (optional)
Source Control Enterprise Cancel
Advanced Expected annual GPV (optional) Years in business Spin when fetchi
Beta 83,293 L .
Retool Events How themes work X
Retool Al
1 Create theme

Click "Create New" to create a new theme. Name your

theme and select one of the six base themes as a starting

point.

Create new

2 Customize theme

3 Apply theme to apps

4 Fine-tune colors

Have questions? Read the documentation.
|-—_ RethI Apps Resources Database Query Library Workflows Upgrade Qs ~
Retool Al
Account
Integrate Al into your apps and workflows
Enable Retool Al
Users
Permissions Retool Al
Environments Retool works with Al partners to provide Al-powered capabilities in the product. C
Learn more about how Al features work in Retool.
IAM Credentials
Billing
Branding Business Features
Themes Business
Al Actions C
Source Control  Enterprise Build Al-powered apps and workflows that can perform sentiment analysis, categorization, summarization, and more. Learn more
Advanced
B Vectors C
Provide more context to LLMs by storing text embeddings in a Retool-managed vector store. Learn more
Retool Events
Retool Al Ask Al C
Use Al to help you write edit, explain, and fix code and queries using natural language. Learn more
|I Count UserS All users Name m
Users

Permissions G Jane Smith admin
Environments

IAM Credentials

Billing

Branding Business

Themes Business

Source Control Enterprise

Advanced

Beta

Retool Events

Retool Al
|== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
Advanced
Account
For further information, read link to legal policy explanation.
Users
Retain data for 30 days
Permissions
Environments Save
IAM Credentials
Billing
Branding Business
Change subdomain
Themes Business
Source Control Enterprise Changing your Retool subdomain will log you out of Retool and permanently change your Retool organization’s URL. To avoid confusion, please make sure to update any
references to Retool accordingly.
Advanced
Beta jsmobbin .retool.com
Retool Events
Retool Al
Archive Organization
Archiving this Retool organization will also archive every user belonging to it.
Archive organization
Invalidate Sessions
Invalidate all sessions for your organization. This will log you out of your current session.
Invalidate all organization sessions @
|-—_ RethI Apps Resources Database Query Library Workflows Upgrade Qs ~
Retool Events
Account
Run workflows based on actions taken within Retool. Visit our documentation to learn
more.
Users
Permissions /A Retool Events are not available on this plan
Upgrade to Enterprise to run custom logic through Workflows based on actions taken
EDVIIonments within Retool.
IAM Credentials
Billing Password Reset Requested
Branding Business Triggered when a user requests their password reset.
Themes Business Add a workflow
Source Control Enterprise
Advanced User Invited
Beta Triggered whenever a user is invited to your organization.
Retool Events Add a workflow
Retool Al
User Created
Triggered whenever a new user is added to your organization. Does not trigger on user invites or access
requests, until the user accepts and/or is approved to join the organization.
Add a workflow
User Requested Access
Triggered whenever a user requests access to your organization.
Add a workflow
|-—_ RethI Apps Resources Database Query Library Workflows Upgrade Qs ~
— Source Control
Users
Permissions
- @
Environments
[J
IAM Credentials V. S
Billing
Branding Business
Enterprise
Themes Business
Source Control  Enterprise Manage app changes with Source Control
Advanced
Source Control allows organizations to manage changes to their Retool applications using pull
Beta requests on remote source control management (SCM) providers. Instead of making changes
directly to an application, changes are made on a separate branch.
Retool Events
Retool Al
Upgrade to Enterprise
|-—_ RethI Apps Resources Database Query Library Workflows Upgrade Qs ~
Advanced
Account
Libraries
Users
Permissions Add access to custom libraries to all applications in this organization. Retool includes out-of-the-box access to lodash, moment.js, uuid, and numbro.
Environments Note: Adding preloaded libraries to all applications may negatively impact performance. We recommend adding preloaded libraries to individual applications when
|AM Credentials possible to avoid potential issues. Learn More
Billing
Branding Business Add Link
Themes Business
Source Control Enterprise
Advanced
Beta
Other Options
Retool Events
Retool Al Cache queries across all users o«
Disable Al Support Bot
Default Retool outbound region for queries Set Region
Current region: us-west-2 (Oregon, US)
Workflows
Enable Data Retention C
By using this feature, you acknowledge that your workflow run history data will be stored for the specified period of time (up to 90 days). To opt out, disable this feature.
For further information, read link to legal policy explanation.
Retain data for 30 days @
Save G
|-—_ Retool Apps Resources Database Query Library Workflows Upgrade Q (s~

Permission Groups

Account
I Granular access controls are not available in your plan.
Upgrade now

Users Upgrade to create custom groups.
Permissions
Environments
IAM Credentials All Users
Billing

Admin e
Branding Business
Themes Business
Source Control Enterprise
Advanced
Beta
Retool Events
Retool Al
|-—_ RethI Apps Resources Database Query Library Workflows Upgrade Qs ~
Beta
Account
Hide user lists when user does not have adequate permissions
Users
Include Authorization header for OAuth requests
Permissions For OAuth requests, include Base encoded client_id and client_secret in the Authorization header
Environments
|AM Credentials Enable parent window communication
Allow embedded Retool apps to use the parent.postWindow() APl in Javascript queries
Billing
Branding| (GHENESS @ Use Public API for Permissions
Themes Business
Source Control Enterprise @D Prevent query variable spoofing
Prevent spoofing of expressions that refer to the current_user global in queries.
Advanced P 9 P - 9 q
Beta
@ Retool Email
Retool Events You can now send emails (up to 120 emails per hour) without the need to configure your own SMTP resource. Read the docs here.
Retool Al
o Auto-cleanup Source Control Branches
Automatically cleanup local Retool branches that no longer exist in remote
Enable collaborative branch feature
Enable users to collaborate on a branch with other users
Require Strong Password for Login
When true, requires password to have minimum character length and contain one uppercase letter, one lowercase letter, and one special character
Disable ToolScript Migration Dryrun
Prevents a dryrun of the toolscript source control migration


Inviting a user

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

hotspotType: Keyboard Input

screenElements:
Chip
Loading Indicator

screenPatterns:
Invite Teammates
Loading

pageType: Application Application Application Application Application Application Application

screenKeywords:
ACEETR UserS All users Name m
Users
Permissions G Jane Smith admin
Environments
. G Jon Smith admin
IAM Credentials
Billing
Branding Business
Themes Business
Source Control Enterprise
Advanced
Beta
Retool Events
Retool Al
|X

Invite new users
Emails

jonsmith.mobbin@gmail.com X

name@example.com X
Permission groups
Invited users will be added to these groups

All Users admin x
|I Count UserS All users Name m
Users
Permissions G Jane Smith admin
Environments
. . jonsmith.mobbin@gmail.com admin
IAM Credentials
Billing
Branding Business
Themes Business
Source Control Enterprise
Advanced
Beta
Retool Events
Retool Al
|I Count UserS All users Name m
Users

Permissions G Jane Smith admin
Environments

IAM Credentials

Billing

Branding Business

Themes Business

Source Control Enterprise

Advanced

Beta

Retool Events

Retool Al
|X
Invite new users
Emails
jonsmith.mobbin@gmail.com
Permission groups
|X

Invite new users
Emails

name@example.com X

name@example.com X
Permission groups
Invited users will be added to these groups

All Users admin x
|X

Invite new users
Emails

jonsmith.mobbin@gmail.com X

name@example.com X
Permission groups
Invited users will be added to these groups

All Users admin x
Successfully invited 1 new user! ©®


Creating a folder

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


Starring an app

hotspotType: Hover

screenPatterns:
Home
Favorite & Pin

pageType: Application Application Application Application Application

screenKeywords:
-—_ RethI Apps Resources Database Query Library Workflows Upgrade Q (s~
Welcome to Retool, Jane! x
o 8 S]
Apps Database Resources
Create a web app or a native mobile app to build a custom Easily store data in a free SQL database and power your Securely connect your data and display it inside of Retool
internal tool for your business. Retool apps. apps.
Create aweb app -
Create a mobile app - Use Retool Database - Connect aresource -
s o Get started with Al
b @ y Start building with Al > Learn more X
. © © O¢ Retool Al gives you powerful building blocks - like LLM connectors and a vector database - to create Al- 9
powered applications and workflows.
7+ Introducing Retool Storage
Retool storage is a Retool-hosted file store. Using Retool Storage, you can upload and download files and use Try Retool Storage > Learn more X
N them in your apps and workflows.
Starred
All  Recent Starred Modules Folders Trash
Name v Updated Last Editor
o [Sample App] Users Dashboard +~ 15 minutes ago Jane Smith @
|-—_ RethI Apps Resources Database Query Library Workflows Upgrade Q (s~
7+ Introducing Retool Storage
Retool storage is a Retool-hosted file store. Using Retool Storage, you can upload and download files and use Try Retool Storage > Learn more X
N them in your apps and workflows.
Starred
=] =]
JMobbin Admin [Sample App] Users Dashboard
Al
All  Recent Starred Modules Folders Trash
Name v Updated Last Editor
o [Sample App] Users Dashboard +~ 13 minutes ago Jane Smith
DS Admin Module 8 minutes ago Jane Smith
ogo Block Form Request 20 minutes ago Jane Smith
(] JMobbin Admin 2 minutes ago Jane Smith
o JMobbin Admin - copy 11 minutes ago
o Title your first app 2 days ago Jane Smith @
|-—_ RethI Apps Resources Database Query Library Workflows Upgrade Q (s~
Create aweb app -
Create a mobile app - Use Retool Database - Connect aresource -
s s o . Get started with Al
. © @ © O¢ Retool Al gives you powerful building blocks - like LLM connectors and a vector database - to create Al- Start building with Al > Learn more X
powered applications and workflows.
7+ Introducing Retool Storage
Retool storage is a Retool-hosted file store. Using Retool Storage, you can upload and download files and use Try Retool Storage > Learn more X
N them in your apps and workflows.
Al
All  Recent Starred Modules Folders Trash
Name v Updated Last Editor
[Sample App] Users Dashboard 13 minutes ago Jane Smith Edit View
DS Admin Module 8 minutes ago Jane Smith
ogo Block Form Request 20 minutes ago Jane Smith
o JMobbin Admin a minute ago Jane Smith
o JMobbin Admin - copy 10 minutes ago
o Title your first app 2 days ago Jane Smith @
|-—_ RethI Apps Resources Database Query Library Workflows Upgrade Q (s~
Create aweb app -
Create a mobile app - Use Retool Database - Connect aresource -
s s o . Get started with Al
. © @ © O¢ Retool Al gives you powerful building blocks - like LLM connectors and a vector database - to create Al- Start building with Al > Learn more X
powered applications and workflows.
7+ Introducing Retool Storage
Retool storage is a Retool-hosted file store. Using Retool Storage, you can upload and download files and use Try Retool Storage > Learn more X
N them in your apps and workflows.
Al
All  Recent Starred Modules Folders Trash
Name v Updated Last Editor
(mm] [Sample App] Users Dashboard 13 minutes ago Jane Smith
DS Admin Module 8 minutes ago Jane Smith
ogo Block Form Request 20 minutes ago Jane Smith
o JMobbin Admin a minute ago Jane Smith
o JMobbin Admin - copy 10 minutes ago
o Title your first app 2 days ago Jane Smith @
|-—_ RethI Apps Resources Database Query Library Workflows Upgrade Q (s~
Create aweb app -
Create a mobile app - Use Retool Database - Connect aresource -
s o Get started with Al
b @ y Start building with Al > Learn more X
. © © O¢ Retool Al gives you powerful building blocks - like LLM connectors and a vector database - to create Al- 9
powered applications and workflows.
7+ Introducing Retool Storage
Retool storage is a Retool-hosted file store. Using Retool Storage, you can upload and download files and use Try Retool Storage > Learn more X
N them in your apps and workflows.
Starred
=]
[Sample App] Users Dashboard
Al
All  Recent Starred Modules Folders Trash
Name v Updated Last Editor @
[Sample App] Users Dashboard - 13 minutes ago Jane Smith Edit View
DS Admin Module 8 minutes ago Jane Smith G
o . e . e


Account settings

hotspotType: Scroll Vertically

screenElements: Button Pagination Badge

screenPatterns:
Timeline & History
My Account & Profile

screenKeywords:
== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
Account
Account
Users First name Last name Email
Permissions Jane Smith jsmith.mobbin2@gmail.com
Environments
IAM Credentials
Billing
Branding EBusiness Security
Themes Business Change Password
Source Control Enterprise
Advanced . .
Invalidate sessions
Bet Invalidate all sessions for your account. This will log you out of your current session.
Retool Events
Retool Al Invalidate all account sessions
Login history
jsmith.mobbin2@gmail.com
Logged in via password from 116.86.21.96
9 minutes ago
jsmith.mobbin2@gmail.com
Logged in via password from 116.86.21.96
5 days ago @
|I Count UserS All users Name m
Users

Permissions G Jane Smith admin
Environments

IAM Credentials

Billing

Branding Business

Themes Business

Source Control Enterprise

Advanced

Beta

Retool Events

Retool Al
|== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
Account
Account
Users First name Last name Email
Permissions Jane Smith jsmith.mobbin2@gmail.com
Environments
IAM Credentials
Billing
Branding EBusiness Security
Themes Business Change Password
Source Control Enterprise
Advanced . .
Invalidate sessions
Bet Invalidate all sessions for your account. This will log you out of your current session.
Retool Events
Retool Al Invalidate all account sessions
Login history
jsmith.mobbin2@gmail.com
Logged in via password from 116.86.21.96
5 days ago
Archive account @
Archive your account to be removed from this organization. You will be able to join other Retool organizations using the email
address jsmith.mobbin2@gmail.com . °
You are the only Admin in this organization. In Permission Groups, add at least one user to the Admin group before archiving
|== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
Account
Account
Users First name Last name Email
Permissions Jane Smith jsmith.mobbin2@gmail.com
Environments
IAM Credentials
Billing
Branding EBusiness Security
Themes Business Change Password
Source Control Enterprise
Advanced . .
Invalidate sessions
Bet Invalidate all sessions for your account. This will log you out of your current session.
Retool Events
Retool Al Invalidate all account sessions
Login history
jsmith.mobbin2@gmail.com
Logged in via password from 116.86.21.96
5 days ago
» root: {} 14 keys
6
Archive account G
Archive your account to be removed from this organization. You will be able to join other Retool organizations using the email
|== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
First name Last name Email
Account Jane Smith jsmith.mobbin2@gmail.com
Users
Permissions Security
Environments
Change Password
IAM Credentials
Billing
Branding (Business Invalidate sessions
Invalidate all sessions for your account. This will log you out of your current session.
Themes Business
Source Control  Enterprise Invalidate all account sessions
Advanced
Beta
Login history
Retool Events
REtoolAl jsmith.mobbin2@gmail.com
Logged in via password from 116.86.21.96
5 days ago
Archive account
Archive your account to be removed from this organization. You will be able to join other Retool organizations using the email
address jsmith.mobbin2@gmail.com .
You are the only Admin in this organization. In Permission Groups, add at least one user to the Admin group before archiving
yourself or archive the entire organization in Advanced.


Creating a workflow (AI)

screenPatterns:
Internal Tool
Loading

screenKeywords:
-—_ Jane Smith - Al Onboarding - Nov 8, 2023 5:58 PM Latest version deployed ~ (®) Run Deploy v
8
This workflow fetches the current weather and '+ Retool Al Actions '
uses Al to suggest an activity.
Press the P> play button to fetch the weather in San Francisco. Use Retool Al to sugg
€3 Scroll to your right to see the set up Reference the results of the previous block by Reference the previot
P> Press play button in each block sequentially This fetches the data from the Open-Meteo API. using fetchWeather directly in code. a
¢ startTrigger = - @ - fetchWeather = - @ » - getWeather = - @ » - ¢ generateActivities
Enabled triggers RESTQuery (restapi) JavaScript Retool Al
GET https://api.open- 1 const weatherData = fetchWeather.data Action
2
meteo.com/vl/forecast?
Edit triggers latitude=37.616&Longitude=-122.3833&cu 3 return weatherData.current_weather Generate text
rrent_weather=true&temperature_unit=fa Examples: Product desc
Test JSON Parameters hrenheit
. Inputs Settings nput
+ More options 1 What's a good
Explain your r
Inputs Settings 2
3 Weather:
4 {{getWeather.c
Getting Started % Use Retool Vector:
How would you like to start? Model
® Start from scratch © gpt-4
Build step by step
Inputs
BE Use a template
Common use cases
¢ Generate with Al Beta
Build using a prompt
ﬁ@ — 100% 3 % ¢ X B3 1ul
@ production Run history
|== Jane Smith - Al Onboarding - Nov 10, 2023 6:05 PM ®
- @ » - restQuery2 - @ » - <> AlQuery - @ » -
saScript RESTQuery (restapi) Retool Al Edit
restQuery.datal0]; GET https://hacker- Action
news.fir‘ebase:i:o.com/vﬁ/item/{{ Generate text
code.data }}.json
Examples: Product description
-+ More options
Input
Inputs Settings 1 Write text or use {{ }} to reference data
System Message
< Generate with Al X 1 Write text or use {{ }} to reference data
. Temperature
Email me a summary of the top
HackerNews story every morning. 1
Use Retool Vectors to provide more context to your query
Model
& opt-4
Inputs Settings
Z Generating Esc
ﬁ@ — 100% 3 % ¢ X B3 1ul
@ production Run history
|== Jane Smith - Al Onboarding - Nov 10, 2023 6:05 PM ®
This workflow fetches the current weather and
uses Al to suggest an activity.
€3 Scroll to your right to see the set up
P> Press play button in each block sequentially
4% startTrigger = - @ -
Enabled triggers
Edit triggers
Test JSON Parameters
< Generate with Al X
Email me a summary of the top
HackerNews story every morning.
() Generating Esc
ﬁ@ — 100% 3 % ¢ X B3 1}
@ production Run history
|-—_ Jane Smith - Al Onboarding - Nov 10, 2023 6:09 PM Latest version deployed ~ (®) Run Deploy v
8
This workflow fetches the current weather and '+ Retool Al Actions '
uses Al to suggest an activity.
Press the P> play button to fetch the weather in San Francisco. Use Retool Al to sugg
€3 Scroll to your right to see the set up Reference the results of the previous block by Reference the previot
P> Press play button in each block sequentially This fetches the data from the Open-Meteo API. using fetchWeather directly in code. a
¢ startTrigger = - @ - fetchWeather = - @ » - getWeather = - @ » - ¢ generateActivities
Enabled triggers RESTQuery (restapi) JavaScript Retool Al
GET https://api.open- 1 const weatherData = fetchWeather.data Action
2
meteo.com/vl/forecast?
Edit triggers latitude=37.616&Longitude=-122.3833&cu 3 return weatherData.current_weather Generate text
rrent_weather=true&temperature_unit=fa Examples: Product desci
Test JSON Parameters hrenheit
. Inputs Settings nput
+ More options 1 What's a good
Explain your r
Inputs Settings 2
3 Weather:
4 {{getWeather.c
i X
&« Generate with Al System Message
Email me a summary of the top 1 Write text or
HackerNews story every morning.
Temperature
1 1
Use Retool Vector:
Model
& opt-4
Inputs
ﬁ@ — 100% 3 % ¢ X B3 1}
@ production Run history
|= O Jane - Al Template App - November 8th 2023, 5:54:37 pm Q B m
® Components Modules 57 <« . S
No components X » |
Q [search components 5 ) ) A
e Build Al-powered apps with Al Actions ,
No components selected
Commonly used This guide shows you how to use Al Actions to build apps. i
<> !
New
g —) .
BEY| | fus .
{i} (6 J |
Table Text Button o Generate text 4 Edit or preview the app by toggli |
® -
*—1) | =5 3
@ = Input & Prefill with example Output
Text Input Number Select Enter input to generate text )
Input |
Container Form Tabbed
ISHET AliEE _ .
© Summarize text |
& <+ X |
@ Input & Prefill with example Output ;
< !
Enter input to summarize text N
Get started with Al .
- Learn how to use Al in Retool |
+ Al Actions .
E " Retool Vectors i
Build a Q&A app with your data j
@ Extract entity from text j
Al Workflows .
Automate your Al processes A
"~ Altemplates Input & Prefill with example Output |
See what you can do with Al Enter input to extract entity root: null .
" Learn more |
IS 100% -+ 1
TORTTIrow TORTTTPWT T B :.7. B B B i B B B B B B B B B B B B B B B B B B
© Latest No queries running fDebug O @


Permission group detail

screenPatterns:
Settings & Preferences
Subscription & Paywall

screenKeywords:
== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
AT For this default permissions group, access rules cannot be modified @
sers
In addition, members of this group can modify all aspects of Retool, including org-wide settings.

Admin

Members Apps Resources Workflows Additional

All users + Add new
@ Jane Smith
|== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN

Admin

AT For this default permissions group, access rules cannot be modified @

sers
In addition, members of this group can modify all aspects of Retool, including org-wide settings.

Admin

Members Apps Resources Workflows Additional
All users + Add new

@ Jane Smith
© Jon smitn
|-—_ RethI Apps Resources Database Query Library Workflows Upgrade Qs ~

Admin

AT For this default permissions group, access rules cannot be modified @

sers
In addition, members of this group can modify all aspects of Retool, including org-wide settings.

Admin
Members Apps Resources Workflows Additional
Workspace homepage
Set a home page for this workspace to have users in this group automatically be routed to a certain app Nene
on login. You can only select from apps this group has access to. Membership in groups with different
permissions may prevent a user from being sent to this group's homepage.
Query library
The Retool Query Library is a place to query anything from databases to APIs and easily share those Edit queries
queries with your team.
Settings page visibility
Release Versions
|== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
Admin
AT For this default permissions group, access rules cannot be modified @
sers
In addition, members of this group can modify all aspects of Retool, including org-wide settings.
Admin
Members Apps Resources Workflows Additional
All users + Add new
@ Jane Smith
© Jon smitn
Edit and view details
Copy reset password link
Remove from group
Disable user
|== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN

Admin

AT For this default permissions group, access rules cannot be modified @

sers
In addition, members of this group can modify all aspects of Retool, including org-wide settings.

Admin

Members Apps Resources Workflows Additional
All users + Add new

@ Jane Smith
© Jon smitn
|== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
Admin
AT For this default permissions group, access rules cannot be modified ®
sers
In addition, members of this group can modify all aspects of Retool, including org-wide settings.
Admin
Members Apps Resources Workflows Additional
All apps
Expand all folders
() archive
[ Fowl x Pottery
oL Block Form Request
) JMobbin Admin - Backup
3 JMobbin Admin Panel
3 Jane - Al Template App - November 10th 2023, 5:59:31 pm
3 Jane - Al Template App - November 10th 2023, 6:09:07 pm
(3 Jane - Al Template App - November 8th 2023, 5:54:37 pm
3 Jane - Al Template App - November 8th 2023, 5:56:30 pm
(3 Jane - Al Template App - November 8th 2023, 5:56:50 pm
3 Jane - Al Template App - November 8th 2023, 5:57:56 pm
(3 Jane - Al Template App - November 8th 2023, 5:58:21 pm
3 Jane - Al Template App - November 8th 2023, 6:00:25 pm
[ [Sample App] Users Dashboard
|-—_ Retool Apps Resources Database Query Library Workflows Upgrade Q (s~

Permission Groups

Account
I Granular access controls are not available in your plan.
Upgrade now

Users Upgrade to create custom groups.
Permissions
Environments
IAM Credentials All Users
Billing

Admin e
Branding Business
Themes Business
Source Control Enterprise
Advanced
Beta
Retool Events
Retool Al


Inserting a table component

hotspotType: Drag

screenElements: Popover Checkbox

screenElements: Table Avatar Chip

screenElements: Table Avatar Chip Popover Checkbox Drawer

screenKeywords:
= B JMobbin Admin Q8 m
@ BlockTable Q e 2 »
Iy JMobbin Admin
Interaction =
<> 7 7 Event handlers +
ID Name Email Blocked
{i} 1 HershelMcV.. etexton2d@.. Select row getUsers.trigger()
O] 2 Gayel Coton ekeitley3v@... v Default filters 2+
S 3 Imogene Sch... ckiddey64@... v Nofilters
4 Anita Oliver tmordy6l@m... v Default operator And or
5 Costa Spata kesposilc@... v Row selection Single Multiple  None
6 CatharinaM... uqueree69@... Default row Index Key None
7 Booth Macg... sloache34@... Default index 0
[ ’ Index type Displa Data
50 results Y &L O P =
O S Persist row selection
Cell selection Single None
Search Fuzzy match
Search term
Accent [ ]
Appearance Alternate row bac... /
Height Background
Row height ¢ Border
Border radius r
Show table border
Cell text
Row color
w Header background
Hidden T Header text
Styles 2 +
<> — 100% None
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
(17 table2 Q - X »
. .
QU search componerts JMobbin Admin
I'_"Y Content =
</® Data Data source Demo data
ID Name Email Blocked
And  Or i
f JSON Primary ke ID
{ |I| — 1  Hershel McV... etexton2d@... v Y&y #
: Columns e § D
@ Chart Filter JSON 2  Gayel Coton ekeitley3v@... v “ S+
Explorer
& - 3 Imogene Sch.. ckiddey64@.. v 41D
. . 2 User
4 Anita Oliver tmordy6l@m...
&’ Role
Remﬂz[able Teble 5 Costa Spata kesposilc@... v
Enabled
. 6 Catharina M...  uqueree69@... v
Presentation Created at
7 Booth Macg... sloache34@...
(0 Teams
1= [ e o
- - A d a [ S B P B B -
Q .
50 results Y L O ) Website
Alert Avatar Avatar Group
L. Bio
New
@ T Unblock user v Actions +
Calendar Circular Divider No actions
Image
@ @ ID User Role Enabled Created at Teams Add-ons +
@ Ca)Ca) 0 () ISR Viewer v Jan 16,2023  Workplace Infrastructure Toolbar Filter, Download, ..
chic.footitt@yahoo.com
Icon Image Image Grid
Kenton Worling " . -
1 KW . Viewer Dec 24,2021 Workplace Interaction o
- 20% kentonworling@yahoo.com
30% y
“ J Evelina Fender Event handlers +
PDF Progress Bar Prgig:;f:s 2 EF efender@outlook.com Editor v Jan 3, 2022 Product Sales Trigger queries, control components, or call
other APIs in response to component events.
3 LS Le>.(|s Speers» Admin v Dec 13,2022 Infrastructure  Design )
$1,000 lexisspeers@icloud.com Default filters 2 +
- ioni No filters
QR Code Spacer Statistic 4 (ka  KentonAntonioni Admin v Apr 15,2022  Success Recruiting ~Data
kenton.antonioni@icloud.com
[x] Default operator And Or
Tag Tag MJ
<> g Tag Tag — 100% 100 results Y &L O
atis Tans Tevxt
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ BlockTable Q e 2 »
Iy JMobbin Admin
» . N
Interaction 4
<5 I 1| E handl
D Name Email Blocked vent handlers +
{i} 1 HershelMcV... etexton2d@.. Select row getUsers.trigger()
\9 2 Gayel Coton ekeitley3v@... v Default filters 2 +
& 3 Imogene Sch... ckiddey64@.. v Advanced x No filters
4 Anita Oliver tmordy6l@m... v Default operator And or
Show column headers
5 Costa Spata kesposilc@... v Row selection Single Multiple None
Show footer
6 CatharinaM...  uqueree69@.. Default row Index Key None
Show column borders
7 Booth Macg... sloache34@... Default index 0
Automatic column width
B o Index type Display Data
4
50 results Yy & 0 Maintain space when hidden
O O . N
Persist row selection
Always show in edit mode
Cell selection Single None
Margin type Normal None
Search Fuzzy match
Show on desktop
Search term
Show on mobile
~ Appearance =
Height Auto Fixed
Row height Small (32px)
Show table border
Row color
Hidden false
Styles 2 +
<> — 100%
None
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ table1 Q e 2 »
. .
Iy JMobbin Admin Content =
° Data source getUsers
<D
ID Name Email Blocked Primary key D
{i} 1 Hershel McV... etexton2d@...
@ Columns e 8 O 4
) 2 Gayel Coton ekeitley3v@... v D
@ 3 Imogene Sch... ckiddey64@... v ~ Name e X
4 Anita Oliver tmordy6l@m... v N Email
5 Costa Spata kesposilc@... v Blocked
6 Catharina M...  uqueree69@... v Actions +
7 Booth Macq.. sloache34@... No actions
~ [ T N R P ) - Add_ons +
50 results Y &L O
O o Toolbar Filter, Download, ..
Save actions patchUser.trigger()
Interaction =
Event handlers +
Select row getUsers.trigger()
Default filters 2 +
No filters
Default operator And Or
Row selection Single Multiple None
Default row Index Key None
Default index 0
<> — 100% Index type Display Data
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ BlockTable Q e 2 »
Iy JMobbin Admin
v ) N
Interaction 4
<5 I 1| E handl
D Name Email Blocked vent handlers +
{i} 1 HershelMcV... etexton2d@.. Select row getUsers.trigger()
\9 2 Gayel Coton ekeitley3v@... v Default filters 2 +
& 3 Imogene Sch.. ckiddey64@.. v No filters
4 Anita Oliver tmordy6l@m... v Default operator And or
5 Costa Spata kesposilc@... v Row selection Single Multiple None
6 CatharinaM...  uqueree69@.. Default row Index Key None
7 Booth Macg... sloache34@... Default index 0
50 results Y L 5 Index type Display Data
© © Persist row selection
Cell selection Single None
Search Fuzzy match
Search term
Appearance =
Height Auto Fixed
Row height Small (32px)
Show table border
Row color
Hidden false
Styles 2 +
<> — 100%
None
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
(17 table1 Q - X »
. .
Q search compnents JMobbin Admin
I'_"Y Content =
Commonly used
4 T i Data source i} getUsers @©
New Ao ID Name Email Blocked
0 m Primary key D
! 1 Hershel McV... etexton2d@...
Table Text Button
- Columns e QY
O] 2 Gayel Coton ekeitley3v@... v ! S+
@ T—1)| |[#—1| = 3 Imogene Sch.. ckiddey64@.. v # 1D
Name
Text Input Number Select 4 Anita Oliver tmordy6l@m... T
Input
& Email
5 Costa Spata kesposilc@... v
£ 8 Blocked
- 6 Catharina M... uqueree69@...
Container Form Tabbed Actions +
Container 7 Booth Macq... sloache34@...
No actions
4
= |I| D 50 results Y & O Add-ons +
O O
Modal Chart Key Value Toolbar Filter, Download, ..
(&) =
Interaction =
Image Navigation Event handlers +
Text inputs Trigger queries, control components, or call
other APIs in response to component events.
T $ T s & —I Default filters 2 +
Editable Text Editable Text  Email No fliters
Area
Default operator And Or
BIu”
{3 Pl
I I Row selection Single Multiple  None
JSON Edif P d  Rich T
ttor. Passwor 'Edit:,“ Default row Index Key None
T Default index ]
- I av l; ®—I
<> - 100% Index type Display Data
Text Area Text Input URL
© Latest No queries running & fDebug O @
|= B JMobbin Admin Q 8 m
@ Components Modules 57 <«
T text1 Q s X »
. .
Q. Search components JMobbln Admln |
I-_VY = Content
Commonly used
<? Value (73] Markdown  Plain text
New
{} e @ ## {{ retoolContext.appName }}
1
Table Text Button Add-ons +
O
= None
@ 10— b I .
Text Input Number Select Appearance =
Input
Image width Fit Fill
A B
- Height Auto Fixed
Container Form Tabbed N
Container Alignment le sl B
Hidden false
S ES
— Styles 2 +
Modal Chart Key Value
None
(&) =
Image Navigation
Text inputs
T £ T s S —I
Editable Text Editable Text Email
Area
BIu”
{3 ; Pl 1
JSON Editor  Password Rich Text
Editor
T.
e T—1 ®—1I
<> — 100%
Text Area Text Input URL
© Latest No queries running & fEDebug O @


Sidebar (workflows)

screenElements: Card Switch

screenPatterns:
Code Editor
Help & Support

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

screenKeywords:
-
- tD Workflow - Jane Smith - Nov 8, 2023 6:43 PM Undeployed changes  (®) Run Deploy v
@ Outline X
%8 ==
_ Filter
4% startTrigger
f £} fetchWeather
& getWeather
<> generateActivities
® £ sendEmail
O
4% startTrigger - @ - code1 - @ b e
Enabled triggers JavaScript
No triggers enabled 1v return [
2 { message: "Hello from Workflows" },
Edit triggers 3 { message: "Click the Run (») button to execute
this block" },
Test JSON Parameters 4 { message: "Drag from the green sequence port to
connect a new block" },
) 5 { message: "Click the help (?) button to learn
{"webhookParaml val } more" },
6 Ii
Inputs Settings o
kg - 100% + 3 % ¢ X & m
® production O Run history
|- LD Workflow - Jane Smith - Nov 8, 2023 6:43 PM Undeployed changes  (®) Run Deploy v
o Deploy History X
) og ==
— v0.0.1 Deployed
"~ Jane Smith - on Nov 8 at 6:...
F
i code1
@ 4% startTrigger - o -0
JavaScript
@ Enabled triggers
1v return [
5] At12:00 AM, every day 2 { message: "Hello fr
3 { message: "Click tt
Edit triggers this block" },
4 { message: "Drag frc
Test JSON Parameters connect a new block" ]
5 { message: "Click tt
more" },
{"webhookParaml": "value"} 6 1;
Inputs Setting:
kg - 100% + 3% ¢ X & m
® production {9 Run history
|-_ (D Jane Smith - Al Onboarding - Nov 8, 2023 6:00 PM Undeployed changes  (®) Run Deploy v
D Outline X ¢ startTrigger * og N
Filter startTrigger > e
¢ startTrigger Enabled triggers
f [+ fetchWeather
No triggers enabled
& getWeather
<> generateActivities Edit triggers
@ i
. & sendEmail Test JSON Parameters
)
W
{"webhookParaml": "value"}
4% startTrigger - @ - code1
Enabled triggers JavaScript
No tric I 1v return [
2 { message: "Hello from Worl
Edit triggers 3 { message: "Click the Run |
this block" },
Test JSON Parameters 4 { message: "Drag from the
connect a new block" },
5 { message: "Click the help
ookPara ) nore” 1,
6 1;
Inputs Settings
®
ke - 100% + 3% ¢ X &
® production O Run history
|-_ [D Workflow - Jane Smith - Nov 8, 2023 6:43 PM Undeployed changes  (®) Run Deploy v
Blocks X
® g 2
- 8
f Resource Code
query
Workflow Al Action
O
Filter Branch
4% startTrigger - @ - code1 - @ » e
Enabled triggers JavaScript
Loop No triggers enabled 1v return [
2 { message: "Hello from Workflows" },
Edit triggers 3 { message: "Click the Run (») button to execute
this block" },
Test JSON Parameters 4 { message: "Drag from the green sequence port to
R connect a new block" },
esponse .
S { message: "Click the help (?) button to learn
{"webhookParaml": "value"} more" }
'
6 1;
Inputs Settings o
®
g - 100% + 3 % ¢ X B3 jiul
® production O Run history
|-—_ Workflow - Jane Smith - Nov 8, 2023 6:43 PM Undeployed changes  (® Run Deploy v
Libraries + X
8
JavaScript
lodash 4.17.21
numbro 2.1.0
papaparse 5.3.2 code1
@ moment-timezone 0.5.23 © startTrigger - @ -0 )
JavaScript
uuid 3.4.0 Enabled triggers
1v return [
At 12:00 AM, every day 2 { message: "Hello fr
3 { message: "Click tt
Edit triggers this block" },
4 { message: "Drag frc
Test JSON Parameters connect a new block" ]
5 { message: "Click tt
more" },
6 1;
Inputs Setting:
g — 100% HH % ¢ X B3 i}
@ production Run history
|-—_ tD Workflow - Jane Smith - Nov 8, 2023 6:43 PM Undeployed changes  (® Run Deploy v
® g &=
O
4% startTrigger - @ - code1 - @D > -
Enabled triggers JavaScript
No triggers enabled 1v return [
2 { message: "Hello from Workflows" },
Edit triggers & { message: "Click the Run (») button to execute
this block" },
Test JSON Parameters 4 { message: "Drag from the green sequence port to
connect a new block" },
5 { message: "Click the help (?) button to learn
{"webhookParaml": "value"} more" },
6 1;
Inputs Settings o
2
g - 100% + O3 % ¢ X B3 1}
® production {9 Run history
|-—_ 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 Workflow - Jane Smith - Nov 8, 2023 6:43 PM Undeployed changes  (® Run Deploy v
Functions + X -
@ ® %8 S=
JC No functions
Functions let you reuse code or
¢ queries across multiple blocks.
4% startTrigger - @ - code1 - @D > -
Q Create function
Enabled triggers JavaScript
L
O No triggers enabled 1v return [
2 { message: "Hello from Workflows" },
Edit triggers & { message: "Click the Run (») button to execute
this block" },
Test JSON Parameters 4 { message: "Drag from the green sequence port to
connect a new block" },
5 { message: "Click the help (?) button to learn
{"webhookParaml": "value"} more" },
6 1;
Inputs Settings o
2
ﬁ@ - 100% + 3 % ¢ X B3 1ul
® production {9 Run history
|'—_ Jane Smith - Send Slack Message When Google Sheet Rows Added - Nov 8, 2023 6:43 PM Undeployed changes
Hel, X
P og
» Your first workflow (4 min)
More quick videos Add any addition
5] Loop block Modify Google Sheet inputs below and press ». Ensure there is there is an addec
P Schedule the cron job to run at your desired an addedOn field in your Google Sheet to identify new records identify new recc
[>] Branch block interval. and the timestamp is in UTC with Z at end. with Z at end.
[*] Functions
¢ startTrigger = - @ - E getRowsFromGoogleSheet = - @ » - processData
Workflows
38 Keyboard shortcuts Enabled triggers [demo resource] Google Sheets Edit JavaScrip
[IJ Documentation Action type 1 let data :
2
General Edit triggers Read data from a spreadsheet 3 peturn da
S dsheet moment(x.:
readshee!
DJ Ask Retool developers Test JSON Parameters P! moment() .
i fx
59 Email support Inputs
@ Submit feedback Sheet name
@ Report abuse 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 Workflow - Jane Smith - Nov 8, 2023 6:43 PM Undeployed changes  (® Run Deploy v
Triggers + X -
@ [els] ® %8 S=
_ Webhook
T & httpsi//apiretool... -
Jc Schedule
& B At12:00 AM, eve... -
code1
Q 4% startTrigger - o - |0
JavaScript
@ Enabled triggers
1v return [
No triggers enabled 2 { message: "Hello fr
3 { message: "Click tt
Edit triggers this block" },
4 { message: "Drag frc
Test JSON Parameters connect a new block" ]
5 { message: "Click tt
more" },
{"webhookParaml": "value"} 6 1;
Inputs Setting:
ﬁ@ - 100% + (3 % ¢ X B3 1ul
® production {9 Run history


Logging in

screenElements:
Top Navigation Bar
Logo
Card
Banner
Floating Action Button

screenPatterns:
Home
Feature Info

screenPatterns:
Error
Home
Feature Info
Login
Verification

screenKeywords:
by,
&= Retool (\\ ‘()\
I
L
Welcome back .~ \
an
o =
—
Enter the email and password for your account [
[romegeomparcon ] ’
Email required
Quickly build internal tools and dashboards, using your
[ ] team's own data and integrations,
Password required
Need help logging in? Reset your password.
|== Retool Apps  Resources  Database  QueryLibrary = Workflows Upgrade [ORNINEIES
+ Success!
Welcome to Retool!
|-—_ 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
|Enter your verification code
Please enter your code from your authenticator app.
123456
Verify Token
|by,
== Retool (g :(\
Ny Ut
Welcome back -
NS
: —
4
Enter the email and password for your account U [
jsmith.mobbin2@gmail.com '
Quickly build internal tools and dashboards, using your
= team's own data and ntegrations.
Need help logging in? Reset your password.
|by,
== Retool (g :(\
A
Welcome back “w
NS
: —
4
Enter the email and password for your account U [
v
Quickly build internal tools and dashboards, using your
= team's own data and ntegrations.
Need help logging in? Reset your password.
|Enter your verification code
Please enter your code from your authenticator app.
049653
Verify Token


Filtering table

pageType: Application Application Application Application Application Application Application Application

screenKeywords:
= B JMobbin Admin Q8 m
@ BlockTable Q e 2 »
Iy JMobbin Admin
» . N
Interaction 4
<5 I 1| E handl
D Name Email Blocked vent handlers +
{i} 1 HershelMcV... etexton2d@.. Edit filter o Selectrow getUsers.trigger()
\9 2 Gayel Coton ekeitley3v@... v Yefault filters 2 +
Column Select an option
@ 3 Imogene Sch... ckiddey64@... v No column includes() X
) . Operator includes
4 Anita Oliver tmordy6l@m... v Yefault operator And or
Value
5 Costa Spata kesposilc@... v . i .
tow selection Single Multiple  None
6 Catharina M...  uqueree69@... v
Default row Index Key None
7 Booth Macg... sloache34@...
Default index 0
50 results Y L O Index type Display Data
O O
Persist row selection
Cell selection Single None
Search Fuzzy match
Search term
Appearance =
Height Auto Fixed
Row height Small (32px)
Show table border
Row color
Hidden false
<> — 100% Styles 2 +
None
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ BlockTable Q e 2 »
Iy JMobbin Admin
» . N
Interaction 4
<5 I 1| E handl
D Name Email Blocked vent handlers +
i 1 Hershel McV... etexton2d@... Edit filter «  Selectrow getUsers.trigger()
\9 2 Gayel Coton ekeitley3v@... v Yefault filters 2 +
Column ID
@ 3 Imogene Sch... ckiddey64@... v ID >(0) X
4 Anita Oliver tmordy6l@m... v Yefault operator And or
Value
5 Costa Spata kesposilc@... v . i .
tow selection Single Multiple  None
6 Catharina M...  uqueree69@... v
Default row Index Key None
7 Booth Macg... sloache34@...
Default index 0
50 results Y L O Index type Display Data
O O
Persist row selection
Cell selection Single None
Search Fuzzy match
Search term
Appearance =
Height Auto Fixed
Row height Small (32px)
Show table border
Row color
Hidden false
<> — 100% Styles 2 +
None
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ BlockTable Q e 2 »
Iy JMobbin Admin
» . N
Interaction 4
<5 I 1| E handl
D Name Email Blocked vent handlers +
{i} 1 HershelMcV... etexton2d@.. Edit filter o Selectrow getUsers.trigger()
\9 2 Gayel Coton ekeitley3v@... v Yefault filters 2 +
@ 3 Imogene Sch... ckiddey64@... v ID includes() X
) . Operator includes
4 Anita Oliver tmordy6l@m... v Yefault operator And or
Value
5 Costa Spata kesposilc@... v . i .
tow selection Single Multiple  None
6 Catharina M...  uqueree69@... v
Default row Index Key None
7 Booth Macg... sloache34@...
Default index 0
50 results Y L O Index type Display Data
O O
Persist row selection
Cell selection Single None
Search Fuzzy match
Search term
Appearance =
Height Auto Fixed
Row height Small (32px)
Show table border
Row color
Hidden false
<> — 100% Styles 2 +
None
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ BlockTable Q e 2 »
Iy JMobbin Admin
v ) N
Interaction 4
<5 I 1| E handl
D Name Email Blocked vent handlers +
{i} 1 HershelMcV... etexton2d@.. Select row getUsers.trigger()
\9 2 Gayel Coton ekeitley3v@... v Default filters 2 +
& 3 Imogene Sch.. ckiddey64@.. v No filters
4 Anita Oliver tmordy6l@m... v Default operator And or
5 Costa Spata kesposilc@... v Row selection Single Multiple None
6 CatharinaM...  uqueree69@.. Default row Index Key None
7 Booth Macg... sloache34@... Default index 0
50 results Y L 5 Index type Display Data
© © Persist row selection
Cell selection Single None
Search Fuzzy match
Search term
Appearance =
Height Auto Fixed
Row height Small (32px)
Show table border
Row color
Hidden false
Styles 2 +
<> — 100%
None
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ BlockTable Q e 2 »
Iy JMobbin Admin
» . N
Interaction 4
<5 I 1| E handl
D Name Email Blocked vent handlers +
i 1 Hershel McV... etexton2d@... Edit filter «  Selectrow getUsers.trigger()
\9 2 Gayel Coton ekeitley3v@... v Yefault filters 2 +
Column ID
@ 3 Imogene Sch... ckiddey64@... v ID >(0) X
) . Operator >
4 Anita Oliver tmordy6l@m... v Yefault operator And or
Value 0
5 Costa Spata kesposilc@... v . i .
tow selection Single Multiple  None
6 Catharina M...  uqueree69@... v
Default row Index Key None
7 Booth Macg... sloache34@...
Default index 0
50 results Y L O Index type Display Data
O O
Persist row selection
Cell selection Single None
Search Fuzzy match
Search term
Appearance =
Height Auto Fixed
Row height Small (32px)
Show table border
Row color
Hidden false
<> — 100% Styles 2 +
None
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ BlockTable Q e 2 »
Iy JMobbin Admin
» . N
Interaction 4
<5 I 1| E handl
D Name Email Blocked vent handlers +
i 1 Hershel McV... etexton2d@... Edit filter «  Selectrow getUsers.trigger()
\9 2 Gayel Coton ekeitley3v@... v Yefault filters 2 +
Column ID
@ 3 Imogene Sch... ckiddey64@... v ID includes() X
) . Operator includes
4 Anita Oliver tmordy6l@m... v = Yefault operator And or
Value
5 Costa Spata kesposilc@... v . i .
>= tow selection Single Multiple  None
6 Catharina M...  uqueree69@... v
N Default row Index Key None
7 Booth Macg... sloache34@...
- Default index ]
50 results Y L O ‘ Index type Display Data
i i is
Persist row selection
is not
Cell selection Single None
includes
Search Fuzzy match
Search term
Appearance =
Height Auto Fixed
Row height Small (32px)
Show table border
Row color
Hidden false
<> — 100% Styles 2 +
None
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ BlockTable Q e 2 »
Iy JMobbin Admin
v ) N
Interaction 4
<5 I 1| E handl
D Name Email Blocked vent handlers +
i 1 Hershel McV... etexton2d@... Edit filter «  Selectrow getUsers.trigger()
\9 2 Gayel Coton ekeitley3v@... v Yefault filters 2 +
Column elect an option
@ 3 Imogene Sch... ckiddey64@... v No column includes() X
) . Operator ID
4 Anita Oliver tmordy6l@m... v Yefault operator And or
Value
5 Costa Spata kesposilc@.. v Name _ i .
tow selection Single Multiple  None
6 Catharina M...  uqueree69@... v Email
Default row Index Key None
7 Booth Macq...  sloache34@... Blocked
Default index 0
50 results Y L O Index type Display Data
O O
Persist row selection
Cell selection Single None
Search Fuzzy match
Search term
Appearance =
Height Auto Fixed
Row height Small (32px)
Show table border
Row color
Hidden false
<> — 100% Styles 2 +
None
© Latest No queries running & wDebug O @
|= B JMobbin Admin Q8 m
@ BlockTable Q e 2 »
Iy JMobbin Admin
v ) N
Interaction 4
<5 I 1| E handl
D Name Email Blocked vent handlers +
{i} 1 HershelMcV... etexton2d@.. Select row getUsers.trigger()
\9 2 Gayel Coton ekeitley3v@... v Default filters 2 +
@ 3 Imogene Sch... ckiddey64@... D >(0) X
4 Anita Oliver tmordy6l@m... v Default operator And or
5 Costa Spata kesposilc@... v . i .
Row selection Single Multiple  None
6 Catharina M...  uqueree69@... v
Default row Index Key None
7 Booth Macg... sloache34@...
Default index 0
50 results Y L O Index type Display Data
O O
Persist row selection
Cell selection Single None
Search Fuzzy match
Search term
Appearance =
Height Auto Fixed
Row height Small (32px)
Show table border
Row color
Hidden false
<> — 100% Styles 2 +
None
© Latest No queries running & wDebug O @


Editing app details

screenElements:
Dialog
Text Field

screenPatterns:
Edit
Subscription & Paywall

screenKeywords:
&= JMobbin Admin Panel QB m
@ Code P« No components L o»
Showing 1 Q = +
e No components selected
{7} getUsers
<2
{i}
O
<> — 100%
© Latest Running getUsers: 0.5s fDebug O @
|Edit app details X
Title JMobbin Admin Panel
Description Enter a short description for this app
Max 255 characters
Editor README Last updated on Nov 9 at 5:02PM by you
Enter description here
User documentation
This feature is not available in your plan.
|Edit app details X
Title JMobbin Admin
Description Enter a short description for this app
Max 255 characters

Editor README Last updated on Nov 9 at 5:02PM by you

#### README

A README is ideal for providing information to the other editors of your app.

**Type some markdown herex* to start writing your README.
User documentation

This feature is not available in your plan.
|= O JMobbin Admin QB m
@ Code P« No components L o»
Showing 1 Q = +
e No components selected
{7} getUsers 0.6s
<2
{i}
O
<> — 100%
© Latest No queries running & fkDebug O @
|= O © JMobbin Admin QB m
® Code L« Edit app details No components L o»
Showing 1 Q = +
I__;" No components selected
{7} getUsers 0.6s
<2
{i}
O
<> — 100%
© Latest No queries running & fDebug O @


Duplicating a query

hotspotType: Right Click

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


Editing a table column

screenElements: Select Drawer

pageType: Application Application Application Application Application Application

screenKeywords:
= O JMobbin Admin QB m
@ Components Modules 57 <«
D tablel > Email e X »
. .
Q search compnents JMobbin Admin
I'_"Y Content
Commonly used
[ J Q O .
<I; Source email
New 3o ID Name Email Blocked
{} m ID email
! 1 Hershel McV... etexton2d@...
Table Text Button Label Email
) 2 Gayel Coton ekeitley3v@... v
= Format Link
@ T—1)| |[# =1 | == 3 Imogene Sch... ckiddey64@... v Itn
Textinput  Number  Select 4 AnitaOliver  tmordy6l@m.. Mapped value " string
nput
5 Costa Spata kesposilc@... v Add-ons - Multiline String
A B
- 6 Catharina M... uqueree69@... 4 Number
Container Form Tabb_ed 7 Booth Macq sloache34@
Container Interaction 9/ Percent
oMt . - Event handlers
|I| D 50 results Y &L O «> Progress
[ ] i S Trigger queries
Modal Chart Key Value other APIs in reg %) Currency
ABC Appearance [ Date
Image Navigation Background
. Text
Text inputs
Underline On hover
T ST K4 S —I
Hidden false
Editable Text Editable Text Email
Area Align le sle >
BIu”
{3 I Dol 1 Pin column | - 5|
JSON Editor  Password Rich Text
Editor
| IE=D R=T
<> — 100%
Text Area Text Input URL
© Latest No queries running & fDebug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
(17 table1 Q - X »
. .
Q search compnents JMobbin Admin
I'_"Y - Content =
Commonly used
4 T i Data source i} getUsers @©
New Ao ID Name Email Blocked
0 m Primary key D
! 1 Hershel McV... etexton2d@...
Table Text Button
- Columns e QY
O] 2 Gayel Coton ekeitley3v@... v S+
@ T—1)| |[#—1| = 3 Imogene Sch.. ckiddey64@.. v # 1D
~ Name
Text Input Nlumbter Select 4 Anita Oliver tmordy6l@m... B
npu .
& Email 00 52
5 Costa Spata kesposilc@... v
£ 8 Blocked
- 6 Catharina M... uqueree69@...
Container Form Tabbed Actions +
Container 7 Booth Macg... sloache34@...
No actions
4
= |I| D 50 results Y & O Add-ons +
O O
Modal Chart Key Value Toolbar Filter, Download, ..
Save acti... ! No save handler
(&) =
Image Navigation - Interaction s
Text inputs Event handlers +
Trigger queries, control components, or call
T PAREY s = —1 other APIs in response to component events.
Editable Text Editable Text Email Default filters @ +
Area N
No filters
BIu”
O I Pl I Default operator And Or
JSON Editor ~ Password Rich Text Row selection Single Multiple  None
Editor
Default row Index Key None
T.
- I av l; ®—I
<> — 100% Default index 0
Text Area Text Input URL
© Latest No queries running & fDebug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
D tablel > Email e X »
. .
Q search compnents JMobbin Admin
I'_"Y Content
Commonly used
[ J Q O .
<I; Source email
New 3o ID Name Email Blocked
{} m ID email
! 1 Hershel McV... etexton2d@...
Table Text Button Label Email
) 2 Gayel Coton ekeitley3v@... v
= Format Link
T—1)| |[# =1 | == 3 Imogene Sch... ckiddey64@... v "
@ |~] Boolean
Textinput  Number  Select 4 AnitaOliver  tmordy6l@m.. Mapped value
Input ’ Tag
. Add-ons
5 Costa Spata kesposilc@... v
A B
. {0 Tags
- 6 Catharina M... uqueree69@...
Container Form Tabbed
Container 7 Booth Macq...  sloache34@... Interaction (4 Icon
oMt St B Event handlers £ Avatar
|I| D 50 results Yy &L O
— o O T:ggz}«lqu'enes: (2 Image
Modal Chart Key Value other S Inred
& Link
A BC Appearance
Image Navigation Background
. Text
Text inputs
Underline On hover
T ST K4 S —I
Hidden false
Editable Text Editable Text Email
Area Align le sle -
BIu”
{3 1 ool 1 Pin column |e - 5|
JSON Editor  Password Rich Text
Editor
| IE=D R=T
<> — 100%
Text Area Text Input URL
© Latest No queries running & & Debug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
(17 table1 Q - X »
. .
Q search compnents JMobbin Admin
I'_"Y Content =
Commonly used
4 T i Data source i} getUsers @©
New Ao ID Name Email Blocked
0 m Primary key D
! 1 Hershel McV... etexton2d@...
Table Text Button
- Columns e QY
O] 2 Gayel Coton ekeitley3v@... v ! S+
@ T—1)| |[#—1| = 3 Imogene Sch.. ckiddey64@.. v # 1D
Name
Text Input Number Select 4 Anita Oliver tmordy6l@m... T
Input
& Email
5 Costa Spata kesposilc@... v
£ 8 Blocked
- 6 Catharina M... uqueree69@...
Container Form Tabbed Actions +
Container 7 Booth Macq... sloache34@...
No actions
4
= |I| D 50 results Y & O Add-ons +
O O
Modal Chart Key Value Toolbar Filter, Download, ..
(&) =
Interaction =
Image Navigation Event handlers +
Text inputs Trigger queries, control components, or call
other APIs in response to component events.
T $ T s & —I Default filters 2 +
Editable Text Editable Text  Email No fliters
Area
Default operator And Or
BIu”
{3 Pl
I I Row selection Single Multiple  None
JSON Edif P d  Rich T
ttor. Passwor 'Edit:,“ Default row Index Key None
T Default index ]
- I av l; ®—I
<> - 100% Index type Display Data
Text Area Text Input URL
© Latest No queries running & fDebug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
D tablel > Email e X »
. .
Q search compnents JMobbin Admin
I'_"Y ~ Content
Commonly used
[ J Q O .
<I; Source email
New Ao ID Name Email Blocked
{} m ID email
! 1 Hershel McV... etexton2d@...
Table Text Button Label Email
) 2 Gayel Coton ekeitley3v@... v
= Format Strin
@ T—1)| |[#—1| = 3 Imogene Sch.. ckiddey64@.. v I string
Textinput  Numker  Select 4 AnitaOliver  tmordy6i@m... Mapped value | {{ item }}
npu
5 Costa Spata kesposilc@... v Add-ons +
A B
None
- 6 Catharina M...  uqueree69@... v
Container Form Tabbed
Container 7 Booth Macq... sloache34@... ~ Interaction
oMt . - Event handlers +
|I| D 50 results Y & O
[ ] 1 S Trigger queries, control components, or call
Modal Chart Key Value other APIs in response to component events.
Editable
(&) =
Image Navigation ~ Appearance
Background
Text inputs grou
Text
T $£ T & S —I
Hidden false
Editable Text Editable Text Email
Area Align le sle >
BIu”
{3 I Dol 1 Pin column | - 5|
JSON Editor  Password Rich Text
Editor
| IE=D R=T
<> — 100%
Text Area Text Input URL
© Latest No queries running & fDebug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
D tablel > Email e X »
. .
Q search compnents JMobbin Admin
I'_"Y Content
Commonly used
[ J Q O .
<I; Source email
New Ao ID Name Email Blocked
{} m ID email
! 1 Hershel McV... etexton2d@...
Table Text Button Label Email
) 2 Gayel Coton ekeitley3v@... v
= Format & Link
& T—I) |[#—TI — 3 Imogene Sch... ckiddey64@... v
Textinput  Numker  Select 4 AnitaOliver  tmordy6l@m... Mapped value | {{ item }}
npu
5 Costa Spata kesposilc@.. v Add-ons +
A B
None
- 6 Catharina M... uqueree69@...
Container Form Tabbed
Container 7 Booth Macq...  sloache34@... Interaction
PR TUPS ettt . Event handlers +
|I| D 50 results Y & O
[ ] 1 S Trigger queries, control components, or call
Modal Chart Key Value other APIs in response to component events.
@ A BC Appearance
Image Navigation Background
. Text
Text inputs
Underline On hover
T $£ T & < —1I
Hidden false
Editable Text Editable Text Email
Area Align Je e 5|
BIu”
{3 1 ool 1 Pin column |e - 5|
JSON Editor  Password Rich Text
Editor
| IE=D R=T
<> — 100%
Text Area Text Input URL
© Latest No queries running & fDebug O @


Adding a form

actions:
Adding & Creating
Selecting & Choosing

screenElements: Popover Table

screenElements:
Popover
Table
Loading Indicator

screenPatterns: Select Loading

screenKeywords:
- . .
a B JMobbin Admin QB m
@ Components Modules 57 <«
1 Hershel McV... etexton2d@... [} form1 Qe R »
Q search components
I-_V'Y 2 Gayel Coton ekeitley3v@... v Content
¢/® Containers and forms 3 Imogene Sch.. ckiddey64@.. v Data source
G A 4 Anita Oliver tmordy6l@m... v Add-ons +
i} =
\9 Collapsible  Container Fo 5 Costa Spata kesposilc@... v Header Enabled
Contai
ontainer Form Generator B X Footer Enabled
@ JSON &
= Source | (1) table1 ~ )
Interaction
JSON Link Card  List
Schema Colum Tables Label Input type Required y Y O Reset after successful submit
Form
. . : table1 v .
. o 2 id ID 4 Number Input v Disable false
B name Resources Name T Text Input
: Validate inputs on submit
.. @ [demo resource] Microsoft SQL B .
Stepped  Tabbed wii i email Email &7 Email
Container  Container R [demo resource] MySQL Disable submit false
:: (@ blocke Blocked Checkbox
Wl [demo resource] PostgreSQL .
Navigation . Loading false
© Creati W} onboarding_db sonfigure a submit query.
Hoist loading state
! retool_db
B/B/e ABC 2| orwy L - ints Generate Torm
3% [demo resource] Snowflake Event handlers +
Breadcrumbs Navigation  Page Input .
© [demo resource] BigQuery Trigger queries, control components, or call
. other APIs in response to component events.
12-@ -0 B ¢ ‘ [demo resource] Firebase m
102 - .
Pagination Steps Tabs Appearance =
. Show body
Integrations
Height Auto Fixed
] b @
Show border
Auth Login Looker Mapbox Map
Hidden false
s i
[} Padding type Normal None
S3 Uploader  Stripe Card Tableau
Styles
<> Form — 100% Y! Qo +
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
Components Modules 57 <«
@ Inspector (8U) <«
ID Name Email Blocked
I__Y Q search components
v 1 Hershel McV... etexton2d@... v
® Containers and forms
<1z 2 Gayel Coton ekeitley3v@... v
A
{i} = 3 Imogene Sch... ckiddey64@...
Collapsible  Container Form 4 Anita Oliver tmordy6l@m... v
\9 Container
5 Costa Spata kesposilc@... v
@ JSON &
- 6 CatharinaM... uqueree69@...
JSON Link Card List View
Schema 7 Booth Macg... sloache34@...
Form
-0 B 6 -0 50 results Yy L O
Stepped Tabbed Wizard
Container Container Unblock user =
Navigation
A/B/C A BC 2 | of 99
Breadcrumbs Navigation  Page Input
-0
12 (D TS A BC
Pagination Steps Tabs
Integrations
] b @
Auth Login Looker Mapbox Map
s "
&
]
S3 Uploader  Stripe Card Tableau
<> Form — 100%
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
1 Hershel McV... etexton2d@... [} form1 Qe R »
Q search components
I-_V'Y 2 Gayel Coton ekeitley3v@... v Content
Containers and forms
04 Form Generator B X Data source
A
0 Add-ons +
! Source @ [demo resource] Micro...  ~ Table retool_cloud_demo.customer... ~ Reset all
\9 Collapgible Container Fc Header Enabled
Container Column name Column type Label Input type Required Footer Enabled
0 NSon - 2@ id 1 bigint D T Text Input
= i customer_name 99 text Customer name 'é Text Area Interaction
JSON LinkCard ~ List
Schema i (@ revenue 1 bigint Revenue T Text Input Yy L O Reset after successful submit
Form
i licenses 4 bigint Licenses T Text Input i
- Disable false
-0 B 6 -
i active_licenses 1t bigint Active licenses T Text Input
Validate inputs on submit
Stepped Tabbed wi i platform 99 text Platform T. Text Area
Container  Container Disable submit  false
i next_renewal date Next renewal Date
Navigation it @ industry 99 text Industry T Text Area Loading false
i active_license_growth 1t float Active license growth 4 Number Input Hoist loading state
A/B/C ABC 2
: license_growth 1t float License growth 4 Number Input Event handlers +
Breadcrumbs Navigation  Page
Tri ri trol t: I
© Creating: 8 components, 1 query. Generate form ‘ager qug es, contro’ components, or ca
other APIs in response to component events.
12.@ 9 A
iz S
Pagination Steps Tabs Appearance =
. Show body
Integrations
Height Auto Fixed
] b @
Show border
Auth Login Looker Mapbox Map
Hidden false
$ i
[} Padding type Normal None
S3 Uploader  Stripe Card Tableau
<> Form ~ 1004 Styles 2 +
© Latest No queries running & wDebug O @
|- . .
a B JMobbin Admin QB m
@ Components Modules 57 <«
1 Hershel McV... etexton2d@... [} form1 Qe R »
Q search components
I-_V'Y 2 Gayel Coton ekeitley3v@... v Content
Containers and forms
b4 Form Generator B X Data source
A
0 Add-ons +
! Source @ [demo resource] Micro...  ~ Table retool_cloud_demo.customer... ~
\9 Collapgible Container Fc Header Enabled
Container Column name Column type Label Input type Required Footer Enabled
0 NSon - 2@ id 1 bigint D T Text Input
= i customer_name 99 text Customer name 'é Text Area Interaction
JSON Link Card  List
Schema i (@ revenue 1 bigint Revenue T Text Input Yy L O Reset after successful submit
Form
i licenses 4 bigint Licenses T Text Input i
- Disable false
-0 B 6 -
i active_licenses 4 bigint Active licenses T Text Input
Validate inputs on submit
Stepped Tabbed wi i platform 99 text Platform T. Text Area
Container  Container Disable submit  false
i next_renewal date Next renewal Date
Navigation it @ industry 99 text Industry T Text Area Loading false
i active_license_growth 1t float Active license growth 4 Number Input Hoist loading state
A/B/C ABC 2
i license_growth 4 float License growth 4+ Number Input Event handlers +
Breadcrumbs Navigation  Page
Tri i trol t: I
© Creating: 10 components, 1 query. Generate form rigger qugrles, control components, or ca
other APIs in response to component events.
12.@ 9 A
iz S
Pagination Steps Tabs Appearance =
. Show body
Integrations
Height Auto Fixed
] b @
Show border
Auth Login Looker Mapbox Map
Hidden false
s H
[} Padding type Normal None
S3 Uploader  Stripe Card Tableau
Styles
<> Form — 100% Y! Qo +
© Latest No queries running & wDebug O @
|- . .
a B JMobbin Admin QB m
@ Components Modules 57 <«
1 Hershel McV... etexton2d@... [} form1 Qe R »
Q search components
I-_V'Y 2 Gayel Coton ekeitley3v@... v Content
¢/® Containers and forms 3 Imogene Sch.. ckiddey64@.. v Data source
G A 4 Anita Oliver tmordy6l@m... v Add-ons +
i} =
\9 Collapsible ~ Container Fa 5 Costa Spata kesposilc@... v Header Enabled
Container Form Generator B x Footer Enabled
@ JSON &
= Source [ table1 v )
Interaction
JSON Link Card  List
Schema Column name Table column type Label Input type Required Y & O Reset after successful submit
Form
- R id 4 Number D 4+ Number Input bisable false
i name T Text Name T Text Input
Validate inputs on submit
Stepped  Tabbed wi: & (2 email T Text Email 2 Email
Container  Container Disable submit  false
i blocked Boolean Blocked Checkbox
Navigation Loading false
@ Creating: 4 components. Use an event handler to configure a submit query.
Hoist loading state
A'B/C A BC 2 orvy Add components Generate torm
Event handlers +
Breadcrumbs Navigation  Page Input
Trigger queries, control components, or call
other APIs in response to component events.
vm e e e
Pagination Steps Tabs Appearance =
. Show body
Integrations
Height Auto Fixed
] b @
Show border
Auth Login Looker Mapbox Map
Hidden false
s i
[} Padding type Normal None
S3 Uploader  Stripe Card Tableau
<> Form ~ 1004 Styles 2 +
© Latest No queries running & wDebug O @
|- . .
a B JMobbin Admin QB m
@ Components Modules 57 <«
1 Hershel McV... etexton2d@... [} form1 Qe R »
Q search components
I-_V'Y 2 Gayel Coton ekeitley3v@... v Content
¢/® Containers and forms 3 Imogene Sch.. ckiddey64@.. v Data source
G A 4 Anita Oliver tmordy6l@m... v Add-ons +
i} =
Collapsible  Container Form 5 Costa Spata kesposilc@... v Header Enabled
\9 Container
6 CatharinaM.. uqueree69@... Footer Enabled
&
@ JSON 7 Booth Macg... sloache34@...
-
Interaction
JSON Link Card  List View oM e . -
Sthema 50 results Y &L O Reset after successful submit
orm
Lo A B ) Disable false
Unblock user v
Validate inputs on submit
Stepped Tabbed Wizard
Container  Container Disable submit  false
Form title
Navigation Loading false
Hoist loading state
AB/C ABC 2 of 99 l Add components Generate form l
Event handlers +
Breadcrumbs Navigation  Page Input
Trigger queries, control components, or call
other APIs in response to component events.
vm e e e
Pagination Steps Tabs Appearance =
. Show body
Integrations
Height Auto Fixed
] b @
Show border
Auth Login Looker Mapbox Map
Hidden false
s i
[} Padding type Normal None
S3 Uploader  Stripe Card Tableau
<> Form ~ 1004 Styles 2 +
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
1 Hershel McV... etexton2d@... [} form1 Qe R »
Q search components
I-_V'Y 2 Gayel Coton ekeitley3v@... v Content
¢/® Containers and forms 3 Imogene Sch.. ckiddey64@.. v Data source
G A 4 Anita Oliver tmordy6l@m... v Add-ons +
i} =
Collapsible  Container Form 5 Costa Spata kesposilc@... v Header Enabled
\9 Container
6 CatharinaM.. uqueree69@... Footer Enabled
&
@ JSON 7 Booth Macg... sloache34@...
-
Interaction
JSON Link Card List View 9
Schema Y &L O Reset after successful submit
Form ~7
-0 =8 -0 Generating form... Disable false
- This may take a few seconds depending on the Validate inputs on submit
_ number of columns. Please do not reload the app.
Stepped Tabbed Wizard
Container  Container Disable submit false
Form title
Navigation Loading false
ID* Enter value Hoist loading state
A/B/C A BC 2 | of 99
Customer name * Enter value Event handlers +
Breadcrumbs Navigation  Page Input
Trigger queries, control components, or call
other APIs in response to component events.
12D 1"? ABC Revenue * Enter value
Pagination Steps Tabs Licenses * Enter value Appearance =
. Show body
Integrations Platform * Enter value
Height Auto Fixed
Login
© Ob Next renewal * Nov 8, 2023 Show border
Auth Login Looker Mapbox Map
Hidden false
[} Padding type Normal None
S3 Uploader  Stripe Card Tableau
<> Form — 100% Styles 2 +
© Latest No queries running & wDebug O @
|= O JMobbin Admin QB m
@ Components Modules 57 « = ers <> chat1_query1 @ form1SubmitToRetoolCloudDemoCi + (=)
1 Hershel McV... etexton2d@.. L form1 Qe R »
I-_Y Q search components General Response Advanced ees  Preview
\g 2 Gayel Coton ekeitley3v@... Content
Containers and forms :
<> Resource @ Playground Resources / [demo resource] Microsoft SQL 3 Imogene Sch... ckiddey64@... Data source
) A 4 Anita Oliver tmordy6l@m...  Add-ons +
{'} - GUI mode Run query only when manually triggered
Collapsible  Container Form 5 Costa Spata kesposi1c@... Header Enabled
\9 Container
Table 6 CatharinaM.. uqueree69@... Footer Enabled
@ JSON &
retool_cloud_demo.customers 7 Booth Macg... sloache34@...
-
Interaction
JSON Link Card  List View Action type oM e .
Schema 5C  Reset after successful submit
Form Insert a record
Lo A B ) Disable false
Changeset Unblock user v
- Validate inputs on submit
Stepped Tabbed Wizard ObjeCt
Container  Container Disable submit | false
1 H{ forml.data }¥ Form title
Navigation Loading false
Transf | ID* Enter value Hoist loading state
NG B c 2 ransform results Enable
Fnahla tranefarmare tn tranefarm tha racuilt af tha auarv ta a diffarant farmat Customer name * Enter value Event handlers +
Breadcrumbs Navigation  Page Input
Schema Output M B .
Submit form1SubmitToRetoolCL..
12.@ *O ABC o Revenue * Enter value
T2 Q_ Search tables or columns S
- Appearance =
Pagination Steps Tabs Licenses * Enter value PP -
All tables
Show body
Integrations ~ retool_cloud_demo.customers Platform * Enter value
active_license_growth float Height Auto Fixed
Login % @ active_licenses bigint
Next renewal * 5] Nov 8, 2023 Show border
customer_name text
Auth Login Looker Mapbox Map Hidd fal.
i igi idden alse
id bigint Industry * Enter value
s " .
o industry text Padding type Normal None
license_growth float
S3 Uploader Stripe Card Tableau licenses bigint License growth * 0 Styles 2 +
Form 9 — 100%
<> next_renewal date
© Latest No queries running & wDebug O @


Code detail

screenKeywords:
-_ [D Jane Smith - Al Onboarding - Nov 8, 2023 6:00 PM Latest version deployed ~ (®) Run Deploy v
[©) g 2s
£
&
@ This workflow fetches the current weather and '+ Retool Al Actions *
uses Al to suggest an activity.
O Press the P> play button to fetch the weather in San Francisco. Use Retool Al to sugg
&3 Scroll to your right to see the set up Reference the results of the previous block by Reference the previot
P Press play button in each block sequentially This fetches the data from the Open-Meteo API. using fetchWeather directly in code. 5
4% startTrigger & - @ - {} fetchWeather = - @ » -0 getWeather = - @ > <> generateActivitie
Enabled triggers RESTQuery (restapi) JavaScript Retool Al
No triggers enabled GET https://api.open- 1 const weatherData = fetchWeather.data Action
2
meteo.com/vl/forecast?
Edit triggers latitude=37.6168longitude=-122.3833&cu 3 return weatherData.current_weather Cenerate text
rrent_weather=true&temperature_unit=fa Examples: Product desci
Test JSON Parameters hrenheit
. ., . Inputs Settings o Input
{("webhookParaml": "value"} + More options 1 What's a good
Explain your r
Inputs Data JSON Settings [v] 2
—— 3 Weather:
o X 4 {{getWeather.c
Use Retool Vector:
Timeout after (ms) 12000
Model
& gpt-4
Retry count Interval
Inputs
Exponential
Finally Exit
®
§ - 100% + O3 % ¢ X B3 i}
® production O Run history
|-_ b Jane Smith - Al Onboarding - Nov 8, 2023 6:00 PM Latest version deployed ~ (®) Run Deploy v
® 8 s
7 This workflow fetches the current weather and '+ Retool Al Actions *
uses Al to suggest an activity.
O Press the P> play button to fetch the weather in San Francisco. Use Retool Al to sugg
&3 Scroll to your right to see the set up Reference the results of the previous block by Reference the previot
P Press play button in each block sequentially This fetches the data from the Open-Meteo API. using fetchWeather directly in code. 5
4% startTrigger & - @ - {} fetchWeather = - @ » -0 getWeather = - @ > <> generateActivitie
Enabled triggers RESTQuery (restapi) JavaScript Retool Al
No triggers enabled GET https://api.open- ; const weatherData = fetchWeather.data Action
meteo.com/vl/forecast?
Edit triggers latitude=37.6168longitude=-122.3833&cu 3 return weatherData.current_weather Cenerate text
rrent_weather=true&temperature_unit=fa Examples: Product desci
Test JSON Parameters hrenheit
L i ) . Inputs Settings o Input
("webhookParaml": "value"} + More options [ #hat s al5000
Explain your r
Inputs Data JSON Settings [v] 2
3 Weather:
¢ X = X 4 {{getWeather.c
startTrigger.data Use Retool Vector:
Model
& gpt-4
Inputs
®
:@ - 100% + O3 % ¢ X B3 i}
® production O Run history
|-—_ 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
|-_ b Jane Smith - Al Onboarding - Nov 8, 2023 6:00 PM Latest version deployed ~ (®) Run Deploy v
® °g 8=
£
&
@ This workflow fetches the current weather and '+ Retool Al Actions '
uses Al to suggest an activity.
O Press the P> play button to fetch the weather in San Francisco. Use Retool Al to sugg
&3 Scroll to your right to see the set up Reference the results of the previous block by Reference the previot
P Press play button in each block sequentially This fetches the data from the Open-Meteo API. using fetchWeather directly in code. 5
¢ startTrigger = - @ - {} fetchWeather = - @ » - getWeather = - o » - ¢ generateActivities
Enabled triggers RESTQuery (restapi) JavaScript Retool Al
No triggers enabled GET https://api.open- 1 const weatherData = fetchWeather.data Action
2
meteo.com/vl/forecast?
Edit triggers latitude=37.6168longitude=-122.3833&cu 3 return weatherData.current_weather Cenerate text
rrent_weather=true&temperature_unit=fa Examples: Product desci
Test JSON Parameters hrenheit
o . . Inputs Settings o Input
{"webhookPare value"} + Moreopt|ons 1 What's a good
Explain your r
Inputs Data JSON Settings (/] 2
S 3 Weather:
object = @ x 4 {{getWeather.c
latitude 37.626106 Use Retool Vector:
longitude -122.40018 Model
generationtime_ms 0.06306171417236328
& gpt-4
utc_offset_seconds 0
timezone GMT Inputs
timezone_abbreviation GMT
elevation 10
current_weather_units {"time":"iso08601","interval":"se
conds", "temperature":"°F", "winds
a peed":"km/h","winddirection":"°"
< ,"is_day":"", "weathercode":"wmo
code"
@ - 100% + 3% s X @ ' w
- current_weather {"time":"2023-11-
® production O Run history
|-_ b Jane Smith - Al Onboarding - Nov 8, 2023 6:00 PM Latest version deployed ~ (®) Run Deploy v
® 8 s
@ This workflow fetches the current weather and '+ Retool Al Actions '
uses Al to suggest an activity.
O Press the P> play button to fetch the weather in San Francisco. Use Retool Al to sugg
&3 Scroll to your right to see the set up Reference the results of the previous block by Reference the previot
P Press play button in each block sequentially This fetches the data from the Open-Meteo API. using fetchWeather directly in code. 5
¢ startTrigger = - @ - {} fetchWeather = - @ » - getWeather = - o » - ¢ generateActivities
Enabled triggers RESTQuery (restapi) JavaScript Retool Al
No triggers enabled GET https://api.open- ; const weatherData = fetchWeather.data Action
meteo.com/vl/forecast?
Edit triggers latitude=37.6168longitude=-122.3833&cu 3 return weatherData.current_weather Cenerate text
rrent_weather=true&temperature_unit=fa Examples: Product desci
Test JSON Parameters hrenheit
. Inputs Settings o Input
{"webhookParaml": value"} + More opt|ons 1 What's a good
Explain your r
Inputs Settings o 2
3 Weather:
4 {{getWeather.c
Use Retool Vector:
Model
& gpt-4
Inputs
®
:@—100%*[] % ¢ X B3 jiul
® production O Run history
|-_ b Jane Smith - Al Onboarding - Nov 8, 2023 6:00 PM Latest version deployed ~ (®) Run Deploy v
® g
r
)
&
@ i .
v This workflow fetches the current weather and '+ Retool Al Actions '
uses Al to suggest an activity.
—
0] Press the P> play button to fetch the weather in San Francisco. Use Retool Al to sugg
&3 Scroll to your right to see the set up Reference the results of the previous block by Reference the previot
P Press play button in each block sequentially This fetches the data from the Open-Meteo API. using fetchWeather directly in code. 5
4% startTrigger & - @ - [} fetchWeather = - @ » -0 getWeather = - @ > <> generateActivitie
Enabled triggers RESTQuery (restapi) JavaScript Retool Al
No trigge 1ablec GET https://api.open- ; const weatherData = fetchWeather.data Action
meteo.com/vl/forecast?
Edit triggers latitude=37.6168longitude=-122.3833&cu 3 return weatherData.current_weather Cenerate text
rrent_weather=true&temperature_unit=fa Examples: Product desci
Test JSON Parameters hrenheit
L . . Inputs Settings [ Input
{"webhookf value"} + More options iWhat s algood
Explain your r
Inputs Data JSON Settings [v] 2
— 3 Weather:
¢ X = @ x 4 {{getWeather.c
v data {} 9 keys Use Retool Vector:
latitude ©@ 37.626106 Model
longitude @ -122.40018
I & gpt-4
generationtime_ms @ 0.06306171417236328
utc_offset_seconds @ 0 Inputs
timezone © GMT
timezone_abbreviation © GNMT
elevation & 10
» current_weather_units © {} 7 keys
. v current_weather © {} 7 keys
- time © 2023-11-08T10:00
interval © 900
g - 100% + I %% ¢ x @ - w
- temperature © 50.5
® production O Run history


Resizing text block

screenKeywords:
= B JMobbin Admin Q 8 m
@ Components Modules 57 <«
T text1 Q s X »
Q . @
I'_: Content
Commonly used
<® Value Markdown  Plain text
New
(i} [__J = m ## {{ retoolContext.appName }}
I
Table Text Button Add-ons +
."k
O — None
@ e # —1 —
Text Input Number Select Appearance =
Input
Image width Fit Fill
A B
- Height Auto Fixed
Container Form Tabbed N
Container Alignment |e e 5|
[:] Hidden false
& il
Styles 2 +
Modal Chart Key Value
None
(&)
Image Navigation
Text inputs
T £ T s S —I
Editable Text Editable Text Email
Area
BIu”
{3 i Pl 1
JSON Editor  Password Rich Text
Editor
T.
- I 70 =it ®—I
<> — 100%
Text Area Text Input URL
© Latest No queries running & fEDebug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
T text1 Q e X »
o o
Q_ search companents |JMobbin Admin
I'_"Y = Content
Commonly used
e Value Markdown Plain text
New
{} MY m ## {{ retoolContext.appName }}
|
Table Text Button Add-ons +
O
= None
@ T—1 # —1 .
-
Text Input Number Select Appearance o=
Input
Image width Fit Fill
A B
- Height Auto Fixed
Container Form Tabbed N
Container Alignment le sle Bl
Hidden false
[ EE
— Styles 2 +
Modal Chart Key Value
None
Image Navigation
Text inputs
T $ T ke S —I
Editable Text Editable Text Email
Area
B/u”
{3 ; Pl I
JSON Editor  Password Rich Text
Editor
T.
- I T—1 I
<> — 100%
Text Area Text Input URL
© Latest No queries running & fDebug O @
|= B JMobbin Admin Q 8 m
@ Components Modules 57 <«
T text1 Q s X »
. .
Q. Search components JMobbln Admln |
I-_VY = Content
Commonly used
<? Value (73] Markdown  Plain text
New
{} e @ ## {{ retoolContext.appName }}
1
Table Text Button Add-ons +
O
= None
@ 10— b I .
Text Input Number Select Appearance =
Input
Image width Fit Fill
A B
- Height Auto Fixed
Container Form Tabbed N
Container Alignment le sl B
Hidden false
S ES
— Styles 2 +
Modal Chart Key Value
None
(&) =
Image Navigation
Text inputs
T £ T s S —I
Editable Text Editable Text Email
Area
BIu”
{3 ; Pl 1
JSON Editor  Password Rich Text
Editor
T.
e T—1 ®—1I
<> — 100%
Text Area Text Input URL
© Latest No queries running & fEDebug O @


Uploading a file

screenKeywords:
== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
T&C Add document v
Upload file
Add plain text
No document found
|Upload file X
Drop files here or click to upload
Invoice_1_2023-09-13.pdf (21.4 kB) X
|Upload file X
Drop files here or click to upload
|Upload file X
Drop files here or click to upload
Invoice_1_2023-09-13.pdf (21.4 kB) X
|== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
T&C Add document v
No document found
|== Retool Apps Resources Database  QueryLibrary  Workflows Upgrade [KORENEREN
T&C Add document v
Document name
Invoice_1_2023-09-13.pdf ©


Inserting a text component

screenElements:
Text Field
Segmented Control

screenElements:
Text Field
Segmented Control
Tooltip

pageType: Application Application Application Application

screenKeywords:
= O JMobbin Admin QB m
@ Components Modules 57 <«
T text1 Q e X »
v 1
I__Y Q search components ' lciiodane! '
A Content
Commonly used
4 Value Markdown  Plain text
New
s m 1 *%Hello {{ current_user.firstName ||
{'} 'friend' }}!¥%
Table Text Button
@ Add-ons +
@ 9y =i # —1 5 None
Text Input Number Select
Input Appearance =
A B Image width Fit Fill
-
Height Auto Fixed
Container Form Tabbed
Container
Alignment | se 5|
Il D Hidden false
[ ] 1
Modal Chart Key Value Styles 2 +
None
(&)
Image Navigation
Text inputs
T $ T ke S —I
Editable Text Editable Text Email
Area
B/u”
{3 ; Pl I
JSON Editor  Password Rich Text
Editor
T.
- I T—1 I
<> — 100%
Text Area Text Input URL
© Latest No queries running & fDebug O @
|= B JMobbin Admin Q 8 m
@ Components Modules 57 <«
—_— Y ——— Inspector (32U) <«
Q, Search components
e
Commonly used
«®
[__N.Jw
{i}
Table Text Button
O
@ e # I -
Text Input Number Select
Input
A B
-
Container Form Tabbed
Container
& 1=
Modal Chart Key Value
(&) =
Image Navigation
Text inputs
T £ T s S —I
Editable Text Editable Text Email
Area
BIu~
0| (po1 ;
JSON Editor  Password Rich Text
Editor
T
- I 70 =it ®—I
<> — 100%
Text Area Text Input URL
© Latest No queries running & fEDebug O @
|H . . r
&= 1=} JMobbin Admin current_user ® &
@ Components Modules 5? « email "jsmith.mobbin2@gmail.com"
T text1 externalldentifier null
Q_ Search components QHeIIo mans! ' firstName "Jane"
I__V-Y - Content fullName "Jane Smith"
Commonly used groups [] 2 items
<® Value (i3] id 811859
New nemith"
lastName "Smith
e m 1 *xHello {{ current_user.firstName ||
{'} 'friend' }}!¥% 3]
Table Text Button
@ Add-ons +
@ 9y =i # —1 5 None
Text Input Number Select
Input - Appearance =
A B Image width Fit Fill
-
Height Auto Fixed
Container Form Tabbed
Container
Alignment | se 5|
I|| D Hidden false
[ ]
Modal Chart Key Value Styles 2 +
None
(&) e
Image Navigation
Text inputs
T ¢ T ke S —I
Editable Text Editable Text Email
Area
BIu”
{3 ; Pl I
JSON Editor  Password Rich Text
Editor
T.
- I T—1 I
<> — 100%
Text Area Text Input URL
© Latest No queries running & fDebug O @
|= O JMobbin Admin QB m
@ Components Modules 57 <«
Inspector (82U) <«
Q search components
€
Commonly used
«®
LN“JV
CE
{
Table Text Button
O
@ T—1 # I =
Text Input Number Select
Input
A B
-
Container Form Tabbed
Container
& ==
Modal Chart Key Value
(&) »--
Image Navigation
Text inputs
T $ T ke S —I
Editable Text Editable Text Email
Area
B/u”
0 51 ;
I
JSON Editor  Password Rich Text
Editor
T
- I T—1 I
<> — 100%
Text Area Text Input URL
© Latest No queries running & fDebug O @


Adding a row

screenPatterns:
Add & Create
Date & Time

screenElements:
Time Picker
Toast
Date Picker

screenPatterns:
Add & Create
Date & Time
Acknowledgement & Success
Calendar

screenKeywords:
Add row X
A account_numher * Null OO
12:00:00 AM
account_jsmc
12:15:00 AM
12:30:00 AM
A company * Null OO
12:45:00 AM
JMobbin
1:00:00 AM
@ transactio TS0 A Null OO
2023-11-02 [12:00:00 AM
A payment_type Null
A plan Null
# id * Default
|Add row X
A account_number Null
A company Null
(@ transaction_date Null
YYYY-MM-DD H:MM:SS A
A payment_type Null
A plan Null
# id * Default
|Add row X

A account_number * Null OO
account_jsmobbin1

A company * Null OO
JMobbin

(@ transaction_date Null
YYYY-MM-DD H:MM:SS A

A payment_type Null

A plan Null

# id * Default
|Add row X

A account_number * Null OO
account_jsmobbin1

A company * Null OO
JMobbin

@ transaction_date * Null OO
2023-11-02 1:00:00 AM

A payment_type Null

A plan Null

# id * Default
|Add row X

A company * Null OO
JMobbin

@ transaction_date * Null OO
2023-11-02 1:00:00 AM

A payment_type Null

A plan Null

# id * Default
transactions_id_seq
|- Retool Database Feedback? G
transactions
Add row Import CSV v Fields Filters Sort Quick find Refresh 50 records
O id PRIMARY KEY account_num.. company transaction_date payment_.. plan

38 account_say Procter & Gambple Jan 15, 2023 Credit Enterprise
39 account_781 Nike Jan 03, 2023 Invoice Pro
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
51 account_jsmobbin1 JMobbin Nov 01, 2023 NULL NULL
|Add row X
A account_number * Null OO
account_jsmobbin1
A company * Null OO
JMobbin
(@ transaction_date Null
IOOOEVIVEBBN H:\M:SS A
< November 2023 > Null
Su Mo Tu We Th Fr Sa
1 2 3 4
5 6 7 8 9 10 " Null
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 Default
|-—_ 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