Configuring Free Text Columns

Summary

Free Text Columns can be defined at design-time using Free Text Column Initial State
The Free Text Column API can be used to add values programatically at run-time

Defining Free Text Columns

Free Text Columns can be defined in Free Text Column Initial Adaptable State.

Each FreeTextColumn object contains 2 useful properties that can be provided if required:

FreeTextStoredValues - allows the Free Text Column to be 'pre-populated' with relevant data
DefaultValue - enables each cell to display a default value unless explicitly overridden by the User

Developer Guide

Defining a Free Text Column

There are (up to) 6 properties that you need to provide:

// Provide 3 Free Text Columns
// 1. Comments - string column with 3 initial values
// 2. OrderCode - numeric column with default of 123
// 3. LastSpoken - a date Column
const initialState: InitialState = {
  FreeTextColumn: {
    FreeTextColumns: [
      {
        ColumnId: 'Comments',
        FreeTextStoredValues: [
          { PrimaryKey: 12, FreeText: 'Dispatch asap' },
          { PrimaryKey: 15, FreeText: 'Angry client' },
          { PrimaryKey: 21, FreeText: 'Big order' },
        ], 
        FreeTextColumnSettings: {
          DataType: 'text',
          Aggregatable: false,
        },
      },
      {
        ColumnId: 'OrderCode',
        FriendlyName: 'Order Code',
        DefaultValue: 123, 
        FreeTextColumnSettings: {
          DataType: 'number',
          Sortable: false,
          SuppressMenu: true,
        },
      },
      {
        ColumnId: 'LastSpoken',
        FriendlyName: 'Last Spoken',
        FreeTextColumnSettings: {
          DataType: 'date',
          Filterable: true,
        },
      },
    ],
  },
}

Id for the Free Text Column

This value is used to refer to the Column in State

Column Name (if the Id property is not suitable)

This value is used to refer to the Column in AdapTable UI

DataType for the Column

Whether the Column is Text Number Date or Boolean

Is only mandatory property in FreeTextColumnSettings

AdapTable provides an appropriate Cell Editor based on the DataType provided here

Default Value (Optional)

Used in each cell unless explicitly overridden by the User

Initial Stored Values (Optional)

Initial values to show in the column.

Each is keyed against the Primary Key value for the Row.

Other Column Settings (Optional

Provide additional settings for the Column (e.g. filterable, pivotable, resizable, sortable etc.)

Hint

To prevent filtering on Free Text Columns, set enableFilterOnSpecialColumns to false in Column Filter Options
This will also disallow filtering on all Calculated Columns and Action Columns

Adding Values Programmatically

A commonly used function in Free Text Column API is setStoredValues which allows you to update values stored in Free Text Columns programmatically.

setStoredValues

columnId: string, values: FreeTextStoredValue[], action: 'All' | 'Conflicting' | 'None'

void

Adds Stored Values to a FreeText Column

This is a useful function that allows you to add values to a FreeText Column programmatcally.

The definition is:

  setStoredValues(
    columnId: string,
    storedValues: FreeTextStoredValue[],
    replaceAction: 'All' | 'Conflicting' | 'None'
  ): void;

The replaceAction parameter defines the rules for how the new Stored Values should interact with any existing (and potentially clashing) cell values in the Column.

The property can be one of 3 values with the following behaviour for each:

All - replaces all existing Stored Values for the Column with the new ones even if provided cells are currently empty
Conflicting - adds all given stored values and replaces any existing ones which clash with the new set
None - only adds the stored values where there are no existing entries with the same primary key

// Replace all Existing Free Text Values in the Column with the 2 provided:
const values: FreeTextStoredValue[] = [
    { PrimaryKey: 5, FreeText: 'Fifth' },
    { PrimaryKey: 6, FreeText: 'Sixth' }
  ];
  api.freeTextColumnApi.setStoredValues('Comments', values, 'All');

Restricting FreeText Column Data Entry

(Recorded with AdapTable v16.0)

AG Grid Column Definitions

Typically Custom Columns are not defined in AG Grid Options.

Instead they are provided via Adaptable Options or Initial Adaptable State as appropriate.

However sometimes it is required to define the Column in AG Grid - e.g. if you want to show an AG Grid tooltip on the cell value.

This is possible by specifying a Column Type of freeTextColumn in the AG Grid Column Definition.

Hint

Make sure ColId in the Column Definition and ColumnId in the Custom Column definition are the same value

Find Out More

See Adding Special Column Types for more details and a demo

PreviousFree Text Columns NextTechnical Reference

Framework: