# 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.

Layout functions:

| NAME                                                                                                                 | DESCRIPTION                                                                                                                       |
| -------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------- |
| [DISPLAYTOAST](https://docs.inforiver.com/premium-table/formula-syntax/scripting-functions/displaytoast)             | Displays custom text as a toast message                                                                                           |
| [EXPORT](https://docs.inforiver.com/premium-table/formula-syntax/scripting-functions/export)                         | Creates PDF, Excel exports, or copies to clipboard                                                                                |
| [LAYOUT](https://docs.inforiver.com/premium-table/formula-syntax/scripting-functions/layout)                         | Layout functions can be used to set the layout, set a theme, enable/disable rails, or expand the hierarchy to a particular level. |
| [SETCFRULE](https://docs.inforiver.com/premium-table/formula-syntax/scripting-functions/setcfrule)                   | Enable or disable conditional formatting rules                                                                                    |
| [SETFILTER](https://docs.inforiver.com/premium-table/formula-syntax/scripting-functions/setfilter)                   | Apply or remove filters on the data                                                                                               |
| [SETFILTERBYINDEX](https://docs.inforiver.com/premium-table/formula-syntax/scripting-functions/setfilterbyindex)     | Apply or remove filters based on the index of the filter                                                                          |
| [SETVISIBILITY](https://docs.inforiver.com/premium-table/formula-syntax/scripting-functions/setvisibility)           | Show or hide rows, columns, and measures.                                                                                         |
| [SHOWBETWEENPERIOD](https://docs.inforiver.com/premium-table/formula-syntax/scripting-functions/showbetweenperiod)   | Displays the data between the specified time frames                                                                               |
| [SHOWCLOSEDFORECAST](https://docs.inforiver.com/premium-table/formula-syntax/scripting-functions/showclosedforecast) | Display forecasts for previous periods                                                                                            |
| [TOPN](https://docs.inforiver.com/premium-table/formula-syntax/scripting-functions/topn)                             | Rank your data based on a category for a particular measure                                                                       |