When mapping items, you can use functions to create complex formulas. The functions available in Integromat 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 will pop up. The mapping panel contains several tabs:
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 140-character limit otherwise the module will throw en error. If you map a text item that can contain more than 140 characters into the module's Status field, you can use the
substring() function to limit the tweet to 140 characters:
If you miss a function, but it is featured by Google Sheets, you may exploit it like this: