In Fullcast, data formatting enhances grid readability by customizing how data is displayed without changing the data. Each field’s data type (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 (filtering numeric data with currency formatting still uses the actual numerical value).
Numeric data types
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:
Format Type | Example |
|---|---|
FixedPoint | 1 |
Decimal | 1.2345 |
Percent | 15% |
Currency | $34 |
largeNumber
A largeNumber represents a value considerably larger than a reference point and can be formatted in the following ways:
Format Type | Example |
|---|---|
Exponential | 1.0E+9 |
Thousands | 1,000,000K |
Millions | 1,000M |
Billions | 1B |
Trillions | 0T |
largeNumber | 1B (uses thousands, millions, billions, or trillions depending on the value). |
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 and shortDateAndTime
Format Type | Example |
|---|---|
shortDate | 7/15/2024 |
shortTime | 8:45 PM |
shortDateAndTime | 7.15.2024, 8:45 PM |
longDate and longDateAndTime
Long date is a format that displays values in a more detailed format.
Format Type | Example |
|---|---|
longDate | Thursday, July 1, 2024 |
longTime | 8:45:30 PM |
longDateAndTime | Thursday, July 1, 2024 8:45:30 PM |
String Data Types
String data types, while offering limited formatting options, allow you to format text hyperlinks. Use a special URL(prefix) format to define hyperlinks with the grid.
Prefix: This is the base URL of the target systems (your Salesforce instance).
{value}: A placeholder that will be replaced with the actual value from the grid cell.
For example, URL(https://your-salesforce-instance.com/{value}