Data Types and Formatting Options in Fullcast

In Fullcast, data formatting enhances grid readability by customizing how data is displayed without changing the data. Each field’s data type (e.g., numeric, date, string, integer) defines its formatting options. For instance, numeric fields can be formatted as currency, while dates can be short or long.

Impact on Filtering

Effective formatting improves filtering capabilities. Filters operate based on underlying data type, ensuring accurate results even with formatted displays (e.g., filtering numeric data with currency formatting still uses the actual numerical value).

Numeric Data Type

Numeric data types represent numerical values and often require formatting to enhance readability and provide context within your Fullcast grids. When your data type is decimal or integer, your format options become a mixture of smallNumbers and largeNumbers.

smallNumber

A smallNumber is a value considered significantly smaller than a reference point and can be formatted in the following ways:

largeNumber

A largeNumber represents a value considerably larger than a reference point and can be formatted in the following ways:

Date Data Type

Date data types provide options for displaying dates in various formats. When this data type is selected, the format options within Fullcast are:

• shortDate

• shortDateAndTime

• longDate

• longDateAndTime

shortDate/shortDateAndTime

longDate/longDateAndTime

Long date is a format that displays values in a more detailed format.

String Data Types

String data types, while offering limited formatting options, allow you to format text as clickable URLs. We’ll use a special URL(prefix) format to define hyperlinks with your grid.

• Prefix: This is the base URL of the target systems (e.g., your Salesforce instance).

• {value}: A placeholder that will be replaced with the actual value from the grid cell.

Exaple:

“URL(https://your-salesforce-instance.com/{value}”

Implementation with DevExterme Grid

We’ll use the DevExtreme Grid to implement this solution. Here is a step-by-step breakdown:

1. Define the hyperlink format:

   1. Specify the URL(prefix) format for the desired column in your grid configuration.

Example

To link to a Salesforce record based on its ID, you might use: “Format”: “URL(https://your-salesforce-instance.com/{value}”

2. Customize the grid’s behavior:

   1. Use the CustomText function to process the format string and field value.

   2. Extract the field value from the grid data.

   3. Replace the {value} placeholder in the prefix with the actual field value.

   4. Convert the resulting URL into a clickable hyperlink.

Benefits

• Flexibility: You can link to various external systems, not just Salesforce.

• Improved user experience: Users can directly navigate to related records with a single click.

By following these steps, you can significantly enhance your grid’s functionality. This will save your users time and effort, making their work more efficient. Remember to tailor the specific implementation to your application’s requirements and the capabilities of your chosen grid library.

Configure Hyperlinks

1. Navigate to Settings > Entities & Fields and choose the data type you want to link, such as “Accounts.”

2. Edit the specified field you want to use for the hyperlink, often the record’s unique identifier (i.e., “ID”).

3. In the “Basic Information” tab, locate the “Format Text Box”  option.

4. Enter the following URL format: URL”https://your-salesforce-instance.com/{value}”

Information:

This format creates a hyperlink based on the field value “{value}.”

5. Save changes.

Using the Hyperlink

• In the “Segments” grid, the chosen field (e.g., “ID”) will display as a clickable hyperlink.

• Clicking on this hyperlink will automatically open the corresponding record page in your Salesforce organization, assuming you are logged in.

Information:

If you are logged out of Salesforce when you click the hyperlink, you will be redirected to the Salesforce login page first. After logging in, you will then be directed to the specific record page.