Free cookie consent management tool by TermsFeed

GridPlus

On This Page
The capabilities described on this page are included in Appian's advanced and premium capability tiers. Usage limits may apply.

This page describes GridPlus, which is an Advanced Plug-in developed, managed, and maintained by Appian.

What is GridPlus?

GridPlus is an advanced grid component designed to facilitate efficient, high-volume data entry and interaction directly within the Appian data fabric. GridPlus integrates spreadsheet-like capabilities, providing an intuitive and highly customizable user experience. It streamlines the interaction with structured data, simplifying complex tasks such as bulk editing, data validation, and dynamic sorting, all while maintaining robust security and enterprise-level stability. End users can quickly edit individual cells or make bulk changes using multi-cell selection, and can execute related actions on their selected data. Theming and styling options are also included, enabling users to customize the component's appearance to match their organization's branding.

Scroll or drag to pan · ⌘+/⌘− to zoom · Esc to closeGrid Plus light mode

Note:  Users of the deprecated AppMarket GridPlus plug-in can find instructions for migrating to the new version here.

Features

Data Interaction and Management:

  • Supports extensive data types including text, numeric, checkbox, currency, date, links, percentages, and dropdowns.
  • Spreadsheet-like capabilities, enabling drag-and-drop operations and direct data paste from external sources.
  • Embedded record and related action functionalities enabling traditional form-based editing within the grid interface.
  • Advanced validation for real-time data integrity and format compliance.
  • Multiselect editing, keyboard navigation, copy-paste functionality, and context menus for efficient data management.

Customization and Usability:

  • Dynamic sorting, column resizing, and rearrangement capabilities with minimal configuration.
  • Enhanced record link support, allowing seamless navigation to related site pages.
  • Extensive configurability options for data presentation, including customizable dark and light modes, adjustable accent, validation, and background colors, and styling preferences.
  • Automatic localization, dynamically adjusting language settings according to the locale configured in Appian's internationalization settings. Supported locales are listed below.
  • Export capability, enabling users to easily download the current page of data as a CSV file.

Security and Scalability:

  • Comprehensive security based on your record type configurations of record-level, field-level, and column-level permissions.
  • Granular control over end-user access to edit, delete, create, and trigger record or related actions.
  • Robust pagination capabilities optimized for high-volume data sets.

Scroll or drag to pan · ⌘+/⌘− to zoom · Esc to closeGrid Plus dark mode

GridPlus allows you to provide enhanced functionality for your users. Use GridPlus if you want your users to be able to:

Import and display data from a spreadsheet:

  • Copy and paste spreadsheet data and display it in GridPlus.
  • Validate entries based on custom validation criteria for each column.
  • Edit imported data with Excel-like abilities.

Customize the display of large data sets:

  • Configure column-level data types to specify cell formatting, manipulation, and validation.
  • Drag and drop, resize, hide, sort, or freeze columns to adjust data display.
  • Configurable pagination setup.

Bulk create and delete record data:

  • Create new records directly from the component.
    • Enter new data by selecting the Create New Entries button in the Grid component. This will display an empty editable grid where new entries can be created.
  • Delete records from data fabric by selecting rows and using 'Remove rows' in the context menu.
  • Select a range of cells to manipulate.
    • Drag and drop range selection.
    • Keyboard shortcuts.
  • Modify selected cells.
    • Empty by pressing the delete key.
    • Fill with values by the 'paste' keyboard shortcut.
    • Drag values from other cells by their bottom right cell corner.

Scroll or drag to pan · ⌘+/⌘− to zoom · Esc to closeGrid Plus editable

Installation

Appian Cloud customers: Appian Cloud customers on the advanced and premium capability tiers can download this plug-in directly from the Plug-ins section of the Admin Console.

Self-managed customers: Self-managed customers on the advanced and premium capability tiers can download this from the Downloads section of MyAppian.

gridPlusLayoutField component

Setup notes

To display record data within the GridPlus, you must configure an expression rule using a!queryRecordType and a column configuration object for each field you intend to display. Refer to the sections below for detailed instructions on defining column configuration objects within the columnConfigs parameter and an expression query within the queryRuleName parameter.

To set up the end user's permissions, configure enableEdit, enableCreate, and enableDelete parameters. These parameters control what UI elements the end user is able to interact with.

Next, configure local variables to capture user changes. By default, local!creates, local!edits, and local!deletions should be set to empty arrays ({}), then wired into createDataValue/editDataValue/deleteDataValue and their corresponding saveInto parameters. To load the grid with preset changes prior to user interaction, the local variables can be set to arrays of objects corresponding to record field names (for example, local!edits: { id: 2, completed: "false" })

Finally, configure createModel, editModel, deleteModel within the gridsubmitchanges() function to allow the user to trigger process models to capture their record data edits when they click Submit.

  • The queryRuleName parameter must be set up with an a!queryRecordType() function and with the following requirements:
    • Fields should explicitly match the fields configured in the columnConfigs parameter.
    • Set the fetchTotalCount parameter to true.
    • Do not have extra commas within the rule.
  • The component expects the base record type to contain at least one row that the end user has access to. If the query returns no data—because the record type is empty or the current user can't see any rows—the component will throw an error.
  • Every grid function must have each parameter configured in the exact order that they are written in the expression editor description. Mark any unused or unnecessary parameters explicitly as null.
  • Each process model (createModel, editModel, deleteModel) configured within gridsubmitchanges() must have a process variable that:
    • is named record.
    • Multiple?: Variable can store multiple values set to true.
    • Parameter: Allow the value for the variable to be provided when starting a process set to true.
  • The enableEdit, enableCreate, enableDelete, and readOnly parameters only control the user's interactions with editing within the grid itself. These parameters do not control creating data through record actions (set up in the component's recordActions parameter) or editing data through related actions (set up through a linkConfig parameter of either gridtextcolconfig() or gridnumericcolconfig()).
  • Assign createModel, editModel, deleteModel only to users who may run them. UI flags (enableCreate, enableEdit, enableDelete, disableSubmitChanges, disablePendingChanges) merely hide features—they don't enforce security. Configure both the sets of parameters depending on your use case and explicitly pass null where access is denied.
  • Make sure to configure activity chaining across all nodes in createModel, editModel, deleteModel.
  • The gridsubmitchanges() function should only be configured within the submitChangesSaveInto component parameter and should never be configured as a local variable or a rule input.
  • Custom record fields should always be configured with the readOnly parameter set to true in their column configuration function.

Parameters

Parameter Type Description
queryRuleName Text Required. The name of the expression rule that uses the a!queryRecordType() function to query a record type, provided either as a rule reference (without parentheses) or as a string (for example, rule!GA_queryRule or "GA_queryRule"). This rule must explicitly define all values without relying on local variables. It runs during the initial load to fetch data and re-executes whenever users interact with the grid, such as paginating, sorting, or filtering. To ensure the grid works properly, each field in the query must match its corresponding field in columnConfig, and fetchTotalCount must be set to true.
columnConfigs List of Variant List of column configuration functions which define the order and formatting of each column in the grid. This parameter takes: gridcheckboxcolconfig(), griddatecolconfig(), griddropdowncolconfig(), gridnumericcolconfig(), and gridtextcolconfig().

The parameters of each type vary slightly. Make sure to configure each function in the exact order that they are written in the expression editor description and to mark any unused or unnecessary parameters explicitly as null. The parameters of each type vary slightly. See below for further configuration options. Each type has a parameter for a custom validator. It is crucial to define a column config for all primary keys, which can be optionally hidden using the hiddenFields parameter.

Tip: Define the column configurations in a separate Appian expression rule and reference it here.
queryRuleInputs Dictionary Create rule inputs within the queryRule object and set queryRuleInputs with a map of rule input keys and their corresponding values. If configured, queryRule will be executed with rule inputs when the component loads. Only primitive types and record fields (gridrecordfield(>recordField<)) are supported; nested objects, arrays, and other input types are not. Avoid using the key filters, which is reserved for handling end-user interactions with the column filters UI.
hiddenFields Map List of fields to hide on grid render. This value can be set by utilizing the gridrecordfield() function.
readOnly Boolean Set the grid as read-only (true) or editable (false). Defaults to false if null.

Providing true for this parameter will disable create, edit, and delete operations in the grid, overriding the enableCreate, enableEdit and enableDelete parameter values. This value will not override any related actions configured in column configs or record actions configured in the recordActions component parameter.
enableCreate Boolean Enables the New Entries button for adding new records in the grid. To activate this functionality, ensure that createModel is properly configured within the gridsubmitchanges() function, which must be called inside the submitChangesSaveInto parameter. This configuration determines the create process model that is triggered when the user clicks the Submit Changes button. Note: this parameter does not control record actions—record actions may be enabled/disabled explicitly with the recordActions parameter.
enableEdit Boolean Enables editing records in the grid. To activate this functionality, ensure that editModel is properly configured within the gridsubmitchanges() function, which must be called inside the submitChangesSaveInto parameter. This configuration determines the edit process model that is triggered when the user clicks the Submit Changes button. Note: this parameter does not control related actions—related actions may be configured through the linkConfig parameter of a column configuration function.
enableDelete Boolean Enables deleting records in the grid. To activate this functionality, ensure that deleteModel is properly configured within the gridsubmitchanges() function, which must be called inside the submitChangesSaveInto parameter. This configuration determines the delete process model that is triggered when the user clicks the "Submit Changes" button. Note: this parameter does not control related actions—related actions may be configured through the linkConfig parameter of a column configuration function.
disableSubmitChanges Boolean Provide true to hide the SUBMIT CHANGES button.
disablePendingChanges Boolean Provide true to hide the Pending Changes button.
createDataValue / createDataSaveInto Any Type Object to track newly created records added in the grid. When a user clicks the SUBMIT CHANGES button, the component submitChangesSaveInto parameter will trigger the gridsubmitchanges() function and trigger the creationModel process model.
editDataValue / editDataSaveInto Any Type Object to track edited records in the grid. When a user clicks SUBMIT CHANGES, the component submitChangesSaveInto parameter will trigger the gridsubmitchanges() function and trigger the editModel process model.
deleteDataSaveInto / deleteDataValue Any Type Object to track deleted records in the grid. When a user clicks SUBMIT CHANGES, the component submitChangesSaveInto parameter will trigger the gridsubmitchanges() function and trigger the deleteModel process model.
submitChangesValue / submitChangesSaveInto Any Type Executes when the user clicks SUBMIT CHANGES. Set submitChangesValue to a local variable to capture the resulting process model initiation data. Set submitChangedSaveInto to a!save where the target is the local variable configured in submitChangesValue and the value is the gridsubmitchanges() function.
recordActions Any Type A list of record actions, defined using the gridrecordactionconfig() function which displays record action buttons at the top of the grid component. Please refer to the Auxiliary Configuration Functions section for more details about the gridrecordactionconfig() function.
rowHeaders Boolean Boolean value to determine whether to display the record's ID as the label for each row in the grid. Default to true.
rowHeight Text Provide an integer value (in pixels) to apply a fixed height to all rows in the grid. Provide AUTO to size row heights automatically to fit their content, which enables text wrapping in cells but affects performance on large datasets. Defaults to 40px.
style Any Type Provide a gridStyling() function to set the style of your grid's theme, accent color, validation color, button shape, background color, and embedded interface theme.
onSelection List of Save As the end user selects cells, rows, columns, or combinations of the same, this variable will update with the items selected. Note: configuring this field may impact grid performance if the end user is selecting large amounts of data.
exportConfig Any Type Configuration object to determine export settings. Clicking EXPORT PAGE will export the current page of the grid, including any in-progress modifications. This value can be set using the gridexportconfig() function. Export behavior will be hidden if not set.

Column configuration functions

Each field queried must be defined by a column configuration function. This function determines how data is displayed, edited, and validated. It also determines behavior when sorting or filtering on each column.

Refer to the column configuration example to see all of these functions in one expression.

Note:  All of the column configuration functions detailed below include a recordField property. To ensure that column values are accurately displayed on the Grid, utilize the gridrecordfield() function. This function also handles related record fields.

gridtextcolconfig()

