All Custom Functions List (part 2)

This article is now deprecated. For a detailed list of Custom Functions refer to this article here.

GETKEYVALUE

When you need to get only the value from a specific key typically where key-value pairs are returned, you can use the GETKEYVALUE function.

Definition

GETKEYVALUE(object, “keyname”)

Where,

  • object: is the JSON object from where the value is to be fetched.
  • Keyname: is the default key name or label of the JSON object.

Example

GETKEYVALUE( STRINGTOJSON( LOOKUP([Prod_depend_Doc.json_object] , Prod_depend_Doc.unique_id = 1)) , “name”)

returns the value in the “name” key i.e. John in this case.

For More Info on using the funtion - Refer the article here.


ARRAYTOCSV

The ARRAYTOCSV function converts your array data into comma-separated values in the form of String.

Definition

ARRAYTOCSV(ArrayValue)

Where,

  • ArrayValue is an array input.

Example

ARRAYTOCSV(array[“a”,“b”,“c”] )

Will result into: a,b,c

For More Info on using the funtion - Refer the article here.


SHOWDETAILS

This is used to show the details from the selected row of the TableGrid control. It displays the selected data from TableGrid in Detail View control. The value returned by the function is a JSON array with the dynamic keys provided in the function.

Definition

SHOWDETAILS(“newkey1”, tablegrid.columnname1,”newkey2”, tablegrid.columnname2)

Where,

  • Newkey<1>: is the new label assigned to the respective key
  • tablegrid.columnname<1>: is the specific column from the tablegrid control.

Here you can also change the order in which the keys appear. So the records will be displayed in the order in which you added the new keys.

Example

SHOWDETAILS(“name”, tableGrid.name, “id”, tableGrid.id)

For More Info on using the funtion - Refer the article here.