Overview

This is an overview page of Squirrel's functions, their uses as well as navigation to articles for each of the available functions.

Squirrel Functions enable the movement of data in the spreadsheet, working behind the scenes as "invisible components." These functions do not have a physical presence on the canvas but can be activated by visible components and controls.

Looking for something in particular?

Data Mover

Trigger advanced data movements behind the scenes.

External Parameters

Connect between projects, using a Parent/Child relationship?

Export to Excel

Export contents in the spreadsheet to an Excel Spreadsheet

Export to PDF

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

Timer

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

Tableau Parameters

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

Browser Info

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

Text Join

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

Unique List

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