Free Text Column Technical Reference

Summary

  • The FreeTextColumnAPI provides run time access to the Free Text Column Module
  • It can be used to update Free Text Columns with new values programmatically

Free Text Column State

The Free Text Column State contains a collection of FreeTextColumn objects:

PropertyTypeDescription
FreeTextColumnsFreeTextColumn[]Collection of Free Text Columns

Free Text Column

A FreeTextColumn FreeTextColumn object is defined as follows:

PropertyTypeDescriptionDefault
ColumnIdstringId of Column
DefaultValueanyInitial value to use for each cell in the Column
FreeTextColumnSettingsFreeTextColumnSettingsAdditional optional properties for Column (e.g. filterable, resizable)
FreeTextStoredValuesFreeTextStoredValue[]Collection of Stored Values to aplly in the Column
FriendlyNamestringFriendly Name to use to refer to Column; if unset ColumnId is used
TextEditor'Inline' | 'Large'Cell editor to use when editing a string Free Text Column'Inline'
IsReadOnlybooleanSets Entity to ReadOnly (overwriting a Strategy Entitlement of 'Full')

Free Text Stored Value

The FreeTextColumn object includes an array of FreeTextStoredValue defined as follows:

PropertyTypeDescription
FreeTextanyValue to store in the cell
PrimaryKeyanyPrimary Key Column value for the row

Hint

Free Text Stored Values will typically be added by users at run-time, rather than set at design-time

Free Text Column Settings

The freeTextColumnSettings property is of type FreeTextColumnSettings which is defined as follows:

PropertyTypeDescriptionDefault
AggregatablebooleanWhether Column can be used in an aggregation when groupingfalse
ColumnTypesstring[]Custom column types added to AG Grid Column Types when object is created
DataTypeAdaptableColumnDataTypeExpression's return value DataType, only mandatory property
FilterablebooleanWhether Column is filterablefalse
GroupablebooleanWhether Column can be groupedfalse
HeaderToolTipstringTooltip to show in the Column Header (not cells)
PivotablebooleanWhether Column can be used when grid is in pivot modefalse
ResizablebooleanWhether Column can be resized (by dragging column header edges)false
SortablebooleanWhether Column is sortablefalse
SuppressMenubooleanWhether if no menu should be shown for this Column header.false
SuppressMovablebooleanWhether if this Column should be movable via draggingfalse
WidthnumberPreferred (pixel) Column Width; if unset, calculated dynamically by AG Grid

Free Text Column API

Full programmatic access to Free Text Columns is available in Free Text Column API.

This enables Free Text Columns to be created, edited, cloned, deleted and shared programmatically.

MethodReturnsDescription
addFreeTextColumn(freeTextColumn)FreeTextColumnAdds new FreeTextColumn to Adaptable State
deleteFreeTextColumn(columnId)voidDeletes FreeTextColumn with given ColumnId from Adaptable State
editFreeTextColumn(freeTextColumn)FreeTextColumnEdits existing FreeTextColumn in Adaptable State
getFreeTextColumnById(id)FreeTextColumn | undefinedRetrieves FreeTextColumn by the technical ID (from FreeTextColumnState)
getFreeTextColumnForColumnId(columnId)FreeTextColumn | undefinedGets FreeText Column, if any, for given ColumnId
getFreeTextColumns()FreeTextColumn[]Gets all FreeTextColumns in Adaptable State
getFreeTextColumnState()FreeTextColumnStateRetrieves FreeTextColumn section of Adaptable State
getFreeTextColumnValueForRowNode(freeTextColumn, rowNode)anyRetrieves a Free Text Column value for a given row node
openFreeTextColumnSettingsPanel()voidOpens Settings Panel with Free Text Column section selected and visible
setStoredValue(columnId, storedValue)FreeTextColumnSets FreeTextStoredValue for the FreeTextColumn with the given ColumnId (replaces existing one if exists)
setStoredValues(columnId, storedValues, replaceAction)voidSets Stored Values to the FreeTextColumn with the given ColumnId