When users map items, functions can be used to create complex formulas. Think of them as functions within Microsoft Excel, where complex actions can be automatically executed. While this is mostly intended for advance users, the below shows you how users can perform actions such as converting a text to uppercase, trimming a body of text, converting dates into various formats and more.
Inserting functions into fields
When you click into a field, the mapping panel will appear and will contain several tabs. Tabs usually contain the following items that you can map from other modules, as well as various functions including:
- General functions
- Math functions
- Text and binary functions
- Date and time
- Array functions
- Other Alaya Connector functions
To insert a function into a field, click the function name or drag it to the field.
Example: shortening a tweet
Under the Twitter > Create a tweet module, users can map a text item and limit it to no more than 280 characters into the module's Status field using the
Using Google Sheets into your functions
Users may directly use a Google Sheet function within Alaya Connector per below:
- Create a new spreadsheet on Google Sheets.
- Open your scenario in Alaya Connector.
- Insert the Google Sheets > Update a cell module.
- Configure the module by choosing the newly created spreadsheet in the Spreadsheet field, then insert your formula containing the Google Sheets function(s) into the Value field. Users may use the output of preceding modules as usual.
- Insert the Google Sheets > Get a cell module to obtain the calculated result.
- Configure the module and use the same Cell ID as steps above