UI Bakery Docs
RoadmapRelease notesSign In
  • 👋Welcome to UI Bakery!
  • 🌟Overview
    • 💡Video intro
    • ✨Main features
    • 🔖Glossary
  • 🛠️Getting started
    • Create an application
    • Build UI
      • Data mocking methods
    • Link components
    • Connect a data source
    • Load data
    • Bind data to UI
    • Transform data with JavaScript
      • Data mapping & transforming
    • Change component data
    • Send a form
    • Create a filter
    • Note on debugging
    • Deploy your application & invite users
  • 📌Concepts
    • Components
      • Component basics
      • Component methods
      • Components best practices
        • Input validation
        • Linking a Table to a Form/Detail
        • Using a single Form to add and update data
        • Searching Table based on input value
        • Configuring server-side pagination
        • Managing Date object time zones
        • Role-based Menu component items
        • Field types & types recognition
        • Expanding component to fit screen/container
        • Controlling component's visibility
    • Custom components
      • Unrestricted custom components
    • Data sources
      • Data source environments
      • Connecting local database via ngrok
      • SSH Tunneling
    • Actions
      • Actions basics
        • Calling actions from code
      • Actions management & shortcuts
      • Actions settings
      • Actions library
      • Server actions
      • Logs and debugging
    • UI Bakery variables
    • State variables
    • Local storage
    • Modules
    • Custom JavaScript
      • JavaScript files
    • Workspace management
      • Account & workspace
      • Seats & Shared permission groups in UI Bakery
      • Roles in UI Bakery
      • Role permissions
      • Explore the interface
      • App environments
        • Release management
      • Audit logs
      • Multi-factor authentication
    • Export & import an app
    • Mobile layout
    • Theme editor
      • Changing theme from the app
    • UI Bakery source control
      • Git controls overview
      • Migrating your app model to the latest version
  • ⚡How-tos
    • File management
      • Working with PDF files
      • CSV import & export
      • Uploading files using methods
      • Displaying files from Google Drive and Dropbox
      • Parsing and sending XML
    • Styling
      • Modifying components with CSS
    • Layout & navigation
      • Adding navigation to application
      • Reading query params from URL
      • Hiding UI Bakery loader in the Embedded mode
    • Data
      • Managing user data with the {{user.email}} variable
      • Using JS libraries
        • Internationalization (i18n) & Localization: Translating UI Bakery Apps
      • Implementing row-level security
      • Copying to clipboard
    • Custom code
      • Communicating with external sites via Iframe
      • Implementing custom app hotkeys
      • Retrying API with HTTP status code 202
  • 🔎Extras
    • UI Bakery Automations
      • Environment and release strategy
      • Git in automations
      • Using external Node libraries
    • UI Bakery Database
      • Database migration
  • 💻On-premise
    • UI Bakery on-premise
    • Install & update
      • Installing on-premise
        • Azure virtual machine
        • Azure container instance
        • AWS EC2 instance
        • Google Cloud Compute Engine VM instance
        • DigitalOcean 1-click droplet
        • Manual w/ docker compose
        • Manual w/ docker run
        • Windows installation
        • Kubernetes
          • AWS EKS with Fargate
          • Scaling and resource optimization
      • Troubleshooting installation errors
      • Updating on-premise
      • Updating license key
      • Updating environment variables
      • Recommendations
        • Architecture overview
        • UI Bakery in production
        • Resource optimization
        • Running a standalone database instance
        • Generating custom secrets
    • On-premise features
      • External analytics
      • Branding
      • Embedding
      • SCIM 2.0
      • Instance API
      • Activating features under a feature flag
    • Additional configurations
      • Health check API
      • Email configuration
      • Google Sheets connection setup
      • Salesforce connection setup
      • Azure blob storage configuration
      • Adding python backend code to existing installation
      • UI Bakery Postgres
    • Networking & security
      • Setting up a domain name
      • Configuring custom certificate authority
      • Custom base URL
      • Getting requests to the local network
      • Setting up SSL on Ubuntu
    • SSO
      • OpenID
        • Google OAuth2
        • Okta ODIC
        • Azure AD OAuth2
        • Token refresh
      • SAML
        • Okta SAML
        • Azure AD SAML
      • Role synchronization
      • Multiple SSO
      • Logout redirect
      • Troubleshooting
    • Git source control
      • Manage multi-instance deployment
      • Custom PR URL
      • Automate GitHub releases
      • Automate GitLab releases
      • Automate Bitbucket releases
    • Environment variables
  • 📚Reference
    • Data security measures
    • Improving app security
    • ✨AI Assistant
    • List of Components
      • S3 file uploader
      • Azure Blob Storage file uploader
      • Accordion
      • Alert
      • Avatar
      • Boolean
      • Breadcrumbs
      • Bubble map
      • Button
      • Card
      • Chart
      • Chat
      • Checkbox
      • Collapsible card
      • Color picker
      • Composite form
      • Container
      • Context menu button
      • Currency
      • Currency input
      • Date picker
      • Date & time
      • Date & time picker
      • Detail
      • Divider
      • Email input
      • Embedded App
      • File
      • File dropzone
      • File picker
      • Flex container
      • Form
      • Frame drawer
      • Grid view
      • Heading
      • Horizontal menu
      • Icon
      • iFrame
      • Image
      • Image picker
      • JSON editor
      • JSON viewer
      • Link
      • List view
      • Map
      • Menu
      • Metric
      • Modal
      • Multi-select
      • Number
      • Number input
      • Password input
      • PDF viewer
      • Percent
      • Pop-up form
      • Progress bar
      • QR code
      • Radio
      • Range slider
      • Rating
      • Reusable header
      • Reusable sidebar
      • Select
      • Signature
      • Slider
      • Steps
      • Stepper
      • Table
        • Conditional formatting based on cell value
        • Display name instead of ID for relation
        • Row context referencing
        • Select multiple table rows
        • How to Highlight Text in a Table Using mark.js
      • Tabs
      • Tabset
      • Tags
      • Text
      • Text annotate
      • Text input
      • Time picker
      • Toggle
      • Tree component
      • Video
      • Dynamic structure properties
      • Card (deprecated)
      • Input (deprecated)
    • Upgrading components
    • List of Data sources
      • Airtable
      • AWS S3
        • S3 compatible endpoints (DigitalOcean spaces)
      • AWS API
      • AWS Athena
      • AWS DynamoDB
      • AWS Lambda
      • AWS Redshift
      • Azure Blob Storage
      • Big Query
      • Databricks
      • Exasol
      • Firestore, Firebase Auth & Realtime DB
        • Firebase authentication
        • Managing database data
        • Firebase client-side SDK
        • Firebase libraries
      • GitHub
      • Google Sheets
      • GraphQL
      • HTTP API
        • API Authentication
      • HubSpot
      • Twilio
      • JDBC
      • MariaDB
      • MongoDB
      • MySQL
      • OpenAI
      • OpenAPI
      • Oracle
      • PostgreSQL
      • Presto
      • Redis
      • Salesforce
      • SAP Hana
      • SMTP
      • SendGrid
      • Slack
      • Snowflake
      • Spanner
      • SSH
      • Stripe
      • SQL Server
      • Supabase
      • UI Bakery AI
    • List of Action steps
      • Azure Blob Storage query
      • Bulk Create Rows
      • Bulk Delete Rows
      • Code step
      • Condition step
      • Create Row
      • Delete Row
      • DynamoDB request
      • Execute another action
      • Firebase query
      • Generate file
      • GraphQL query
      • HTTP request
      • Interval step
      • Load Table
      • Load Row
      • Loop action
      • MongoDB command
      • Navigation action
      • Open API request
      • Python backend code
      • Redis command
      • S3 query
      • Save to local storage
      • Save to state
      • Show notification
      • Slack messages
      • SMTP request
      • SSH command
      • SQL query
        • Writing SQL Queries
      • Update Row
    • Troubleshooting techniques
    • Performance optimization
Powered by GitBook

© 2025 UI Bakery

On this page
  • Creating a library action
  • To create a basic reusable SQL action:
  • To add variable parameters to the action:
  • Publishing and environments sync
  • To release the Actions Library:
  • Moving an Action to the Library
  • To move an action:
  • Private actions

Was this helpful?

Export as PDF
  1. Concepts
  2. Actions

Actions library

PreviousActions settingsNextServer actions

Last updated 1 month ago

Was this helpful?

Actions Library is a collection of actions that can be reused in your workspace apps and automations. Actions created in the library have the full power of UI Bakery actions, including the ability to load and send data, trigger other actions, and execute JavaScript code.

Actions created in the library are not directly connected to any specific app. This means that you cannot access app components or state variables, but you can use the workspace's data sources, and actions can accept parameters to customize behaviour.

Actions created in the library are only accessible using the Execute Action step and are not directly available in the app's actions code.

Creating a library action

Let's review an example of creating a library action that will load data from the database. You'll be able to use this action across multiple apps.

Our flow will consist of two parts:

  1. Creating a basic reusable SQL action

  2. Adding variable parameters to it (filtering data)

To create a basic reusable SQL action:

  1. Go to your workspace and click the Actions Library link in the bottom left corner of the screen.

  1. Create a new action of the SQL Query type and specify the following code in the query field: select * from users;

  2. Name your action loadUsers. Now the action is ready to be used in any app in the workspace.

  3. Open your app and use the action you've just created via the Execute Action step.

