GridPlus Component Plug-In

 

Important Note: Starting in Appian 25.2, Grid+ will be included as an exclusive offering within Advanced and Premium license tiers. This enhanced version will be actively maintained and updated. This listing will remain active and will continue to receive necessary security and CVE updates until May 23rd, at which point, it will be deprecated.

Overview

An editable grid that easily display up to 5,000 rows of editable record data at a time, without needing pagination or experiencing lag. Data is displayed in a flexible and modern interface, equipped with features such as drag & drop columns, column sorting and filtering, manually adjustable column sizes, freezable columns, and many others.

End user abilities include:

  • Quickly manipulate single items of data or large batches by way of multicell selection
  • Create new records by adding data into empty rows either in the middle or at the bottom of the grid
  • Delete records by the 'remove rows' button in a pop up context menu

Key Features & Functionality

  • Flexible presentation of record data
    • Resize columns
    • Drag & drop columns
    • Display row headers
    • Add borders around selected cells
    • Hide or show columns
    • Freeze or unfreeze columns
    • Define column widths for each column
    • Display links to record views
  • Export record data from grid: download to local storage a CSV file of your grid’s current data view
  • Sorting and filtering: rapid, server-side, multi-column
  • Data formatting: currency, percentages, date, dropdowns, checkboxes, etc.
  • Edit records: alter individual or many cell values to update existing records
  • Create records: create new records of a designer-specified record type
  • Delete records: remove rows of data to delete records from the data fabric
  • Excel-like behavior
    • Range cell selection with mouse select and drag
    • Copy, cut, and paste
    • Keyboard manipulation of and navigation between data
    • Intuitive context menus with complex functionality (insert new row, remove row, cut, copy, add border)
  • User based security: restrict editing by user and group with SAIL expressions
  • Column level data types (Auto-Wrapping Text, Numeric, Date, Dropdown, Checkbox)
    • Specialized filtering, editing, and validation ability by type
  • Internationalization: Automatically applies language updates based on the locale configured in Appian's internationalization settings (Supported locales include: arAR, zhCN, nlNL, enUS, frFR, deDE, itIT, jaJP, koKR, plPL, ptBR, ruRU, and esMX)
Anonymous
  • What configuration changes needed to freeze columns through code?

  • v3.1.0 Release Notes
    • Internationalization 
    • Updated SAIL expressions in the Sample Application and documentation to conform to best practices for securely applying changes to records. If data from Grid+ is persisted to records, it is highly encouraged that designers follow this implementation. 
    • See the attached 'Grid+ Component and Helper Documentation' for detailed guidance on component configuration, sample app setup, recommended use cases, etc.
  • Is the Grid+ Sample App recommended to install on Appian 24.4 environment? Because it contains a document called "navigation-config" which will overwrite the existing document which was updated as part of our Appian 24.4.

    Due to this file conflict it does not appear safe to use for our Appian 24.4 environment.

  • record can fetch only 5000 data once so if we want to show next 5000 batch then how to show?

  •  

    Hi Richa,

    This grid does not support paging. A key advantage of Grid+ is the quantity of data that can be shown at once in the component, which presumably eliminates the need for paging. I hope this is helpful, let me know if you have remaining questions.

    Best,

    Alex

  • How to implement paging as I want to show 100 row per page ?.

  • v3.0.0 Release Notes

    New Features:

    • Record Links: cast each cell in a text or numeric column to a link to a record view by configuring the linkConfig in your column configuration. Configuration options can be found through the recordlinkconfig function through this component's associated Grid+ Helper Plug-In. See downloadable migration guide for more details.
    • Export Button: export the current view of your grid component as a csv file. Configuration options can be set by the component's exportConfig parameter. See downloadable migration guide for more details.
    • Style Parameter: customize the accent color and validation color for your grid using "AUTO" or any valid hex color. Accent color set to AUTO will retrieve the highlight color of the grid's site. Validation color set to AUTO will use the default error color of #​​ffbeba.

    ***When updating this Grid+ Component Plug-In, ensure the associated Grid+ Helper plug-in is also updated to version 3 or later. See the attached migration guide for guidance on how to update your grid's configuration for this new version. Instructions are given for upgrading from any previous version.

    See the attached 'Grid+ Component and Helper Documentation' for detailed guidance on component configuration, sample app setup, recommended use cases, etc.
  • v3.0.0 Release Notes
    New Features:
    • Record Links: cast each cell in a text or numeric column to a link to a record view by configuring the linkConfig in your column configuration. Configuration options can be found through the recordlinkconfig function through this component's associated Grid+ Helper Plug-In. See downloadable migration guide for more details.
    • Export Button: export the current view of your grid component as a csv file. Configuration options can be set by the component's exportConfig parameter. See downloadable migration guide for more details.
    • Style Parameter: customize the accent color and validation color for your grid using "AUTO" or any valid hex color. Accent color set to AUTO will retrieve the highlight color of the grid's site. Validation color set to AUTO will use the default error color of #​​ffbeba.

    ***When updating this Grid+ Component Plug-In, ensure the associated Grid+ Helper plug-in is also updated to version 3 or later. See the attached migration guide for guidance on how to update your grid's configuration for this new version. Instructions are given for upgrading from any previous version.

    See the attached 'Grid+ Component and Helper Documentation' for detailed guidance on component configuration, sample app setup, recommended use cases, etc.
  •   

    Hi Riyaz! The direct editing of related record fields is not possible from Grid+ due to potential cascading effects within the data fabric. 

    Soon there will be a new configuration to support record view links in the grid cells. As an alternative solution, you could configure this related record field to link to the related record view where record actions are accessible. 

    Hope this is helpful.

  • Thanks for the explanation, I believe I understand what you are trying to do.

    I'm not sure this is possible since the grid currently only reevaluates from changes made to the data from the UI and not from external changes (e.g. SAIL updates) made to the data.

    There are a few potential feature enhancements that could enable this logic. I'll take this as feedback and update you if/when this is made possible in future versions of Grid+. In the meantime, I believe you could write the updated local!data somewhere persisting (like in a record or a file) and manually refresh the grid to view changes to isActive.

    Sorry for any inconvenience! Let me know if you have other questions.