When mapping items, 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.
Functions can be inserted into fields the same way as items. If you click into a field, the mapping panel pops up.
The mapping panel contains several tabs:
-
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 - see General functions
-
Math functions - see Math functions
-
Text and binary functions - see String functions
-
Date and time - see Date & time functions
-
Functions for working with arrays - see Array functions
-
To insert a function into a field, click the function name or drag it to the field.
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:
If you miss a function, but it is featured by Google Sheets, you may use it like this:
-
In Google Sheets, create a new empty spreadsheet.
-
In {{Make}}, open your scenario.
-
Insert the Google Sheets > Update a cell module.
-
Configure the module:
-
Insert the Google Sheets > Get a cell module to obtain the calculated result.
-
Configure the module. Fill in the same Cell ID as you filled in step 4.