Text column configuration function. Every grid function must have all parameters configured in the exact order that they are written in the expression editor description. Mark any unused or unnecessary parameters explicitly as null.

For easy set-up, copy and paste the following expression:

1
2
3
4
5
6
7
8
9
10
11
12
gridtextcolconfig(
  recordField: gridrecordfield(
    recordField: <recordField>
  ),
  linkConfig: null,
  title: null,
  validator: null,
  readOnly: null,
  colWidth: null,
  horizontalAlign: null,
  verticalAlign: null
)
Parameter Type Description
recordField Text Specifies the record field associated with this column configuration, configured by passing the record field into gridrecordfield().
linkConfig Text Defines a link to a record view. Links can be configured with gridrecordlinkconfig() to link to a record view or Tempo page or to gridrelatedactionconfig() to show an embedded related action form.
title Text Column header title. Defaults to field name if null.
validator Text Custom validator logic using the gridvalidator() function. Defaults to generic text validator if null.
readOnly Boolean Whether data in the column is read-only or editable. Defaults to false if null.
colWidth Text Initial width of the column on load. Valid values include AUTO, null, or an integer between 10 and 600. Defaults to AUTO if null.
horizontalAlign Text Determines the horizontal alignment of the grid column. Valid values: "LEFT", "CENTER", "RIGHT", "JUSTIFY". Default: "LEFT".
verticalAlign Text Determines the vertical alignment of the grid column. Valid values: "TOP", "MIDDLE", "BOTTOM". Default: "TOP".

Example:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
gridtextcolconfig(
  recordField: gridrecordfield(
    recordField: <recordField>
  ),
  linkConfig: gridrelatedactionconfig(
    recordPrimaryKeyField: gridrecordfield( <record primary key field>),
    relatedActionModel: cons!RE_CREATE_OR_UPDATE_ORDER,
  ),
  title: "ID",
  validator: null,
  readOnly: true,
  colWidth: 100,
  horizontalAlign: "CENTER",
  verticalAlign: "TOP"
)

gridnumericcolconfig()

Numeric column configuration function. Every grid function must have all parameters configured in the exact order that they are written in the expression editor description. Mark any unused or unnecessary parameters explicitly as null.

Note:  Values that exceed Appian’s maximum or minimum integer range are stored as a string in the local variable prior to submission. For large numeric inputs, ensure the target record field is Number (Decimal Precise). If a user enters a value outside the supported integer range for a field of type Number (Integer) and submits, the stored value will be clamped to the nearest integer limit (max or min).

For easy set-up, copy and paste the following expression:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
gridnumericcolconfig(
  recordField: gridrecordfield(
    recordField: <recordField>
  ),
  linkConfig: null,
  format: null,
  title: null,
  validator: null,
  readOnly: null,
  colWidth: null,
  culture: null,
  horizontalAlign: null,
  verticalAlign: null
)
Parameter Type Description
recordField Text Specifies the record field associated with this column configuration, configured by passing the record field into gridrecordfield().
linkConfig Text Defines a link to a record view. Links can be configured with gridrecordlinkconfig() to link to a record view or TEMPO page or to gridrelatedactionconfig() to show an embedded related action form.
format Text Configures format of data in each cell. Example options include "$0,0.00", "$ 0,0.00", "0,0.00$", "0,0.00 $", "$0.00", "0,0", "0,0.00", "0.0%", "0.00%", "0.00" for currency, large numbers, percentages, and decimals, respectively. Find the full list here: https://numbrojs.com/old-format.html. Defaults to no formatting if null. Note that format is not applied when the linkConfig parameter is configured.
title Text Column header title. Defaults to field name if null.
validator Text Custom validator logic using the gridvalidator() function. Defaults to generic text validator if null.
readOnly Boolean Whether data in the column is read-only (true) or editable (false). Defaults to false if null.
colWidth Text Initial width of the column on load. Valid values include AUTO, null, or an integer between 10 and 600. Defaults to AUTO if null.
culture Text Sets how currency is shown based on region. Valid options include "ar-AR", "zh-CN", "nl-NL", "en-US", "fr-FR", "de-DE", "it-IT", "ja-JP", "ko-KR", "pl-PL", "pt-BR", "ru-RU", "es-MX". For example, "en-US" shows $1,000.00. Note that this parameter is compatible only when format is set to a format found here: https://numbrojs.com/old-format.html.
horizontalAlign Text Determines the horizontal alignment of the grid column. Valid values: "LEFT", "CENTER", "RIGHT", "JUSTIFY". Default: "LEFT".
verticalAlign Text Determines the vertical alignment of the grid column. Valid values: "TOP", "MIDDLE", "BOTTOM". Default: "TOP".

Example:

1
2
3
4
5
6
7
8
9
10
11
12
gridnumericcolconfig(
  recordField: gridrecordfield(
    recordField: <recordField>
  ),
  linkConfig: null,
  format: "$0,0.00",
  title: "Production Cost",
  validator: null,
  readOnly: false,
  colWidth: null,
  culture: "en-US"
)

griddatecolconfig()

Displays record data of type Date and allows users to edit each value using a date picker. Every grid function must have all parameters configured in the exact order that they are written in the expression editor description. Mark any unused or unnecessary parameters explicitly as null.

For easy set-up, copy and paste the following expression:

1
2
3
4
5
6
7
8
9
10
11
12
13
griddatecolconfig(
  recordField: gridrecordfield(
    recordField: <recordField>
  ),
  dateFormat: null,
  correctFormat: null,
  title: null,
  validator: null,
  readOnly: null,
  colWidth: null,
  horizontalAlign: null,
  verticalAlign: null
)
Parameter Type Description
recordField Text Specifies the record field associated with this column configuration, configured by passing the record field into gridrecordfield().
dateFormat Text Date display format for each cell. This format should match the underlying date data. Examples of valid options include "MM-DD-YYYY", "MM/DD/YYYY", "MM/DD/YY", "DD-MM-YYYY", "DD/MM/YYYY", "DD/MM/YY", "DD-MM-YY", "YYYY/MM/DD", "YYYY-MM-DD", "YYYY/DD/MM", "YYYY-DD-MM". Defaults to "MM-DD-YYYY" if set to null.
correctFormat Boolean Deprecated parameter; set to null.
title Text Column header title. Defaults to field name if null.
validator Text Custom validator logic using the gridvalidator() function. Defaults to generic text validator if null.
readOnly Boolean Whether data in the column is read-only (true) or editable (false). Defaults to false if null.
colWidth Text Initial width of the column on load. Valid values include AUTO, null, or an integer between 10 and 600. Defaults to AUTO if null.
horizontalAlign Text Determines the horizontal alignment of the grid column. Valid values: "LEFT", "CENTER", "RIGHT", "JUSTIFY". Default: "LEFT".
verticalAlign Text Determines the vertical alignment of the grid column. Valid values: "TOP", "MIDDLE", "BOTTOM". Default: "TOP".

