# Scripting functions Scripting functions can be used for operations on the visual, such as showing or hiding columns, filtering data for a particular period, or setting a layout.

NAME	DESCRIPTION
DISPLAYTOAST	Displays custom text as a toast message
EXPORT	Creates PDF, Excel exports, or copies to clipboard
LAYOUT	Layout functions can be used to set the layout, set a theme, enable/disable rails, or expand the hierarchy to a particular level.
OPENFILTER	Create Inforiver filters without requiring access to the toolbar
OPENKPIEXPLORER	Open the KPI Explorer without requiring access to the toolbar
OPENMANAGECOLUMN	Manage fields in reports, without requiring access to the toolbar
OPENSEARCH	Open the Search interface without requiring access to the toolbar
OPENTOPN	Open the TopN interface without requiring access to the toolbar
SETCFRULE	Enable or disable conditional formatting rules
SETFILTER	Apply or remove filters on the data
SETFILTERBYINDEX	Apply or remove filters based on the index of the filter
SETVISIBILITY	Show or hide rows, columns, and measures.
SHOWBETWEENPERIOD	Displays the data between the specified time frames
SHOWCLOSEDFORECAST	Display forecasts for previous periods
TOPN	Rank your data based on a category for a particular measure

--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.inforiver.com/formula-syntax/scripting-functions.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.