---
title: Use functions
slug: use-functions
description: Apply built-in functions to transform data and create complex formulas within your scenarios
image: https://archbee-image-uploads.s3.amazonaws.com/oAyFj2GHlBeBVWF5OAir2/ZgNFXLvBBwV9mHnQCvWPq_domino-zoomin-purple-a-1.png
docTags: 
createdAt: 2025-02-03T13:29:15.598Z
---

When [mapping items](docId\:upfwoZsCC5SoIXR2954z2), you can use functions to create complex formulas. The functions available in Make are similar to functions in Excel or those in other programming languages. The functions let you perform various transformations of item values, such as converting a text to uppercase, trimming a text, converting a date into a different format, and many others.

::embed[]{url="https://www.youtube.com/watch?v=UHnsWDRLvEw"}

## Insert functions into fields

Functions can be inserted into fields the same way as items. Click a field to view the mapping panel.

The mapping panel contains several tabs:

::Image[]{src="https://api.archbee.com/api/optimize/yAufeXqD1oGWOPBNi5MAm-SQ0IIEjBevOWtMvPzxgeY-20250226-090300.png" size="60" width="1000" height="860" position="flex-start" alt="Using functions" darkWidth="1000" darkHeight="860" showCaption="false"}

The first tab (shown upon opening the panel) displays the items that you can map from other modules.

The other tabs contain various functions:

- [General functions](docId\:pMt2j3NdX4B4BP51gXk6T) 
- [Math functions](docId\:oxBNhXmSPoAi2KLTL2_Ee) 
- [Text and binary functions](docId\:ITv03E8O5wi28VCTDEElU) 
- [Date and time functions](docId:1kv1ib5q50i0SLbc7G2PZ) 
- [Array functions](docId\:K8NyMRgqbg3l_8LnPX7Wm) 
- [Custom functions](docId:6aXxxE6k-Lc5Pm-4qrLaV) 
- [Custom and system variables](docId:5UJ3-0KGuD4jwffMxAm-9) 

To insert a function into a field, click the function name or drag it to the field.

### Example

When posting a new tweet with the **Twitter > Create a tweet** module, you should not exceed Twitter's 280-character limit. Otherwise, the module throws an error. If you map a text item that can contain more than 280 characters into the module's **Status** field, you can use the `substring()` function to limit the tweet to 280 characters:

::Image[]{src="https://api.archbee.com/api/optimize/oAyFj2GHlBeBVWF5OAir2/TxWWjBp5q81m2jxckzAJl_uuid-17962706-05f1-025c-5f23-84c3fba03e7e.png" size="50" width="874" height="152" position="flex-start" alt="Substring function" darkWidth="874" darkHeight="152" showCaption="false"}

## Google Sheets functions

If you miss a function, but it is featured by **Google Sheets**, you may use it like this:

::::WorkflowBlock
:::WorkflowBlockItem
In Google Sheets, create a new empty spreadsheet.
:::

:::WorkflowBlockItem
In Make open your scenario.
:::

:::WorkflowBlockItem
Insert the **Google Sheets > Update a cell** module.
:::

:::WorkflowBlockItem
Configure the module:

1. Choose the newly created spreadsheet in the **Spreadsheet **field.
2. Instert your formula containing the Google Sheets function into the Value field.

::Image[]{src="https://api.archbee.com/api/optimize/yAufeXqD1oGWOPBNi5MAm--uzAkYHo0yDmY4-BUV3Yn-20250226-091911.png" size="70" width="1000" height="622" position="flex-start" alt="Value field" darkWidth="1000" darkHeight="622" showCaption="false"}
:::

:::WorkflowBlockItem
Insert the **Google Sheets > Get a cell** module to obtain the calculated result.
:::

:::WorkflowBlockItem
Configure the module. Fill in the same **Cell **ID as you filled in step 4.

::Image[]{src="https://api.archbee.com/api/optimize/yAufeXqD1oGWOPBNi5MAm-Jw-8V-7m2E42xPGYUod4J-20250226-091941.png" size="70" width="1000" height="534" position="flex-start" alt="Cell ID" darkWidth="1000" darkHeight="534" showCaption="false"}
:::
::::