Example:

1
2
3
4
5
6
7
8
9
10
11
griddatecolconfig(
  recordField: gridrecordfield(
    recordField: <recordField>
  ),
  dateFormat: "YYYY-MM-DD",
  correctFormat: null,
  title: "DOB",
  validator: null,
  readOnly: null,
  colWidth: null
)

gridcheckboxcolconfig()

Checkbox column configuration function. Every grid function must have all parameters configured in the exact order that they are written in the expression editor description. Mark any unused or unnecessary parameters explicitly as null.

For easy set-up, copy and paste the following expression:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
gridcheckboxcolconfig(
  recordField: gridrecordfield(
    recordField: <recordField>
  ),
  label: null,
  labelPosition: null,
  checkedTemplate: null,
  uncheckedTemplate: null,
  title: null,
  validator: null,
  readOnly: null,
  colWidth: null,
  horizontalAlign: null,
  verticalAlign: null
)
Parameter Type Description
recordField Text Specifies the record field associated with this column configuration, configured by passing the record field into gridrecordfield().
labelPosition Text Where to display the label on each cell. Valid options include "BEFORE" and "AFTER". Defaults to "AFTER" if set to null.
checkedTemplate Boolean Value displayed as a checked box. Defaults to a boolean true if set to null.
uncheckedTemplate Boolean Value displayed as an unchecked box. Defaults to a boolean false if set to null.
title Text Column header title. Defaults to field name if null.
validator Text Custom validator logic using the gridvalidator() function. Defaults to generic text validator if null.
readOnly Boolean Whether data in the column is read-only (true) or editable (false). Defaults to false if null.
colWidth Text Initial width of the column on load. Valid values include "AUTO", null, or an integer between 10 and 600. Defaults to "AUTO" if null.
horizontalAlign Text Determines the horizontal alignment of the grid column. Valid values: "LEFT", "CENTER", "RIGHT", "JUSTIFY". Default: "LEFT".
verticalAlign Text Determines the vertical alignment of the grid column. Valid values: "TOP", "MIDDLE", "BOTTOM". Default: "TOP".

Example:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
gridcheckboxcolconfig(
  recordField: gridrecordfield(
    recordField: <recordField>
  ),
  label: null,
  labelPosition: null,
  checkedTemplate: null,
  uncheckedTemplate: null,
  title: "Available Globally",
  validator: null,
  readOnly: null,
  colWidth: 75,
  horizontalAlign: "JUSTIFY"
)

griddropdowncolconfig()

Dropdown column configuration function. Every grid function must have all parameters configured in the exact order that they are written in the expression editor description. Mark any unused or unnecessary parameters explicitly as null.

For easy set-up, copy and paste the following expression:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
griddropdowncolconfig(
  recordField: gridrecordfield(
    recordField: <recordField>
  ),
  source: griddropdownsource(
    choiceLabels: { "Option 1", "Option 2", "Option 3", "Option 4" },
    choiceValues: { 1, 2, 3, 4 }
  ),
  strict: true,
  filter: null,
  title: null,
  validator: null,
  readOnly: null,
  colWidth: null,
  horizontalAlign: null,
  verticalAlign: null
)
Parameter Type Description
recordField Text Specifies the record field associated with this column configuration, configured by passing the record field into gridrecordfield().
source Text List of options to display in the dropdown, configured as a list or using the gridDropdownSource() function. Example: gridDropdownSource(choiceLabels: { "Option 1", "Option 2", ... }, choiceValues: { 1, 2, ... }) or a simple list of values to be used as both the labels and the values: Example: { "Option 1", "Option 2" }
strict Boolean Whether to highlight input not present in the given source list. Defaults to false if set to null.
filter Boolean Whether to filter dropdown options as user types in the cell. Defaults to true if set to null.
title Text Column header title. Defaults to field name if null.
validator Text Custom validator logic using the gridvalidator() function. Defaults to generic text validator if null.
readOnly Boolean Whether data in the column is read-only (true) or editable (false). Defaults to false if null.
colWidth Text Initial width of the column on load. Valid values include "AUTO", null, or an integer between 10 and 600. Defaults to "AUTO" if null.
horizontalAlign Text Determines the horizontal alignment of the grid column. Valid values: "LEFT", "CENTER", "RIGHT", "JUSTIFY". Default: "LEFT".
verticalAlign Text Determines the vertical alignment of the grid column. Valid values: "TOP", "MIDDLE", "BOTTOM". Default: "TOP".

Example:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
local!genres: {
  "Comedy",
  "Horror",
  "Documentary",
  "Drama",
  "Romance",
  "Thriller"
},
/* Distinct choiceLabels and choiceValues */
griddropdowncolconfig(
  recordField: gridrecordfield(
    recordField: <recordField>
  ),
  source: griddropdownsource(
    choiceLabels: local!genres,
    choiceValues: {1,2,3,4,5,6}
  ),
  strict: true,
  filter: false,
  title: "Genres",
  validator: null,
  readOnly: false,
  colWidth: null
  )
/* Labels and values are the same */
griddropdowncolconfig(
  recordField: gridrecordfield(
    recordField: <recordField>
  ),
  source: local!genres,
  strict: true,
  filter: false,
  title: "Genres",
  validator: null,
  readOnly: false,
  colWidth: null
)

Auxiliary configuration functions

These are helper functions that are commonly utilized in the component configuration. These are all imported as a part of the GridPlus Helper Plug-in.

gridrecordactionconfig()

