GridPlus Helper

 Advanced Plug-ins provide exclusive features that extend and enhance Appian platform capabilities. Available for customers with Advanced and Premium licenses, these plug-ins can be deployed through the Admin Console for Cloud environments or via MyAppian for Self-Managed installations.

Overview

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 multicell 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.

Note:

Key Features & Functionality

Data Interaction and Management:

  • Supports extensive data types including text, numeric, checkbox, currency, date, links, and percentages.
  • 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 include Arabic (arAR), Chinese Simplified (zhCN), Dutch (nlNL), English (enUS), French (frFR), German (deDE), Italian (itIT), Japanese (jaJP), Korean (koKR), Polish (plPL), Brazilian Portuguese (ptBR), Russian (ruRU), and Mexican Spanish (esMX).
  • 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 permissioning.
  • 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.
Anonymous
  • Hi  ,

    Could you please confirm which version of the component and helper plugin you are using?
    Support for primary keys of type Text was introduced in version 1.2.3.

    If you are using an earlier version, please try upgrading both the component and helper plugins to the latest release and check if the issue persists.

    Best regards,
    Ananth

  • Hello Team,
    I am facing issue with record types having primary of type text.

    Error: Failed to process primaryKey. Make sure the query expression rule is valid.

  • Issue with GridPlus: Unable to Validate and Format Decimal Numbers up to 6 Digits

    I am encountering an issue when attempting to display numeric values with more than two decimal places in the Grid Plus Component Plug-In (version 1.1.0).

    When I apply the number formatting option within the grid column configuration, the display is automatically limited to two decimal places.

    If I remove the formatting, all decimal places are displayed correctly (for example, 2.34567); however, in that case, the values are no longer displayed with comma formatting.

     

    Expected Behavior:

     

    Could you please advise how to configure Grid Plus to:

    • Allow and validate decimal numbers with up to six digits of precision.
    • Display these values with comma formatting (e.g., 123,456.789)?

    Please see the attached screenshots:

    1. With and without formatting in configuration:
      The grid contains two columns  one with formatting applied in the configuration and another without.
      • The formatted column automatically rounds values when more than two decimal places are entered.
      • The unformatted column correctly displays up to six decimal places but does not apply comma formatting to the values.
    2. Formatting up to six decimals:
      I attempted to modify the configuration to allow more than two decimal places, but it resulted in an error.

  • v1.2.4 Release Notes

    • Bug fix: Resolved an issue in the “Submit Changes” action that occurred when a null entry was present while editing existing data.
  • v1.2.3 Release Notes

    • Support for Record Types with a primary key of type Text
    • Bug fixes and improvements

  • Hi Dinesh,

    Related record fields are not editable in-line within the grid component itself. Configure a related action to manage editing of these fields

  • when calling the Parent record field it is editable/Non Editable, But

    When i call the child record field the field become non editable.Fix?

  • v1.2.2 Release Notes
    • Bug fix: Resolved an issue where the “Submit Changes” action required a Date field entry; it now functions correctly with or without Date field data.
  • v1.2.1 Release Notes
    • Bug fix: queryRuleInputs now accepts text input
  • v1.2.0 Release Notes
    • A new component parameter, queryRuleInputs, has been added to enable dynamic adaptation of query rules based on rule input values. This allows for real-time updates to grid data, including dynamic filtering, sorting, and modification of queried fields.
    • A "Clear Changes" context menu option is now available, providing users with the ability to revert both single and multi-selected cells to their initial values.
    • The background color that indicates cell edits will now revert to its original state once the changes are cleared, improving visual consistency.
    • A new option has been added to allow record links to be opened in a modal window, enhancing the speed of navigation between record views. 
    • Bug fixes & improvements