Introduction
Data slots contain the output of previous actions that can be used in further task nodes. The data in the data slots can furthermore be transformed into a specific type or format. Data from a single app or source may not be usable for other apps or sources.
In such cases, data transformation is important to perform by providing the correct format of the data for the task as per the desired sources. This can be done using transformation formulas. In this section, you will get details about the additional transformation formulae supported by Sapper.
| Table of Contents |
|---|
Overview
Additional transformation formulae consist of core three formulas i.e., Date Formulae; String Formulae, and IF Formula.
Date Formulae
The date formula consists of formulae related to date. There is various type of formulas for Date, i.e., Current Date, Modify Date, Previous Date, Day of the week, Day number of year, Start of Hour , Start of Day, Start of Month, Start of Year, Start of Week, Last day of Month and To covert Specific Format .
Examples:
| Code Block |
|---|
MODIFY_CURRENT_DATE DAYMODIFY_OF_WEEkDATE |
For more information visit : Date Formulae
String Formulae
The string formula consists of formulae related to string. There is various type of formulas for string, i.e., Concatenate, Starts, Reverse, Substring, Contains, Exact, Upper, Lower, Isblank, Ends, Trim, Substitute, Split, Search, Proper, Bytes, Match, Is not true, Exclude, Removespacialchars, Lstrip, Rstrip, Strip_Tags, Ljust, Rjust, Sub, Length, Scan, Encode, Transliterate, Quote, To_S, Ordinalize, and Bytesize.
Examples:
| Code Block |
|---|
ISTO_NOT_TRUE STRIP_TAGS CEILINGSTRING SUBSTRING |
For more information visit : String Formulas
IF Formula
The IF formula consists of IF conditions. There is various type of formulas for IF. Currently we are supporting Condition Evaluation. We will add more related formulas in future.
Examples:
| Code Block |
|---|
TO_CONVERT_SPECIFIC_FORMAT
IF |
For more information visit: IF Formulae
Role of Transformation Formula?
Formula plays a vital role for every automation. It helps you to put specific details based on the requirements. With the help of formula you can provide the conditions for specific information boxes, actions, messages, values, events, pop-up and items.
Steps to use formula
All these formula’s can be used for any applications. For example here we are selecting FreshTeams.
2. The formula’s can be used for specific field for the FreshTeam. For example, if you want to put a specific formula in the “first name” or in the “Last name”, then you need to select the field and add the formula from the top right side.
3. Now, you can find the specific formula’s based on your need. Here, you can use the formula’s related to string, IF, Date, Number, lookup and List. The the supported formula’s by Sapper will are available in the search list.
4. Add the formula’s in all the required field and click on save to proceed further.
