Explore additional Transformation Formulae

Owned by shreedutta.mukherjee (Unlicensed)
Last updated: May 02, 2022
3 min read

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.

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:

MODIFY_CURRENT_DATE MODIFY_DATE

For more information visit : https://sappersoftware.atlassian.net/wiki/spaces/SD/pages/713293825

 

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:

TO_STRING SUBSTRING

For more information visit : https://sappersoftware.atlassian.net/wiki/spaces/SD/pages/668532719

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:

TO_CONVERT_SPECIFIC_FORMAT IF

For more information visit: https://sappersoftware.atlassian.net/wiki/spaces/SD/pages/712769567

 

 

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

  1. 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.

 

Related Article