Once you run the action, you can see that the data is loaded in the Result tab. The action is now complete and ready to be reused in multiple apps and automations.

To add variable parameters to the action:

  1. Go back to the Actions Library and open your loadUsers action.

  2. In the Default params section on the right, add the following filter parameter that will be used in the query. Here, also define the default filter value in the query so that the action can be executed without passing any parameters and will not fail during development and debugging:

{
  filter: ''
}

Parameters is an arbitrary JavaScript object that can be passed to the action in the runtime.

  1. Next, specify the following condition in the query that will use the filter parameter you've added:

WHERE users.first_name like {{ '%' + params.filter + '%' }}
  1. While testing the action, you can change the parameter value and see how it affects the query result.

  1. Now, revert the filter to the default empty string value and go back to your app.

  2. Select the Execute Action step you've created before.

  3. In the Custom action params field, hardcode some filter value to pass it to the action, for example:

{
  filter: 'sammy'
}

If prompted, click the Reload button to synchronize the latest changes made in the Actions library.

  1. Next, run the action to observe the filter being applied.

  1. You can also use the component or state values as the arguments passed in the action.

  1. Lastly, assign your action to a component to display the data.

Publishing and environments sync

To use Actions Library in Production or Staging environments, you need to release the library. This will create a new version of the library that can be used in Prod or Staging, while you can still modify the library in the Development environment.

To release the Actions Library:

  1. Go to the Actions Library.

  2. Click the Release button in the upper right corner.

  3. In the pop-up window that opens, set a version, add a description if needed, and click Publish release.

That's it! Now, if you release your app, UI Bakery will remind you to release the Actions Library as well.

The Actions Library environment is linked to the app environment, which means that your actions will use the same data source environments as your app. For example, if your app is connected to the production database, your library actions will also use the production database in the Production environment.

Moving an Action to the Library

In some cases, you might want to move an action from the app to the Actions Library to make it more abstract and reusable.

To move an action:

  1. Click on the three dots next to the action you want to extract and click Copy.

  2. Next, go to the Actions Library, click the plus sign in the Actions section and select Paste. The action will be copied to the library.

  3. Modify it, if necessary, and remove all references to UI components or state variables.

  4. Go back to the app and replace this action with the Execute Action step and add the action you moved to the library.

Private actions

During development, you may want to create an action that is not ready to be used in your apps. Or you may want to create an action that is not intended to be used in other apps but can be used in other actions in the library. In such cases, you can turn off the Shared toggle in the Action settings. This will make the action private and it will not be available in the app's Actions list.

📌