---
title: "Field data types and formatting options in Fullcast"
slug: "field-data-types-and-formatting-options-in-fullcast"
description: "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. "
tags: ["IT", "Advanced", "Grid", "Managers", "Revenue Strategy", "Formatting", "Hyperlinks", "Integer", "Date", "Revenue Operations", "String", "Numeric", "Data Hygiene", "URL"]
updated: 2026-01-14T17:06:52Z
published: 2026-01-14T17:06:52Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://support.fullcast.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Field 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 (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](/v1/docs/format-a-field-as-a-hyperlink-in-the-data-grid). 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}`