The gridrecordactionconfig() function returns a configuration that specifies record action details. It is applied for the recordActions component parameter, which will accept a list of record action configurations.

The function includes the following parameters:

Parameter Type Description
recordActionModel Number The process model constant for the record action.
recordActionName Text The record name to display in the component's button for the record action.

gridrelatedactionconfig()

The gridrelatedactionconfig() function returns a configuration that specifies related action details. It is applied within the linkConfig parameter of either the gridtextcolconfig() function or the gridnumericcolconfig() function. The function includes the following parameters:

Parameter Type Description
recordPrimaryKeyField Record Type Provide the primary key of the related action's record type within the gridrecordfield() function.
relatedActionModel Number The process model constant for the related action.

gridstyling()

The gridstyling() function is utilized to define the component's styling through the style parameter. It includes the following parameters:

Parameter Type Description
theme Text Defines the theme of the component. Options include: DEFAULT, MAIN_LIGHT, MAIN_DARK, HORIZON_LIGHT, HORIZON_DARK
accentColor Text Defines the accent color of the component. Provide the hex code for accent color.
validationColor Text Defines the validation color. Provide the hex code for the validation color.
buttonShape Text Provide one of the following button shapes: SEMI_ROUNDED, ROUND, SQUARE.
headerAlign Text Provide one of the following to align the column header: LEFT, CENTER, RIGHT.
backgroundColor Text Provide the hex code for the background color. If not configured, a default value will be set.
embeddedInterfaceThemeIdentifier Text Provide the themeIdentifier for the embedded interface that displays record actions and related actions.

gridsubmitchanges()

The gridsubmitchanges() function is invoked when the user clicks the SUBMIT CHANGES button.

Each process model (createModel, editModel, deleteModel) configured within gridsubmitchanges() must have the following configurations:

  • Activity chaining enabled across all nodes.
  • A process variable named record with:

    • Multiple? set to true.
    • Parameter set to true.

gridsubmitchanges() includes the following parameters:

Parameter Type Description
queryRuleName Text The name of the expression rule that uses the a!queryRecordType() function to query a record type, provided either as a rule reference (without parentheses) or as a string (e.g., rule!GA_queryRule or "GA_queryRule").
colConfigRuleName Text The name of the expression rule that defines the column configuration map, provided either as a rule reference (without parentheses) or as a string (e.g., rule!GA_columnConfiguration or "GA_columnConfiguration")
createData Any Type A list of new records created within the grid. This is configured using the variable specified in the createDataValue parameter of the component.
editData Any Type A list of record edits made within the grid. This is configured using the variable specified in the editDataValue parameter of the component.
deleteData Any Type A list of record deletions made within the grid. This is configured using the variable specified in the deleteDataValue parameter of the component.
createModel Integer The process model constant that identifies the process model for creating records. Set this to null to disable the component's record creation functionality. Make sure that the process model has a process variable named "record" that has "Multiple" (variable can store multiple values) set to true. Make sure to configure activity chaining across all nodes in createModel, editModel, deleteModel.
editModel Integer The process model constant that identifies the process model for updating records. Set this to null to disable the component's record editing functionality. Make sure that the process model has a process variable named record that has Multiple (variable can store multiple values) set to true. Make sure to configure activity chaining across all nodes in createModel, editModel, deleteModel.
deleteModel Integer The process model constant that identifies the process model for deleting records. Set this to null to disable the component's record deletion functionality. Make sure that the process model has a process variable named record that has Multiple (variable can store multiple values) set to true. Make sure to configure activity chaining across all nodes in createModel, editModel, deleteModel.

Example:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
a!localVariables(
  local!submitChanges:{},
  local!creates: {},
  local!edits: {},
  local!deletions:{},
  gridPlusLayoutField(
    queryRuleName: rule!RE_queryRule,
    queryRuleInputs: {
      recordFields: gridrecordfield(
        recordField: {
          <recordField>,
          <recordField>
        }
      ),
      batchSize: 25
    },
    columnConfigs: rule!RE_columnConfig(),
    createDataValue: local!creates,
    createDataSaveInto: local!creates,
    editDataValue: local!edits,
    editDataSaveInto: local!edits,
    deleteDataValue: local!deletions,
    deleteDataSaveInto: local!deletions,
    submitChangesValue: local!submitChanges,
    submitChangesSaveInto: a!save(
      target: local!submitChanges,
      value: gridsubmitchanges(
        queryRuleName: rule!RE_queryRule,
        colConfigRuleName: rule!RE_columnConfig,
        createData: local!creates,
        editData: local!edits,
        deleteData: local!deletions,
        createModel: cons!RE_CREATE_OR_UPDATE,
        editModel: cons!RE_CREATE_OR_UPDATE,
        deleteModel: cons!RE_DELETE
      )
    )
  )
)

gridrecordfield()

The column configuration functions described include a recordField parameter, which is set to a gridrecordfield() function call. This function returns the record field and its associated relationship as Text. This enables users to directly pass in the record field to the appropriate column configuration function. It includes the following parameters:

Parameter Type Description
recordField List of Variant Returns the record field and its associated relationship. Values in this list have the following elements: recordType!<recordType>.<fields>.<fieldName> or recordType!<recordType>.<relationships>.<relationshipName>.<fieldName>.

Example:

1
2
3
gridrecordfield(
  recordField: 'recordType!{65ea2ed9-5a61-45be-923a-67009acb07d1}GA Show Record.fields.{1b9ecab0-1696-4528-a2be-0d172ad01dfc}productionCost'
)

gridvalidator()

The gridvalidator() function plug-in, utilized within the column configuration functions, is used to apply custom validation logic to grid data on a per column basis. Each column configuration function has a validator parameter where this function can be used. Note that the validation is not applied when the linkConfig parameter is configured.

This function has the following parameters:

Parameter Type Description
name Text Unique name to be assigned to your custom validator. Required value, no default.
operator Text Operator for your validator logic. Valid operators include lessThan, greaterThan, equals, notEquals, regex, isTrue, isFalse, isNullOrEmpty, isNotNullOrEmpty, contains, and notContains. Required value, no default.
value Text Value to compare cell value to using operator. Required for all operators with the exception of isTrue, isFalse, isNullOrEmpty, or isNotNullOrEmpty.
validationMessage Text Message to display when hovering over an invalid cell. Provide DEFAULT to show a default validation message. Provide Null for not showing any message. Maximum character limit is 125.

