Dashboard
Lido provides formulas for interacting with dashboards — navigating between dashboards, reading and setting dashboard component values, opening URLs, and accessing URL parameters.
NAVIGATEDASHBOARD
Navigates to a named dashboard within Lido. This is an action formula.
Syntax:
=NAVIGATEDASHBOARD(dashboard_name)
Parameters:
| Parameter | Description | Required |
|---|---|---|
dashboard_name | The name of the dashboard to navigate to | Yes |
Use cases:
- Link action buttons in your spreadsheet to dashboards
- Create navigation shortcuts for frequently accessed views
SETVALUE
Sets the value of a dashboard input component (e.g., a text input, dropdown, or checkbox). This is an action formula.
Syntax:
=SETVALUE(component_name, value)
Parameters:
| Parameter | Description | Required |
|---|---|---|
component_name | Name of the dashboard component | Yes |
value | Value to set | Yes |
Dashboard components are stored internally in hidden sheets prefixed with DBC~. SETVALUE writes to the component's value property.
INPUTVALUE
Reads the current value of a dashboard input component. This is a non-action formula — it returns the value immediately.
Syntax:
=INPUTVALUE(component_name)
Parameters:
| Parameter | Description | Required |
|---|---|---|
component_name | Name of the dashboard component to read | Yes |
Example:
=INPUTVALUE("SearchBox")
Returns the current text entered in the "SearchBox" dashboard component.
OPENURL
Opens a URL in the browser. This is an action formula.
Syntax:
=OPENURL(url)
=OPENURL(url, new_window)
Parameters:
| Parameter | Description | Required |
|---|---|---|
url | The URL to open | Yes |
new_window | If FALSE, navigates in the current tab (default: TRUE, opens new tab) | No |
DOWNLOADFILE
Downloads a file to the user's computer. This is an action formula that only works in the browser.
Syntax:
=DOWNLOADFILE(url)
=DOWNLOADFILE(url, file_name)
Parameters:
| Parameter | Description | Required |
|---|---|---|
url | URL of the file to download | Yes |
file_name | Name for the downloaded file | No |
URLPARAMETER
Reads a URL query parameter from the current page URL. This is a non-action formula.
Syntax:
=URLPARAMETER(parameter_name)
Parameters:
| Parameter | Description | Required |
|---|---|---|
parameter_name | Name of the URL parameter to read | Yes |
Example:
If the current URL is https://app.lido.app/spreadsheet/abc?region=West:
=URLPARAMETER("region")
→ "West"
The special parameter name "lidoFileId" returns the current spreadsheet's ID.
Use cases:
- Build dashboards that respond to URL parameters
- Create shareable links that pre-filter data
- Read the current spreadsheet ID for use in formulas