# Functions

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 <img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2F1tR8YwSanAqrfQVfur5l%2FAdd%20Function%20Icon.svg?alt=media&#x26;token=2ee988ae-f736-4ce3-b288-2edbd6192605" alt="" data-size="line"> icon in the Sidebar.&#x20;

To add a new function click the add <img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FUd6a7bfWPXQ51VczSkia%2FAdd%20Connection%20to%20tree%20Icon.svg?alt=media&#x26;token=fac58036-8b4c-4969-bc6c-08d5c7e85c95" alt="" data-size="line"> icon to open the Function Library where you can browse that available functions and select the one you need.

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FV0jSLMr3GvDjdOd5OsRw%2FAdding_function.png?alt=media&#x26;token=cd80d296-fcc0-420b-b931-339404c5546e" alt="" width="375"><figcaption></figcaption></figure>

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

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FtWUX92JTLFqkfg5v7f95%2FFucntions%20-%20with%20functions%20added.svg?alt=media&#x26;token=e8a59ada-896e-439a-b018-40de50608d57" alt=""><figcaption></figcaption></figure>

***

## Looking for something in particular?

<table data-view="cards"><thead><tr><th></th><th></th><th></th><th data-hidden data-card-cover data-type="files"></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td>AI Builder</td><td>Create your own AI tool that writes directly into the spreadsheet</td><td></td><td><a href="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FlquWeATHALIHcKKUqXKG%2FAI%20function.svg?alt=media&#x26;token=94e20b25-e39b-453c-b3d6-4ab56fcd530c">AI function.svg</a></td><td><a href="overview-1/other/ai-builder">ai-builder</a></td></tr><tr><td><strong>Browser Info</strong></td><td>Capture information from the browser including OS, the browser agent and the language locale.</td><td></td><td><a href="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FTZqhqrwkGfl9IRcnKRN0%2FBrowser%20Info.svg?alt=media&#x26;token=0b650626-3bae-45fa-8c77-ad1eb21b7428">Browser Info.svg</a></td><td><a href="overview-1/input-output/browser-info">browser-info</a></td></tr><tr><td><strong>Data Mover</strong></td><td>Trigger advanced data movements behind the scenes.</td><td></td><td><a href="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FoTIy0OMJoOWpSdzhecfQ%2FData%20Mover.svg?alt=media&#x26;token=7308a09a-84bd-4960-90f6-75710073ae4b">Data Mover.svg</a></td><td><a href="overview-1/spreadsheet-and-data/data-mover">data-mover</a></td></tr><tr><td><strong>Export to Excel</strong></td><td>Export contents in the spreadsheet to an Excel Spreadsheet</td><td></td><td><a href="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FwTVYjgg0uxEuxAeSDENo%2FExport%20to%20Excel.svg?alt=media&#x26;token=3949bc4e-73a8-4d18-af72-3e0b444e404f">Export to Excel.svg</a></td><td><a href="overview-1/input-output/export-to-excel">export-to-excel</a></td></tr><tr><td><strong>External Parameters</strong></td><td>Connect between projects, using a Parent/Child relationship?</td><td></td><td><a href="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FTr27CM0nFpRPOBDh1cJE%2FExternal%20Parameters.svg?alt=media&#x26;token=7c2e95dd-a903-45e0-a3df-cf99047e3b43">External Parameters.svg</a></td><td><a href="overview-1/input-output/external-parameters">external-parameters</a></td></tr><tr><td><strong>Export to PDF</strong></td><td>Capture data in the spreadsheet and format it as an external PDF.</td><td></td><td><a href="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FCcUabgNqFczMVgVkHNQg%2FExport%20to%20PDF.svg?alt=media&#x26;token=d836f947-0beb-4b78-9a6e-871af23de40a">Export to PDF.svg</a></td><td><a href="overview-1/input-output/export-to-pdf">export-to-pdf</a></td></tr><tr><td><strong>Tableau Parameters</strong></td><td>Wire a project up to Tableau, allowings for cross platform integration.</td><td></td><td><a href="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FroRagAvD9Dy29ep5PrmM%2FTableau%20Parameters.svg?alt=media&#x26;token=bc5fae1f-dffe-43a5-80d0-a6dd4e5e19d5">Tableau Parameters.svg</a></td><td><a href="overview-1/input-output/tableau-parameters">tableau-parameters</a></td></tr><tr><td><strong>Text Join</strong></td><td>Take lists of data and combine them into a single string, in a single cell</td><td></td><td><a href="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2F2XF30lVEDyICkeLaZs2H%2FTextJoin.svg?alt=media&#x26;token=942ad7ef-1d6f-4638-a3fd-5857da4579a7">TextJoin.svg</a></td><td><a href="overview-1/spreadsheet-and-data/textjoin">textjoin</a></td></tr><tr><td><strong>Timer</strong></td><td>Delay data movements and triggers, moving data blocks or creating loops.</td><td></td><td><a href="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2Fdkfk6FKEs5axcwibIiTN%2FTimer.svg?alt=media&#x26;token=c0816582-48e2-4b53-8be2-12fb3c486944">Timer.svg</a></td><td><a href="overview-1/spreadsheet-and-data/timer">timer</a></td></tr><tr><td><strong>Unique List</strong></td><td>Take a list of values and return a list of all unique values, removing duplications</td><td></td><td><a href="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2Fca09QtM0SwWQmYnPx4Ki%2FUnique%20List.svg?alt=media&#x26;token=827f2135-6e43-4e1e-a8b2-86f37095cc35">Unique List.svg</a></td><td><a href="overview-1/spreadsheet-and-data/unique-list">unique-list</a></td></tr></tbody></table>
