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.
Additional transformation formulae consist of core three formulas i.e., Date Formulae; String Formulae, and IF Formula.
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:
MODIFY_CURRENT_DATE MODIFY_DATE |
For more information visit : Date 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:
TO_STRING SUBSTRING |
For more information visit : String Formulas
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:
TO_CONVERT_SPECIFIC_FORMAT IF |
For more information visit: IF Formulae
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.
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.