Example:

1
2
3
4
5
6
7
8
9
10
11
gridtextcolconfig(
  field: "email",
  title: "Email",
  validator: gridvalidator(
    name: "verifyAppianEmail",
    operator: "regex",
    value: "@appian.com",
    validationMessage: "DEFAULT"
  ),
/* Insert other parameters below */
)
Operators and data types

Certain operators are better suited to evaluate certain data types. See the below chart for which operators are permitted for each column configuration type:

Checkbox Numeric Text Date Dropdown
lessThan No Yes No Yes No
greaterThan No Yes No Yes No
equals Yes Yes Yes Yes Yes
notEquals Yes Yes Yes Yes Yes
regex No No Yes Yes Yes
isTrue Yes No No No No
isFalse Yes No No No No
isNullOrEmpty Yes Yes Yes Yes Yes
isNotNullOrEmpty Yes Yes Yes Yes Yes
contains No No Yes No Yes
notContains No No Yes No Yes

Tip:  When querying related record data, it is important to note which fields are from one-to-many vs. many-to-one relationships. A field queried from a one-to-many relationship is an array type and is validated differently. Supported operators on these fields are: isNull, isNotNull, contains, notContains, equals and notEquals.

Example:

Example using a validator on text and checkbox columns:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
{
  gridtextcolconfig(
    recordField: gridrecordfield(
      recordField: <recordField>
    ),
    title: "Email",
    validator: gridvalidator(
      name: "verifyAppianEmail",
      operator: "regex",
      value: "@appian\.com"
    ),
    readOnly: false
   ),
   gridcheckboxcolconfig(
    recordField: gridrecordfield(
      recordField: <recordField>
    ),
    label: null,
    labelPosition: null,
    checkedTemplate: null,
    uncheckedTemplate: null,
    title: null,
    validator: gridvalidator(
      name: "testing",
      operator: "isTrue",
    ),
    readOnly: null
   )
}

gridexportconfig()

The gridexportConfig() function provides guidance to configuring your component parameter exportConfig. The following parameters are available to configure your export behavior:

Parameter Type Description
fileName Text Name of the exported csv file. Use '[YYYY]-[MM]-[DD]' in the text value to include the current date in the file name. This name does not include the file's csv extension. Defaults to DataExport_YYYY-MM-DD if null.
columnDelimiter Text Value of your column delimiter. Defaults to ',' if null.
rowDelimiter Text Value of your row delimiter. Defaults to '\r\n' if null.
columnHeaders Boolean Whether columnHeader names should be included in export. Defaults to true.
exportHiddenColumns Boolean Whether to include hidden columns in exported file. Defaults to false.
exportRange Text Range of rows and columns to export, defined by the gridexportrange() function. Defaults to all rows and fields if null or undefined.
buttonLabel Text Optional text value to display with download icon in export button. Defaults to no text if null.

Note:  CSV exports include raw data only and do not retain formulas, styling, or formatting. Additionally, exports are limited to a single page of data at a time. For a more comprehensive export of record types, see Export Record Types to Excel.

Example

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
gridPlusLayoutField(
  ...
  exportConfig: gridexportConfig(
    fileName: "GridPlusExample",
    columnDelimiter: ",,",
    rowDelimiter: null,
    columnHeaders: false,
    exportHiddenColumns: true,
    exportRange: gridexportrange(
      startRow: 1,
      startFieldName: gridrecordfield(
        recordField: <recordField>
      ),
      endRow: 50,
      endFieldName: gridrecordfield(
        recordField: <recordField>
      )
    ),
    buttonLabel: "Download Report"
  )
	...
)

gridexportrange()

The gridexportrange() function is used within the gridexportconfig() function to define the range of rows and columns to export. gridexportrange() has the following parameters:

Parameter Type Description
startRow Number Initial row index to include in the exported data. It must be greater than zero.
startFieldName Text Set this equal to a gridrecordfield() function call, passing in the appropriate record field as the parameter.
endRow Number Last row index to include in the exported data (exclusive range end). It must be less than or equal to 5000.
endFieldName Text Set this equal to a gridrecordfield() function call, passing in the appropriate record field as the parameter.

gridrecordlinkconfig()

The gridrecordlinkconfig() function defines the values necessary to configure a column of the grid component with links to record views. Note, the base user record is not supported. gridrecordlinkconfig() has the following parameters:

Parameter Type Description
recordPrimaryKeyField Text Provide the primary key of the record view's record type within the gridrecordfield() function.
urlStub Text The URL stub for the record view that the link will open. Go to the record type and click Views to find the URL stub for each record view. Default is summary if null.
targetLocation Any Type The location where the record view should open, which can be either a site page or Tempo. To reference a site page, use the following structure: site![site name].pages.[page web address identifier]. Default: "TEMPO"
openLinkIn Text Determines how the record link should open, either in the new tab or a new window. Valid values: "NEW_TAB" (default), "NEW_WINDOW" or "DIALOG".

Example

1
2
3
4
5
6
7
8
gridrecordlinkconfig(
  recordPrimaryKeyField: gridrecordfield(
    recordField: <Record Primary Key Field>
  ),
  urlStub: "summary",
  targetLocation: <target location>,
  openLinkIn: "DIALOG"
)

Usage considerations

Filtering and sorting

Clicking on the column headers will sort based on the column selected. This sort will replace any default sorts that are configured in the query rule.

To filter data, click the three-dot menu icon on a column header and select from the available filter options. These options are based on the column's data type. Filtering is supported whether or not a default filter is defined in the query rule. If filters or sorts are applied while edits are staged in Pending Changes, the filtering and sorting will be based on the underlying data, not the staged edits.

To configure the grid to load without default filters applied, simply omit the filters parameter of within the query rule.

To configure the grid to load with default filters applied, set the filters parameter in the query rule. Use ri!filters as a placeholder for filters selected by the end user. These runtime filters will be combined with any default logic defined in the query.

