Implemented Formula Suggestion Box

Introduction

The formula suggestion box is a smart feature for using the formulas you need for particular automation. This function helps you get an autocomplete expression in automation by entering the "=" symbol in the corresponding field.

Overview

Sapper offers a variety of formula suggestions, that can be implemented in diverse automation. This formula suggestion box is available for all the respected fields. This feature is available for the optional fields associated with the various applications. The formula suggestions box is helpful for the easier application of formula functions in automation. It allows you to choose any formula just by searching the keywords on the suggestion box, which eventually helps to ensure a faster automation execution. You can view a list of formulas associated with the searched keywords. It makes the process of formula application simple. Further, you can add as much as the formula required for the particular optional field. This aspect is very similar to the google sheet excel formula suggestion features. This feature is also known as Auto-complete formulas. It helps you to minimize the typing and syntax errors by autocomplete function and arguments insert. Sapper allows you to get all the formula’s in a menu, that consists of various useful formulas. You just need to select the optional field and choose the formula from the suggestion box. The menu of the formula is added in the suggestion box, you just need to insert the desired formula from the list and save it for further process. You will get the suggestions for all the formulas only by inserting the keywords, symbols, or the data context. You can always show the AutoComplete menu when you begin typing a formula, or to narrow down the number of possible entries that you see, you can display the menu only after you've typed a certain number of letters.

You will also get the option for inserting formulas in optional field, the suggestions will be automatically displayed as you continue to type. You can view additional incremental suggestions in the drop-down menu.


For example:

If you search for the LOOKUP, you will get the suggestions of all the LOOKUP formulas LOOKUPLASTVALUEMATCH; LOOKUPALLVALUES; LOOKUPVALUE Similarly if you search for DATE, you will get all the suggestions associated with DATE formula, CURRENT_DATE; MODIFY_CURRENT_DATE; MODIFY_DATE You can also search the formula from the suggestion box by searching the return type Suppose you have instert string, and you will be able to see all the string formula in the suggestion box menu TO_STRING; SUBSTRING

You will also able to view the details of the specific formulas from the “Formula Suggestion Box”. These details are included Description, Return Type, Arguments, Example and Documentation about the specific formula. It will be helpful for you to choose the formula accordingly.

Key

Description

Example

Key

Description

Example

Description

The description is a detailed information related to the specific formula.

 

Return Type

The return type defines and constrains the data type of the value returned from a subroutine or method. The return type can be the type of the formulas used in the automation.

String, Number, List, Lookup, Date, and IF.

Arguments

The arguments is a combination of the formula formats that is designed for the specific formula.

String outputFormat,String timeZone

Example

In the example field you will be able to view the formula format example.

CURRENT_DATE("dd/MM/yyyy HH:mm:ss","PST")

Documentation

The documentation field is associated with the link of the specific formula details.

 

Core Features

The formula suggestion box is associated with various features. Those are mentioned below.

  • Keyword search: In the “Formula Suggestion Box” you can search for the various formula’s just by inserting the Keywords. It helps to provide you the easy access for all the formula’s associated with automation.

  • Easy visibility: The formulas in the suggestion box are arranged in a systematic manner. You will be able to view it in a menu format. That eventually helpful enhance the visibility.

  • Drop-down options: In the “Formula Suggestion Box”, you will be able to view and choose the formula’s from the drop-down menu.

  • Availability of all formulas: Once you insert the keywords or the specific symbol in the “Formula Suggestion Box”, you will be able to get all the relevant formulas in the suggestion box menu.

  • Multiple formula suggestions: You can get and add various formula’s from the Suggestion box. Multiple formulas can be added in the optional field of the automation.

  • Enable copy-paste features: You can copy and paste the formulas from the “Formula Suggestion Box”. It will help you to reduce the formula insert error.

  • Detailed information: In the “Formula Suggestion Box” you can access the detailed information associated with the formula. It will help understand the application of the formula just by getting the formula list.

  • Formula save option: In the suggestion box you will be able to get the tick and cross option in the formula button. If you want to save the formula’s then you need to add the formula from the search list. Now, you need to click on the tick option of the formula button. On the other hand, if you want to unsaved it click on the cross option associate with the formula button.

  • Hide formula option: In the suggestion box you will also get the option for hide the formulas from the top right side of the searching option.

Benefits of the formula suggestion box

The formula suggestion box for automation has various benefits. A few of them are mentioned below:

  • Easy access to all the relevant formulas in a single place

  • Easy to use for the automation

  • Save time and enhance efficiency

  • Helpful for getting a detailed information

  • Ensure error-free process

  • Enable a faster data analysis

  • Enhance accuracy

How to use the formula suggestion box?

  1. Click on the “Automation” tab from the Sapper home page.

2. Now select the desired automation from the list of automation or create it from the “Automation” tab.

3. To create a new automation click on the “Create Automation”, and the new form will appear on the screen.

 

4. Now, provide the “Name” and “Description” for the automation, and “Save” it.

 

5. Drag and drop the application and connect with the “Start” and “End” points for further process.

 

6. Now, select the “Connection” from the drop-down list. You can also create a new connection if needed. Here we have selected the Jira connection.

 

7. Select the “Action” from the drop-down list. You can also customize the action based on your requirement.

 

8. Now, choose the formula for the optional field. You can choose any formula based on your requirement.

 

9. Once you click on the formula the “Suggestion box” is pop up on the screen. This box appeared as a black box.

 

10. You can find out the required formula by searching the keywords on the “Formula Suggestion Box”.

11. You will be able to select any of the formulas from the list based on your requirement.

 

12. You can add multiple formulas for the optional fields based on the requirement of the automation.

For example:

CURRENT_DATE; SUM; CURRENT_DATE

 

13. Once you are done with adding the formulas for the optional field, you need to click on the formula tab from the side of the field.

14. Now “Save” it to complete the automation.