The Localization data type is designed specifically for translation workflows. Use this to designate columns as source or target languages.

1. Select Localization from the data type dropdown.
2. Under Localization type, select Source language or Target language. 
3. Click Save.

Formula columns enable powerful calculations and data manipulation using expressions that combine column values, numbers, strings, and built-in functions. Formulas automatically update when referenced data changes, making them perfect for dynamic calculations and automated content generation.

1. Select Formula from the data type dropdown.
2. Configure these settings:
   • Insert formula: Gridly provides over 80 built-in functions for mathematical operations, string manipulation, date/time handling, logical comparisons, and more. See the complete formula reference.
   • Formula value format: Select whether the returned value from the formula is an array or a single value, Gridly will format the value accordingly.
3. Click Save.

Reference columns create connections to data in other Grids, allowing you to display information from external sources. When the original data updates, all references automatically reflect the changes.

1. Select Reference from the data type dropdown.
2. Refer to this guide to configure the column and learn how it works: Reference Column.
3. Click Save.

• Multiple lines: Ideal for longer text content that may span multiple lines, such as descriptions, notes, or paragraphs.
• Single line: Use for short text entries that don't require line breaks, such as titles, names, or brief descriptions.
• Rich text: Provides full text formatting capabilities including bold, italic, links, and other rich formatting options. Perfect for content that needs visual emphasis or structure.
• Markdown: Supports Markdown syntax for technical documentation or formatted text.

Select this data type to be able to add files to a column (i.e. images, video, or audio files).  You can add a file by drag-and-drop directly to a cell from your computer. 

Audio and video files can be played in the user interface of Gridly. All common types of multimedia files are supported and a built-in player is available for play control.

Restricts input to numeric values only, preventing non-numeric characters from being entered. Useful for quantities, prices, scores, or any numerical data.

Creates a dropdown menu where users can select one option from a predefined list.

1. Select Single selection from the data type dropdown.
2. Click + Add Option to create your first choice.
3. Enter the option text and choose a color for visual distinction.
4. Add additional options by pressing Enter or clicking + Add Option.
5. Click Save when finished.

Creates a dropdown menu where users can select multiple options from a predefined list.

1. Select Single selection from the data type dropdown.
2. Click + Add Option to create your first choice.
3. Enter the option text and choose a color for visual distinction.
4. Add additional options by pressing Enter or clicking + Add Option.
5. Click Save when finished.

Provides date and time picker controls for scheduling, timestamps, or any time-sensitive data.

Creates a true/false toggle, perfect for yes/no questions, logic flags, or binary states.