Explore more
Functions

Use functions

3min
when mapping docid\ upfwozscc5soixr2954z2 , you can use functions to create complex formulas the functions available in {{product name}} 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 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 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 string functions docid\ itv03e8o5wi28vctdeelu date and time functions docid 1kv1ib5q50i0slbc7g2pz array functions docid\ k8nymrgqbg3l 8lnpx7wm custom functions docid 6axxxe6k lc5pm 4qrlav 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 google sheets functions 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 {{product name}} open your {{scenario singular lowercase}} insert the google sheets > update a cell module configure the module choose the newly created spreadsheet in the spreadsheet field instert your formula containing the google sheets function into the value field 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