For example, the configuration below queries for records where the ID is greater than 10. As users apply additional filters via the grid UI, those values are inserted into the ri!filters placeholder.

Note:  When applying a default filter, you must explicitly use the string ri!filters at the location where user-selected filters should be applied. The value must be exactly ri!filters; other input names are not supported. You do not need to define a rule input for this—simply including ri!filters directly within the expression is sufficient.

Example:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
a!queryRecordType(
  recordType: 'recordType!{65ea2ed9-5a61-45be-923a-67009acb07d1}GA Show Record',
  fields: {
    'recordType!{65ea2ed9-5a61-45be-923a-67009acb07d1}GA Show Record.relationships.{e0990493-9a03-4390-a523-1ea9a554b29c}showToDirector.fields.{0f756c16-b4e6-4402-8d4b-7ab4d391b346}directorId',
    'recordType!{65ea2ed9-5a61-45be-923a-67009acb07d1}GA Show Record.relationships.{e0990493-9a03-4390-a523-1ea9a554b29c}showToDirector.fields.{0bf50e82-e092-4dce-ae67-359380f3b496}directorName',
    'recordType!{65ea2ed9-5a61-45be-923a-67009acb07d1}GA Show Record.relationships.{0b21f4ff-fb58-4812-a2fc-4dc754096d21}showToAward.relationships.{09c8157e-4d18-4bda-a8cb-e402d6526c53}awardToShow.relationships.{e0990493-9a03-4390-a523-1ea9a554b29c}showToDirector.fields.{70e1efcb-6ead-4bf9-8ba2-d525b0a5549d}biography'
  },
  filters: a!queryLogicalExpression(
    operator: "AND",
    filters: {
      a!queryFilter(
        field: 'recordType!{65ea2ed9-5a61-45be-923a-67009acb07d1}GA Show Record.fields.{164c3ec1-0dbf-46d8-bc8a-1caf1d334e31}id',
        operator: ">",
        value: 10
      ),
      ri!filters,
    },
    ignoreFiltersWithEmptyValues: true
  ),
  pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 10),
  fetchTotalCount: true
)

Internationalization

The GridPlus Component supports internationalization for operation labels (for example, labels that appear in the context menu) and currencies. Internationalization for operation labels will be automatically applied based on the locale defined in the Admin Console > Internationalization settings. To apply internationalization for numeric columns that display currencies, configure the culture parameter for the gridnumericcolconfig() function.

Supported locales include the following:

  • ar-AR (Arabic)
  • zh-CN (Chinese)
  • nl-NL (Dutch)
  • en-US (English)
  • fr-FR (French)
  • de-DE (German)
  • it-IT (Italian)
  • ja-JP (Japanese)
  • ko-KR (Korean)
  • pl-PL (Polish)
  • pt-BR (Portuguese)
  • ru-RU (Russian)
  • es-MX (Spanish)

Regardless of locale settings, commas are automatically removed from numeric inputs. Only decimal points (.) are recognized as valid decimal separators when parsing numeric values.

Performance and component limitations

  • The grid supports writing up to 5,000 records at a time.
  • The onSelect parameter saves the end user's clicks and selections within the grid back to Appian. For high-volume data use cases that involve copying large pages of data, it is recommended to not configure this parameter.
  • Editing of related record fields is not supported directly within the grid. To write to a record relationship, configure a column with the gridrelatedactionconfig() function.
  • Supported data types include those defined by the column configuration functions. Complex cell types which are supported by Appian's native grid components but not supported by GridPlus include:
    • Barcode
    • DateTime
    • Encrypted Text
    • File Upload
    • Image
    • Pickers
    • Progress Bar
    • Radio Buttons
    • Rich Text Display

Refer to Editable Grid Component for more information on the supported contents of a row.

Security

By default, users will not be able to view, edit, or delete records that they don’t have permission to access. For the Submit Changes button to properly write to records, the end user must:

Create

  • Process Model Security: Have initiator access on the createModel configured in the gridsubmitchanges() function.
  • Record Type Security: Have access to querying from the base record type.
  • Read-Only: If the readOnly parameter of the column configuration function defining that field is set to true, the user will be unable to write to that field.

Update

  • Process Model Security: Have initiator access on the editModel configured in the gridsubmitchanges() function.
  • Record Type Security: Have access to querying from the base record type.
  • Record-Level Security: Have access to querying the specific record they are attempting to modify.
  • Field-Level Security: Have access to each of the record’s fields they are attempting to modify.
  • Read-Only: If the readOnly parameter of the column configuration function defining that field is set to true, the user will be unable to write to that field.

Delete

  • Process Model Security: Have initiator access on the deleteModel configured in the gridsubmitchanges() function.
  • Record Type Security: Have access to querying from the base record type.

Known limitations

  • This component is not supported for use in incognito or private browsing mode.
  • Legacy record types are not supported for this component.

Examples

Column configuration example

