UI Bakery Docs
UI Bakery Docs
What is UI Bakery?
Create an app
Explore the interface
Read and write data
Manage users and permissions
Data mapping & transforming
Field types & types recognition
Connecting local database via ngrok
UI Bakery On-Premise
Work with data
Work with components
Use action.trigger ()
Implement advanced validation
Use external JS libraries
Generate PDF document
Display files from Google Drive and Dropbox
Select multiple Table rows
Connecting Google Sheets and UI Bakery
- Connect -
. Specify the name of the data source and insert the link to your sheet. Select
type: Read-Write or Read Only.
Adding Google Sheets as a data source
Authorize the access by pressing
Connect to Google Sheets
. You’ll be prompted to the Google Authorization page, where you need to allow UI Bakery access to your Google Sheet.
Please do not miss this step as the connection would not be established without it.
Once you’ve authorized the access, click
Make sure that your data in Google Sheet is structured, and each column has a name. This will allow UI Bakery to recognize
types of columns and data
and present them in a correct way
Please note that your file cannot be in xlsx format, as it will not be processed
When the connection with Google Sheets is established, you can start managing your data
using one of the following types to access your data:
Adding a Load Table action step
Run the Action
. Take a look at the
tab to make sure the data is loaded. After that, you might want as well to:
Transform or map your data.
Add a Component to display it.