Functions

Functions are invisible background components that process and move data in your Squirrel365 app. Learn what they are, how to add them, and which functions are available.

Functions are components that work behind the scenes in your app. Unlike charts or input controls, they have no visual presence on your canvas. Instead they process, transform, and move data through your spreadsheet, for example sorting a list, combining text values, or exporting data to Excel. You add and configure them in the same way as any other component.

Adding a function

To access the Functions panel, select the function icon in the Sidebar.

To add a new function click the add icon to open the Function Library where you can browse that available functions and select the one you need.

Functions added to your project will appear as a list in the functions panel.

---

Looking for something in particular?

AI Builder

Create your own AI tool that writes directly into the spreadsheet

Browser Info

Capture information from the browser including OS, the browser agent and the language locale.

Data Mover

Trigger advanced data movements behind the scenes.

Export to Excel

Export contents in the spreadsheet to an Excel Spreadsheet

External Parameters

Connect between projects, using a Parent/Child relationship?

Export to PDF

Capture data in the spreadsheet and format it as an external PDF.

Tableau Parameters

Wire a project up to Tableau, allowings for cross platform integration.

Text Join

Take lists of data and combine them into a single string, in a single cell

Timer

Delay data movements and triggers, moving data blocks or creating loops.

Unique List

Take a list of values and return a list of all unique values, removing duplications