This example demonstrates how column configuration functions work together in an expression.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
a!localVariables(
  local!genres: {
    "Comedy",
    "Horror",
    "Documentary",
    "Drama",
    "Romance",
    "Thriller"
  },
  local!Show_RecordRelatedAction: gridrelatedactionconfig(
    recordPrimaryKeyField: gridrecordfield(
      'recordType!{65ea2ed9-5a61-45be-923a-67009acb07d1}GA Show Record.fields.{164c3ec1-0dbf-46d8-bc8a-1caf1d334e31}id'
    ),
    relatedActionModel: cons!GA_PM_CREATE_OR_UPDATE_RECORD_ACTION,
  ),
  local!showRecordViewLink: gridrecordlinkconfig(
    recordPrimaryKeyField: gridrecordfield(
      'recordType!{65ea2ed9-5a61-45be-923a-67009acb07d1}GA Show Record.fields.{164c3ec1-0dbf-46d8-bc8a-1caf1d334e31}id',
    urlStub: "summary",
    targetLocation: site!Show.pages.showInfo
    )
  ),
  local!Director_RecordViewLink: gridrecordlinkconfig(
    recordPrimaryKeyField: gridrecordfield(
      'recordType!{32baad89-e609-4a47-a84d-c8df565e9a4e}GA Director Record.fields.{0f756c16-b4e6-4402-8d4b-7ab4d391b346}directorId'
    ),
    urlStub: "summary",
    targetLocation: site!Show.pages.DirectorInfo
  ),
  local!DirectorRelatedActionConfig: gridrelatedactionconfig(
    recordPrimaryKeyField: gridrecordfield(
      'recordType!{32baad89-e609-4a47-a84d-c8df565e9a4e}GA Director Record.fields.{0f756c16-b4e6-4402-8d4b-7ab4d391b346}directorId'
    ),
    relatedActionModel: cons!GA_CREATE_DIRECTOR
  ),
  {
    gridtextcolconfig(
      recordField: gridrecordfield(
        recordField: 'recordType!{65ea2ed9-5a61-45be-923a-67009acb07d1}GA Show Record.fields.{6ae3e108-c995-487f-9a02-275eef4ecd19}title'
      ),
      linkConfig: local!Show_RecordRelatedAction,
      title: "Title",
      validator: gridvalidator(
        name: "titleValidator",
        operator: "equals",
        value: "123"
      ),
      readOnly: false,
      colWidth: 350,
      horizontalAlign: "RIGHT",
      verticalAlign: "BOTTOM"
    ),
    griddatecolconfig(
      recordField: gridrecordfield(
        recordField: 'recordType!{65ea2ed9-5a61-45be-923a-67009acb07d1}GA Show Record.fields.{feea85af-dfe6-4f69-8918-f9dc287a9607}releaseDate'
      ),
      dateFormat: "MM/DD/YYYY",
      correctFormat: null,
      title: "Release Date",
      validator: null,
      readOnly: null,
      colWidth: "AUTO"
    ),
    gridcheckboxcolconfig(
      recordField: gridrecordfield(
        recordField: 'recordType!{65ea2ed9-5a61-45be-923a-67009acb07d1}GA Show Record.fields.{bfdd6e8a-c433-4673-8142-93a53fb32e29}availableGlobally'
      ),
      label: null,
      labelPosition: null,
      checkedTemplate: null,
      uncheckedTemplate: null,
      title: "Available Globally",
      validator: null,
      readOnly: null,
      colWidth: 75,
      horizontalAlign: "CENTER",
      verticalAlign: "MIDDLE"
    ),
    gridnumericcolconfig(
      recordField: gridrecordfield(
        recordField: 'recordType!{65ea2ed9-5a61-45be-923a-67009acb07d1}GA Show Record.fields.{9bcce6dc-b4f7-48d5-b894-06d1d14c6cea}rating'
      ),
      linkConfig: null,
      format: "0.0%",
      title: "Viewer Ratings",
      validator: gridvalidator(
        name: "ratingValidator",
        operator: "greaterThan",
        value: 0.5
      ),
      readOnly: false,
      colWidth: 75,
      culture: null
    ),
    gridnumericcolconfig(
      recordField: gridrecordfield(
        recordField: 'recordType!{65ea2ed9-5a61-45be-923a-67009acb07d1}GA Show Record.fields.{1b9ecab0-1696-4528-a2be-0d172ad01dfc}productionCost'
      ),
      linkConfig: local!showRecordViewLink,
      format: "$0,0.00",
      title: "Production Cost",
      validator: null,
      readOnly: false,
      colWidth: null,
      culture: null
    ),
    gridnumericcolconfig(
      recordField: gridrecordfield(
        recordField: 'recordType!{65ea2ed9-5a61-45be-923a-67009acb07d1}GA Show Record.fields.{a7ed3b86-5ae7-43d6-9e2f-d52df6345af4}advertisingRevenue'
      ),
      linkConfig: null,
      format: "$0,0.00",
      title: "Ad Revenue",
      validator: null,
      readOnly: true,
      colWidth: null,
      culture: null
    ),
    griddropdowncolconfig(
      recordField: gridrecordfield(
        recordField: 'recordType!{65ea2ed9-5a61-45be-923a-67009acb07d1}GA Show Record.fields.{b2b12b0d-b44e-40e1-b6a4-983e10d76edd}genre'
      ),
      source: griddropdownsource(
        choiceLabels: local!genres,
        choiceValues: {1,2,3,4,5,6}
      ),
      strict: true,
      filter: false,
      title: "Genres",
      validator: null,
      readOnly: false,
      colWidth: null
    ),
    gridnumericcolconfig(
      recordField: gridrecordfield(
        recordField: 'recordType!{65ea2ed9-5a61-45be-923a-67009acb07d1}GA Show Record.relationships.{e0990493-9a03-4390-a523-1ea9a554b29c}showToDirector.fields.{0f756c16-b4e6-4402-8d4b-7ab4d391b346}directorId'
      ),
      linkConfig: local!Director_RecordViewLink,
      format: null,
      title: "Director ID",
      validator: null,
      readOnly: null,
      colWidth: null,
      culture: null
    ),
    gridtextcolconfig(
      recordField: gridrecordfield(
        recordField: 'recordType!{65ea2ed9-5a61-45be-923a-67009acb07d1}GA Show Record.relationships.{e0990493-9a03-4390-a523-1ea9a554b29c}showToDirector.fields.{0bf50e82-e092-4dce-ae67-359380f3b496}directorName'
      ),
      linkConfig: local!Director_RecordViewLink,
      title: "Director Name",
      validator: null,
      readOnly: false,
      colWidth: null
    ),
    gridtextcolconfig(
      recordField: gridrecordfield(
        recordField: 'recordType!{65ea2ed9-5a61-45be-923a-67009acb07d1}GA Show Record.relationships.{0b21f4ff-fb58-4812-a2fc-4dc754096d21}showToAward.relationships.{09c8157e-4d18-4bda-a8cb-e402d6526c53}awardToShow.relationships.{e0990493-9a03-4390-a523-1ea9a554b29c}showToDirector.fields.{70e1efcb-6ead-4bf9-8ba2-d525b0a5549d}biography'
      ),
      linkConfig: local!DirectorRelatedActionConfig,
      title: "Director bio",
      validator: null,
      readOnly: true,
      colWidth: 200,
      horizontalAlign: "CENTER",
      verticalAlign: "MIDDLE"
    )
  }
)

Feedback