{"id":18224,"date":"2024-02-21T09:09:07","date_gmt":"2024-02-21T09:09:07","guid":{"rendered":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/?post_type=article&p=18224"},"modified":"2025-05-08T12:04:15","modified_gmt":"2025-05-08T06:34:15","slug":"advanced-field-types","status":"publish","type":"article","link":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/article\/advanced-field-types\/","title":{"rendered":"Advanced Field Types in Form 2.0"},"content":{"rendered":"

In this article, we will help you to understand the Advanced Field Types in Form 2.0.<\/p>\n\n\n\n
\n

Skip Ahead to:<\/strong><\/p>\n

Introduction<\/a><\/p>\n

Master List Formatting<\/a><\/a><\/p>\n

Lookups<\/a><\/p>\n

Formula field<\/a><\/a><\/p>\n

Configuring a Formula in the Formula Builder<\/a><\/p>\n

Functions in Formula Builder<\/a><\/p>\n

Operators in Formula Builder<\/a><\/a><\/a><\/p>\n

Conditions in Formula Builder<\/a><\/a><\/p>\n

Data Grid<\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Introduction<\/h2>\n

<\/a>As the names suggest the advanced field types have advanced capabilities to define a filed type in Form 2.0. There are three advanced field types in Form 2.0.<\/p>\n

Master List<\/h3>\n

Forms 2.0 allows you to use the master list as the field value in a form. You can use the project master list as well as the organization master list in the form to use as the values of a drop-down list.
\nDetails<\/b><\/p>\n\n\n\n\n\n\n\n\n\n\n\n
Fields\u00a0<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
Display Label<\/b><\/td>\nEnter the name that you want to give to the field. It will be visible to the users in the form, such as First Name, Last Name, etc.<\/td>\n<\/tr>\n
Hide display label<\/b><\/td>\nTurn on this toggle to hide the label of the field so that the input field appears without any label on it.<\/td>\n<\/tr>\n
Field Name<\/b><\/td>\nEnter a unique name that will be only used by the system to identify this field. It will not be visible to a user.<\/td>\n<\/tr>\n
Helper text<\/b><\/td>\nEnter a helper text that will be visible to the user inside the field so that the user can enter the relevant information. For example, you can enter helper text for a name such as – Enter a name without a title.<\/td>\n<\/tr>\n
Dropdown type\u00a0<\/b><\/td>\nIt has two options – Single-select<\/b> and Multi-select<\/b>. Select the appropriate option to specify whether you want the user to select one value at a time or multiple values at a time.<\/td>\n<\/tr>\n
Enable search-select\u00a0<\/b><\/td>\nTurn this toggle On to allow the user to search the values in the drop-down by entering the initials of the value. For example, in the list of Countries, entering the character \u201cin\u201d will list all the countries having the letters \u201cin\u201d in it such as India, Indonesia, etc.<\/td>\n<\/tr>\n
Search Master List<\/b><\/td>\nSelect a master list from the drop-down list that you want to use in your field.<\/td>\n<\/tr>\n
Reposition field<\/strong>
\n<\/b><\/td>\n		Use this option to move the field between different blocks within the same tab or to a different tab.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Validations<\/b><\/p>\n\n\n\n\n\n
Mandatory<\/b><\/td>\nSet the toggle on if you want to make your field mandatory.<\/td>\n<\/tr>\n
Hide Field<\/b><\/td>\nSet the toggle on if you want to hide this field.<\/a><\/td>\n<\/tr>\n
Field Type<\/b><\/td>\nSet whether you want to set this field as read-only or editable.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Rules<\/strong><\/p>\n

The rule is useful if you want to set a condition for your field. For example, if the specific value is selected then the color of the field changes to a predefined color to highlight the field.<\/p>\n

There are two types of Rules \u2013<\/p>\n

    \n
  1. Font Color Decorator Rule<\/a><\/li>\n
  2. Validation Rule<\/a><\/li>\n<\/ol>\n

    Lookups<\/h3>\n

    Forms 2.0 allows you to use a field from an existing form to your form. For example, if you have a form named Order<\/b> and a field named Name and\u00a0want to use the same Name<\/b> field in a new form called Purchase Order<\/b>, then you can do that with the help of Lookups.\u00a0 A Lookup field has the following settings –
    \nDetails\u00a0<\/b><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    Fields\u00a0<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
    Display Label<\/b><\/td>\nEnter the name that you want to give to the field. It will be visible to the users in the form, such as First Name, Last Name, etc.<\/td>\n<\/tr>\n
    Hide display label<\/b><\/td>\nTurn on this toggle to hide the label of the text field so that the input field appears without any label on it.<\/td>\n<\/tr>\n
    Field Name<\/b><\/td>\nEnter a unique name that the system will only use to identify this field. It will not be visible to a user.<\/td>\n<\/tr>\n
    Helper text<\/b><\/td>\nEnter a helper text that will be visible to the user inside the field so that the user can enter the relevant information. For example, you can enter helper text for a name such as – Enter a name without a title.<\/td>\n<\/tr>\n
    Dropdown type\u00a0<\/b><\/td>\nIt has two options – Single-select<\/b> and Multi-select<\/b>. Select the appropriate option to specify whether you want the user to select one value at a time or multiple values at a time.<\/td>\n<\/tr>\n
    Enable search select\u00a0<\/b><\/td>\nTurn this toggle On to allow the user to search the values in the drop-down by entering the initials of the value. For example, in the list of Countries, entering the character \u201cin\u201d will list all the countries having the letters \u201cin\u201d in it such as India, Indonesia, etc.<\/td>\n<\/tr>\n
    Search Master List<\/b><\/td>\nSelect a master list from the drop-down list that you want to use in your field.<\/td>\n<\/tr>\n
    Lookup form<\/b><\/td>\nSelect the form field you want to use in your form. It also displays list instances from Lists 2.0. Learn more about it here.<\/td>\n<\/tr>\n
    Lookup field<\/b><\/td>\nWhen you select the form, all the fields of that form along with its block name appear in this list. Select the field that you want to select. If a segment of a form has two fields with the same name, then both fields will be listed in this list. The field names are followed by the segment name in the list so that it is easy to select the right field. <\/span><\/td>\n<\/tr>\n
    Add fields of Lookup Form<\/b><\/td>\nBased on the Lookup field chosen by the configurator list of fields would appear in this section. With the help of this property, the configurator would be able to set the associated field for the lookup. These fields are read-only fields whose values appear based on the value set on the main lookup field. For example, In the purchase order form, there is a lookup field Vendor name, and the associated field is Vendor Location which is referenced from the Vendor Form. End users when they create a purchase order form by selecting the value of the Vendor Name field, the Vendor Location field value would get the value.<\/span><\/p>\n

    You can also provide an alternate label name to these read-only fields to avoid conflicts in the current form. let’s say If the form already contains fields with similar or identical names, you can rename the read-only fields to something unique. This helps prevent overlap with other fields in the form.
    \nFor example, if a form already has a field called “Location,” and the lookup field pulls in a “Vendor Location,” you can rename the lookup’s “Vendor Location” field to something like “Supplier Location” to make it clearer and avoid any conflict with the existing “Location” field.<\/p>\n<\/td>\n<\/tr>\n

    Reposition field<\/strong>
    \n<\/b><\/td>\n    		Use this option to move the field between different blocks within the same tab or to a different tab.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    Validations<\/b><\/p>\n\n\n\n\n\n
    Mandatory<\/b><\/td>\nSet the toggle on if you want to make your field mandatory.<\/td>\n<\/tr>\n
    Hide Field<\/b><\/td>\nSet the toggle on if you want to hide this field.<\/td>\n<\/tr>\n
    Field Type<\/b><\/td>\nSet whether you want to set this field as read-only or editable.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    While selecting a lookup field from a form, you can also select the associated field of a lookup field by simply selecting the check boxes of the relevant fields. The associated fields are non-editable\/read-only.\u00a0 In the given image, The Order Number is the Lookup field from the Item form while the Price, Amount, Discount, etc are the associated field.
    \n\"Look<\/a><\/p>\n

    Formula<\/h3>\n

    Forms 2.0 allows you to add a formula in a field so that it automatically calculates the values depending upon the formula and shows the calculated value in the form. This is useful when you want to design a form that automatically calculates values and saves a lot of human effort and chances of mistakes in manual calculation.
    \nDetails\u00a0<\/b><\/p>\n\n\n\n\n\n\n\n\n\n\n
    Fields\u00a0<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
    Display Label<\/b><\/td>\nEnter the name that you want to give to the field. It will be visible to the users in the form, such as First Name, Last Name, etc.<\/td>\n<\/tr>\n
    Hide display label<\/b><\/td>\nTurn on this toggle to hide the label of the formula field so that the input field appears without any label on it.<\/td>\n<\/tr>\n
    Field Name<\/b><\/td>\nEnter a unique name that the system will only use to identify this field. It will not be visible to a user.<\/td>\n<\/tr>\n
    Helper text<\/b><\/td>\nEnter a helper text that will be visible to the user inside the field so that the user can enter the relevant information. For example, you can enter helper text for a name such as – Enter a name without a title.<\/td>\n<\/tr>\n
    Field icon<\/b><\/td>\nSelect an icon from the available list of icons to display with the filed name in the form.<\/td>\n<\/tr>\n
    Formula\u00a0<\/b><\/td>\nEnter a unique name for the formula that you are configuring in the formula builder.<\/td>\n<\/tr>\n
    Reposition field<\/strong>
    \n<\/b><\/td>\n    		Use this option to move the field between different blocks within the same tab or to a different tab.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    Validations<\/b><\/p>\n\n\n\n\n\n
    Mandatory<\/b><\/td>\nSet the toggle on if you want to make the field mandatory.<\/td>\n<\/tr>\n
    Hide Field<\/b><\/td>\nSet the toggle on if you want to hide the field.<\/a><\/td>\n<\/tr>\n
    Field Type<\/b><\/td>\nSet whether you want to set this field as read-only or editable.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    Rules<\/strong><\/p>\n

    The rule is useful if you want to set a condition for your field. For example, if the specific value is selected then the color of the field changes to a predefined color to highlight the field.<\/p>\n

    There are two types of Rules \u2013<\/p>\n

      \n
    1. Font Color Decorator Rule<\/a><\/li>\n
    2. Validation Rule<\/a><\/li>\n<\/ol>\n

      Configuring a Formula in the Formula Builder<\/h3>\n

      The Formula Builder in Form 2.0 allows you to configure a formula and apply it to the formula field so that the field’s value is automatically calculated based on the given formula. It has predefined functions, conditions, and operators to help you configure a formula. The left panel in the formula builder contains all the conditions and functions while the bottom bar contains all the available operators.<\/p>\n

      \"Formula<\/a><\/p>\n

      To configure a formula, perform the following steps –<\/p>\n

        \n
      1. Insert the formula field in the required field segment of the form.<\/li>\n
      2. Clock the formula field. The Reposition<\/strong>, Settings<\/strong>, and Delete<\/strong> icons are enabled.<\/li>\n
      3. Click the Settings <\/b>icon.
        \n        \"Formula<\/a><\/li>\n
      4. On the Details<\/b> tab, click Configure Formula<\/b>. The Formula Builder<\/b> appears.
        \n        \"Formula<\/a><\/li>\n
      5. On the left pane, click the Block Fields<\/strong> tab and expand the required field segment.<\/li>\n
      6. Drag the required field name to the Configure<\/strong> area. You can also enter # and select the required field name from the list.<\/li>\n
      7. Click the required operator at the bottom bar. You can also enter the required operator with the keyboard.<\/li>\n
      8. To insert a function in the field or formula, <\/a>click the Functions<\/strong> tab and drag the required function. You can also enter @ and select the required function.
        \n        \"Formula<\/a><\/li>\n
      9. Once the formula is configured, click the Save<\/strong> button.<\/li>\n<\/ol>\n

        The value of the field will be calculated automatically depending on the formula defined in the formula builder.<\/p>\n

        Note:<\/strong> Changing the formulas of a field will also impact any formula field that is depend on it.<\/p>\n

        Functions in Formula Builder<\/h3>\n

        The Formula Builder supports the Date and Time, Numeric, and String functions as mentioned in the given table.
        \nPlease note, for all the users, the date is returned in the format selected by the user in the User Preferences.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
        Function<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
        \n

        Date and Time Functions<\/b><\/p>\n<\/td>\n<\/tr>\n

        \n

        <\/a>DATEADD<\/b><\/p>\n<\/td>\n

        		The DateAdd function adds a specified number of units to the Date\/Time value. Users can also subtract a specified number of units from a date or time value by specifying a negative value. Units can be years, months, weeks, days, hours, minutes, seconds.
        \nSyntax<\/b>:
        \nDATEADD[dateTime, number, units(ex days, hours)]
        \nExample<\/b>:
        \nDATEADD[17-Mar-2024 09:57:29, 02, days]
        \nThe function adds 2 days to the dateTime and returns 19-Mar-2024 09:57:29 as the output.
        \nDATEADD[17-Mar-2024 09:57:29, 02, hours]
        \nThe function adds 2 hours to the dateTime and returns 17-Mar-2024 11:57:29 as the output.<\/td>\n<\/tr>\n
        \n

        <\/a>DATE<\/b><\/p>\n<\/td>\n

        		The DATE function returns the date value from the year, month and day values the user entered.
        \nSyntax<\/b>:
        \nDATE[year, month, day]
        \nExample<\/b>:
        \nDATE[2021, 01, 26]
        \nIt returns 26-Jan- 2023 as the output.<\/td>\n<\/tr>\n
        \n

        <\/a>DATEDIFF<\/b><\/p>\n<\/td>\n

        		The DATEDIFF function returns the difference between two date\/time values. The Units can be years, months, days, hours.
        \nSyntax<\/b>:
        \nDATEDIFF[date1, date2, units(ex days, hours)]
        \nExample<\/b>:
        \nDATEDIFF[BlockName.DOB, TODAY, years]
        \nHere BOB is a field name in the form.
        \nThe function will return the age\/number of years between DOB and today.
        \nDATEDIFF[17-March-2024, 19-March-2024, days]
        \nThe function will return 2 as the output.<\/td>\n<\/tr>\n
        \n

        DATEVALUE<\/b><\/p>\n<\/td>\n

        		The DATEVALUE function converts a date string to a date value. The Date string should be in DD-Mon-YYYY format only.<\/td>\n<\/tr>\n
        \n

        DATETIMEVALUE<\/b><\/p>\n<\/td>\n

        		The DATETIMEVALUE function converts a date and time string to a date and time value. The date and time string should be in DD-Mon-YYYY hh:mm:ss format only.<\/td>\n<\/tr>\n
        \n

        TIMEVALUE<\/b><\/p>\n<\/td>\n

        		The TIMEVALUE function converts a time string to a time value. The time string should be in hh:mm: ss format only.<\/td>\n<\/tr>\n
        \n

        <\/a>TIMENOW<\/b><\/p>\n<\/td>\n

        		Returns a time value in GMT representing the current moment. This function is useful if you only want to track time, without a date. Note: The NOW function returns the date and time while the TIMENOW function only returns the time.
        \nSyntax<\/b>:
        \nTIMENOW
        \nExample<\/b>:
        \nTIMENOW
        \nIf the current moment is 10:23:54 and the date is 17-Mar-2024 then it returns 10:23:54 (only time) as output.<\/td>\n<\/tr>\n
        \n

        <\/a>TODAY<\/b><\/p>\n<\/td>\n

        		The TODAY function returns the current date as a date data type.
        \nSyntax<\/b>:
        \nTODAY
        \nExample<\/b>:
        \nTODAY
        \nIf today is 17-Mar-2024 then it returns 17-Mar-2024 as output.<\/td>\n<\/tr>\n
        \n

        <\/a>WEEKDAY<\/b><\/p>\n<\/td>\n

        		The WEEKDAY function returns the weekday of a Date\/Time value. By default, the result ranges from 1 (Sunday) to 7 (Saturday).
        \nSyntax<\/b>:
        \nWEEKDAY[dateTime]
        \nExample<\/b>:
        \nWEEKDAY[17-Mar-2024 09:57:29]
        \nSince 17-Mar-2024 is Sunday, it returns 1 as the output.
        \nWEEKDAY[NOW]
        \nIf the current day is Friday, it returns 6 as the output.<\/td>\n<\/tr>\n
        \n

        <\/a>DAY<\/b><\/p>\n<\/td>\n

        		The Day function returns the day component of a Day\/Time value ranging from 1 to 31.
        \nSyntax<\/b>:
        \nDAY[dateTime]
        \nExample<\/b>:
        \nDAY[17-Mar-2024]
        \nIt returns 17 as the output.<\/td>\n<\/tr>\n
        \n

        <\/a>HOUR<\/b><\/p>\n<\/td>\n

        		The Hour function returns the hour component of a Date\/Time value ranging from 0 (12:00 AM) to 23 (11:00 PM).
        \nSyntax<\/b>:
        \nHOUR[dateTime]
        \nExample<\/b>:
        \nHOUR[17-Mar-2024 09:57:29]
        \nIt returns 09 as the output.
        \nHOUR[NOW]
        \nIt returns the hour component of the current time.<\/td>\n<\/tr>\n
        \n

        <\/a>MINUTE<\/b><\/p>\n<\/td>\n

        		The Minute function returns the minute component of a Date\/Time value ranging from 0 to 59.
        \nSyntax<\/b>:
        \nMINUTE[dateTime]
        \nExample<\/b>:
        \nMINUTE[17-Mar-2024 09:57:29]
        \nIt returns 57 as the output.
        \nMINUTE[NOW]
        \nIt returns the minute component of the current time.<\/td>\n<\/tr>\n
        \n

        <\/a>MONTH<\/b><\/p>\n<\/td>\n

        		The Month function returns the month component of a Date\/Time value ranging from 1 to 12.
        \nSyntax<\/b>:
        \nMONTH[dateTime]
        \nExample<\/b>:
        \nMONTH[17-Mar-2024]
        \nIt returns 3 as the output.
        \nMONTH[NOW]
        \nIt returns the number of the current month.<\/td>\n<\/tr>\n
        \n

        <\/a>NOW<\/b><\/p>\n<\/td>\n

        		Returns the date and time representing the current moment.
        \nSyntax<\/b>:
        \nNOW
        \nExample<\/b>:
        \nNOW
        \nIf the current moment is 10:23:54 and the date is 17-Mar-2024 then it returns 17-Mar-2024 10:23:54 as output.<\/td>\n<\/tr>\n
        \n

        <\/a>SECOND<\/b><\/p>\n<\/td>\n

        		The Second function returns the second component of a Date\/Time value ranging from 0 to 59.
        \nSyntax<\/b>:
        \nSECOND[dateTime]
        \nExample<\/b>:
        \nSECOND[17-Mar-2024 09:57:29]
        \nIt returns 29 as the output.
        \nSECOND[NOW]
        \nIt returns the second component of the current time.<\/td>\n<\/tr>\n
        \n

        <\/a>YEAR<\/b><\/p>\n<\/td>\n

        		The Year function returns the year component of a Date\/Time value starting from 1900.
        \nSyntax<\/b>:
        \nYEAR[dateTime]
        \nExample<\/b>:
        \nYEAR[17-Mar-2024]
        \nIt returns 2024 as the output.
        \nYEAR[NOW]
        \nIt returns the current year.<\/td>\n<\/tr>\n
        \n

        Numeric Functions<\/b><\/p>\n<\/td>\n<\/tr>\n

        ABS<\/b><\/td>\n\n

        The ABS function returns the absolute (positive) value of a number.<\/p>\n

        Syntax<\/b>:<\/p>\n

        ABS[number]<\/p>\n

        Example<\/b>:<\/p>\n

        ABS[-5]<\/p>\n

        Output<\/b> \u2013 It returns 5 as the output.<\/p>\n<\/td>\n<\/tr>\n

        AVERAGE<\/b><\/td>\n\n

        The Average function calculates the arithmetic mean of a set of numbers by adding them up and dividing by the count of numbers in the set.<\/p>\n

        Syntax<\/b>:<\/p>\n

        AVERAGE[number1, number2, number3]<\/p>\n

        Example<\/b>:<\/p>\n

        AVERAGE[10, 20, 30]<\/p>\n

        Output<\/b> \u2013 It returns 20 as the output.<\/p>\n<\/td>\n<\/tr>\n

        CEILING<\/b><\/td>\n\n

        The Ceiling function rounds a number up to the nearest integer. It always returns the smallest integer greater than or equal to a given number.<\/p>\n

        Syntax<\/b>:<\/p>\n

        CEILING[number]<\/p>\n

        Example<\/b>:<\/p>\n

        CEILING[80.239]<\/p>\n

        Output<\/b> \u2013 It returns 80 as the output.<\/p>\n<\/td>\n<\/tr>\n

        EXP<\/b><\/td>\n\n

        The Exp function Returns the value of Euler’s number (approximately 2.71828) raised to the power of a specified number.<\/p>\n

        Syntax<\/b>:<\/p>\n

        EXP[number]<\/p>\n

        Example<\/b>:<\/p>\n

        EXP[2]<\/p>\n

        Output<\/b> \u2013 It returns 7.3890561 as the output.<\/p>\n<\/td>\n<\/tr>\n

        FLOOR<\/b><\/td>\n\n

        The Floor function rounds a number down to the nearest integer. It always returns the largest integer less than or equal to a given number.<\/p>\n

        Syntax<\/b>:<\/p>\n

        FLOOR[number]<\/p>\n

        Example<\/b>:<\/p>\n

        FLOOR[2.0902]<\/p>\n

        It returns 2 as the output.<\/p>\n

        FLOOR[-4.623]<\/p>\n

        Output<\/b> \u2013 It returns -5 as the output.<\/p>\n<\/td>\n<\/tr>\n

        LOG<\/b><\/td>\n\n

        The Log function calculates the logarithm of a number. Common logarithms are base 10, and natural logarithms are base e.<\/p>\n

        Syntax<\/b>:<\/p>\n

        LOG[number]<\/p>\n

        Example<\/b>:<\/p>\n

        LOG[10]<\/p>\n

        Output<\/b> \u2013 It returns 1 as output.<\/p>\n<\/td>\n<\/tr>\n

        MAX<\/b><\/td>\n\n

        The Max function returns the largest number in a set.<\/p>\n

        Syntax<\/b>:<\/p>\n

        MAX[number1, number2, number3]<\/p>\n

        Example<\/b>:<\/p>\n

        MAX[100, 160, 500, 40]<\/p>\n

        Output<\/b> \u2013 It returns 500 as output.<\/p>\n<\/td>\n<\/tr>\n

        MIN<\/b><\/td>\n\n

        The Min function returns the smallest number in a set.<\/p>\n

        Syntax<\/b>:<\/p>\n

        MIN[number1, number2, number3]<\/p>\n

        Example<\/b>:<\/p>\n

        MIN[100, 160, 500, 40]<\/p>\n

        Output<\/b> \u2013 It returns 40 as output.<\/p>\n<\/td>\n<\/tr>\n

        MOD<\/b><\/td>\n\n

        The Mod function returns the remainder of a division operation.<\/p>\n

        Syntax<\/b>:<\/p>\n

        MOD[number, divisor]<\/p>\n

        Example<\/b>:<\/p>\n

        MOD[17,5]<\/p>\n

        Output<\/b> \u2013 It returns 2 as output.<\/p>\n<\/td>\n<\/tr>\n

        POWER<\/b><\/td>\n\n

        The Power function raises a number to a specified power.<\/p>\n

        Syntax<\/b>:<\/p>\n

        POWER[base, exponent]<\/p>\n

        Example<\/b>:<\/p>\n

        POWER[5,3]<\/p>\n

        Output<\/b> \u2013 It returns 125 as output.<\/p>\n<\/td>\n<\/tr>\n

        ROUND<\/b><\/td>\n\n

        The Round function rounds a decimal number to the nearest digit. If the fractional part is exactly halfway between two digits, the result is the nearest to the even digit.<\/p>\n

        Syntax<\/b>:<\/p>\n

        ROUND[number, decimalPlaces]<\/p>\n

        Example<\/b>:<\/p>\n

        ROUND[221.8799, 2]<\/p>\n

        Output<\/b> \u2013 It returns 221.88 as output.<\/p>\n<\/td>\n<\/tr>\n

        SUM<\/b><\/td>\nThe Sum function calculates the total of a set of numbers by adding them together.
        \nSyntax<\/b>:
        \nSUM[number1, number2]
        \nExample<\/b>>:
        \nSUM[150,26]
        \nOutput<\/b> \u2013 It returns 176 as output.<\/td>\n<\/tr>\n
        SQRT<\/b><\/td>\n\n

        The SQRT function calculates the square root of a number.<\/p>\n

        Syntax<\/b>:<\/p>\n

        SQRT[number]<\/p>\n

        Example<\/b>:<\/p>\n

        SQRT[25]<\/p>\n

        Output<\/b> \u2013 It returns 5 as output.<\/p>\n<\/td>\n<\/tr>\n

        COUNT<\/b><\/td>\n\n

        The COUNT<\/strong> function allows you to count the number of items in a given list. It is useful for calculating the number of values in a field that contains multiple entries.<\/p>\n

        Syntax: <\/strong>COUNT(list)<\/p>\n

        Parameters:<\/strong><\/p>\n

          \n
        • \n

          list<\/strong>: A collection of numeric or text values to be counted.<\/p>\n<\/li>\n<\/ul>\n

          Example:<\/strong><\/p>\n

            \n
          • \n

            COUNT([Task1, Task2, Task3])<\/code> \u2192 Returns 3<\/code>.<\/p>\n<\/li>\n

          • \n

            COUNT([10, 20, 30, 40])<\/code> \u2192 Returns 4<\/code>.<\/p>\n<\/li>\n<\/ul>\n

            \n<\/td>\n<\/tr>\n

        String Functions<\/b><\/td>\n<\/tr>\n
        CONCAT<\/b><\/td>\nThe CONCAT function concatenates the string arguments and returns a new string.
        \nSyntax<\/b>:
        \nCONCAT[string1, string2, string3]
        \nExample<\/b>:
        \nCONCAT[Hello, World, !!]
        \nOutput<\/strong> – Hello World !!
        \nCONCAT[BlockName.FirstName,\u00a0 , BlockName.LastName]
        \nIt returns the first name and last name with a space between them.
        \nThe CONCAT function uses string\/alphanumeric values as its parameters. If you want to use a number or date value as its parameter then you can use the TEXT function.
        \nExample:<\/strong><\/p>\n

        CONCAT[TEXT[Serial No.], Name]<\/p>\n<\/td>\n<\/tr>\n

        CONTAINS<\/b><\/td>\nThe CONTAINS function compares two arguments of string (case sensitive) and returns TRUE if the first segment contains the second argument. If not, returns FALSE.
        \nSyntax<\/b>:
        \nCONTAINS[string, pattern]
        \nExample<\/b>:
        \nCONTAINS[Useful, use]
        \nOutput<\/strong> – It returns true as the word useful contains “use” in it.
        \nCONTAINS[Useful, color]
        \nOutput<\/strong> – It returns false as the string “color” is not part of the word useful.<\/td>\n<\/tr>\n
        ENDSWITH<\/b><\/td>\nThe ENDSWITH function tests whether the string (first argument) ends with the pattern (Second argument). The test is case-insensitive.
        \nSyntax<\/b>:
        \nENDSWITH[string, pattern]
        \nExample<\/b>:
        \nENDSWITH[Hello world, world]
        \nOutput<\/strong> – It returns true as the word “Hello world” ends with the word “world”.<\/td>\n<\/tr>\n
        LEFT<\/b><\/td>\nThe LEFT function returns the specified number of characters from the beginning of a string.<\/td>\n<\/tr>\n
        LEN<\/b><\/td>\nThe LEN function returns the number of characters in a specified string.<\/td>\n<\/tr>\n
        LOWER<\/b><\/td>\nThe LOWER function converts all letters in the specified string to lowercase.<\/td>\n<\/tr>\n
        MID<\/b><\/td>\nThe MID function returns the specified number of characters from the middle of a string given the starting position.<\/td>\n<\/tr>\n
        NOTCONTAINS<\/b><\/td>\n<\/td>\n<\/tr>\n
        RIGHT<\/b><\/td>\nThe RIGHT function returns the specified number of characters from the end of the string.<\/td>\n<\/tr>\n
        STARTSWITH<\/b><\/td>\nThe STARTSWITH function tests if the string (first argument) starts with the pattern (second argument).
        \nSyntax<\/b>:
        \nSTARTSWITH[string, pattern]
        \nExample<\/b>:
        \nSTARTSWITH[Hello world, Hello]
        \nOutput<\/strong> – It returns true as the word “Hello world” starts with the word “Hello”.<\/td>\n<\/tr>\n
        SUBSTITUTE<\/b><\/td>\nThe SUBSTITUTE function replaces all the occurrences of searchString(second argument) in the string (first argument) with the given repalceString (third argument) value. This function is case-sensitive.<\/td>\n<\/tr>\n
        TEXT<\/b><\/td>\nThe TEXT function converts any value and formats a number or date\/time value to a string of text.<\/td>\n<\/tr>\n
        TRIM<\/b><\/td>\nThe TRIM function removes all the spaces in the string except for the single space between the words.<\/a><\/td>\n<\/tr>\n
        UPPER<\/b><\/td>\nThe UPPER function converts all letters in the specified string to uppercase.<\/td>\n<\/tr>\n
        FIND<\/b><\/td>\nThe FIND function looks for a string within another string and is case-sensitive. FIND returns the starting position of the string that was found. It returns blank if the string in which you are searching doesn\u2019t contain the string for which you are searching.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        Operators in Formula Builder<\/h3>\n

        The following operators are available in the Formula Builder to configure a formula.<\/p>\n

          \n
        1. Plus (+<\/strong>): Adds two numbers together.<\/li>\n
        2. Minus (–<\/strong>): Subtracts the second value from the first value.<\/li>\n
        3. Divide (\/<\/strong>): Divides the first value by the second value.<\/li>\n
        4. Multiply (*<\/strong>): Multiplies two values.<\/li>\n
        5. Greater than (><\/strong>): Compares if the first value is greater than the second value.<\/li>\n
        6. Less than (<<\/strong>): Compares if the first value is less than the second value.<\/li>\n
        7. Greater than or equals to (>=<\/strong>): Compares if the first value is greater than or equal to the second value.<\/li>\n
        8. Less than or equals to (<=<\/strong>): Compares if the first value is less than or equal to the second value.<\/li>\n
        9. Equals to (==<\/strong>): Checks if the first value is equal to the second value.<\/li>\n
        10. Not equals to (!=<\/strong>): Checks if the first value is not equal to the second value.<\/li>\n
        11. AND: it returns true if both conditions are true.<\/li>\n
        12. OR: It returns true if at least one condition is true.<\/li>\n
        13. NOT: It negates the result of a condition.<\/li>\n
        14. Parenthesis (): Used for grouping expressions or operations to dictate the order of evaluation.<\/li>\n<\/ol>\n

          Formatters in Formula Builder<\/h3>\n

          The following formats are available in the Formula Builder to format a formula.<\/p>\n

            \n
          1. \\n<\/b>: It represents a newline character, used to format text or fields by indicating the start of a new line.<\/li>\n
          2. \\t<\/b>: <\/a>It represents a tab character, used to format text or fields by indicating horizontal spacing or indentation.<\/li>\n<\/ol>\n

            IF ELSE Conditions in Formula Builder<\/h3>\n

            The IF-ELSE condition helps you set a field’s value based on a condition you define for the formula. Here’s how it works:
            \nIF Section: Define a condition. If it’s true, the formula returns True and returns the value you specify here.
            \nELSE Section: If the condition is not true, the formula returns False and returns the value you specify in this section.
            \nMultiple Conditions: You can have multiple IF-ELSE conditions or nest them within an IF condition for more complex formulas.
            \nFor example, a company is giving discounts on its electronic products in different ranges as shown in the below table. So we can define such kind of condition using the If Else condition of the formula builder for a formula field.<\/p>\n\n\n\n\n\n
            Price<\/b><\/td>\nDiscount<\/b><\/td>\n<\/tr>\n
            <=5000<\/td>\n5%<\/td>\n<\/tr>\n
            \u00a0>= 5000<\/td>\n10%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

            Here the value in the Discount field is calculated automatically as per the value in the Price field and the conditions defined in the Discount field.
            \nTo define the condition for a field, perform the following steps –<\/p>\n

              \n
            1. Click on the field whose field type is defined as the Formula field.<\/li>\n
            2. Click the Settings <\/b>icon.<\/li>\n
            3. Click Configure Formula<\/b>.<\/li>\n
            4. From the left panel, on the Functions<\/b> tab, click Condition<\/b>.<\/li>\n
            5. Drag the IF THEN ELSE condition to the right pane.<\/li>\n
            6. To enter a function in the IF box, from the left plane, click the Functions <\/b>tab and drag the required function. You can also type @ and select the required function.<\/li>\n
            7. To enter a field in the IF box, from the left plane, click the Block Fields<\/b> tab, click the required Form and drag the required field. You can also type # and select the required field.<\/li>\n
            8. To enter an operator in the IF box, click the operator at the bottom of the screen. You can also type & and select the required operator.<\/li>\n
            9. To define a condition for the discount field according to the Price field, type # and select the Price field from the list.<\/li>\n
            10. Define the conditions as shown in the table.
              \n\"If<\/a><\/li>\n
            11. Click the Save<\/b> button.<\/li>\n<\/ol>\n

              Once you publish the form, the value of the Discount field is calculated automatically as per the value in the Price field. Similarly, you can define conditions including functions and operators in the IF box.<\/p>\n

              Defining a Formula Manually<\/h3>\n

              You can manually define a formula using the shortcuts\/ special characters to include the functions, form fields, and operators with the help of given symbols –<\/p>\n

                \n
              1. Use the @ symbol to include a function in a formula. As soon as you type or click the @, a list of functions appears. You can select the required function and define its parameters.<\/li>\n
              2. Use the # symbol to include a form field in a formula. As soon as you type #, a list of forms appears. Clicking a particular form shows the list of available fields in it. Click the field which you want to insert in your formula.<\/li>\n
              3. Use the & symbol to insert an operator in your formula. As soon as you enter the & symbol, it shows the categories of the operators, clicking a particular category shows all the operators in it. Click the operator that you want to select.<\/li>\n<\/ol>\n

                <\/a>Data Grid<\/h3>\n

                Forms 2.0 allows you to add a Data Grid<\/strong>, which allows you to organize data in a structured table format, with customizable grid and cell-level settings. Whether you’re building a student scorecard, an inventory list, a purchase order, or any structured data form, the Data Grid helps you efficiently input, display, and manage information. Each cell within the grid can hold unique data, and you can add various field types like text, number, selection, advanced, and common fields.<\/p>\n

                You can further customize the grid by merging or splitting cells, applying colors, adjusting alignments, and more. By right-clicking on any cell, you can access options such as Cell Settings, Merge Cells, and Split Cells, as well as Row Settings and Grid Settings. Also, you can find Grid Settings<\/strong> by selecting the Data Grid and clicking the gear icon.<\/p>\n

                \"Data<\/p>\n

                Grid Settings<\/h3>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
                Details<\/strong><\/td>\n<\/tr>\n
                No. of Columns<\/strong><\/td>\nSpecify the number of columns for the grid, allowing you to control the table\u2019s width.<\/td>\n<\/tr>\n
                No. of Rows<\/strong><\/td>\nSet the number of rows for your grid to control the table’s length.<\/td>\n<\/tr>\n
                Horizontal align<\/strong><\/td>\nChoose how the data in each cell is aligned horizontally.<\/td>\n<\/tr>\n
                Vertical align<\/strong><\/td>\nSelect how data is vertically positioned within cells.<\/td>\n<\/tr>\n
                Reposition field<\/strong>
                \n<\/b><\/td>\n                		Use this option to move the field between different blocks within the same tab or to a different tab.<\/td>\n<\/tr>\n
                Style<\/strong><\/td>\n<\/tr>\n
                Border width<\/strong><\/td>\nDefine the thickness of the borders around cells, allowing for more visual clarity or subtlety.<\/td>\n<\/tr>\n
                Border style<\/strong><\/td>\nTo customize the grid’s look, you can choose from various border styles, such as solid, dotted, double, or outset.<\/td>\n<\/tr>\n
                Border color<\/strong><\/td>\nSet the color of the cell borders to match the design of your form.<\/td>\n<\/tr>\n
                Background color<\/strong><\/td>\nCustomize the background color of individual cells to highlight specific data or simply enhance the table’s appearance.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                \"Data<\/p>\n

                Once the table is added, drag and drop various field types into the cells based on your requirements, such as text, number, selection, advanced, lookup, and common fields. This allows you to design your grid\/table exactly the way you need to manage and present data efficiently. Please note that once fields are added to the data grid cells, certain settings for those fields will be disabled.<\/p>\n

                Right-clicking on a cell provides various cell and row options:<\/p>\n