FAQ

FAQ (Frequently Asked Questions)

Is there’s a possibility to add pagination to the Enhanced Grid Pro?

A: No, that’s not possible, we only support “infinite scroll”. At the moment there are no plans on making pagination available.

Using Dynamic actions - is it possible to use “Execute Server-side Code” to get/set/validate values in cells (client-side)?

A: No, not yet. For now, you can only use our JavaScript API to do this.

How to trigger “save” from an external button?

A: Here’s the code sample (replace “STATIC_ID” below with the static ID of your Grid region):

let ucGrid = $("#ucGrid_STATIC_ID").ucGrid("instance");
ucGrid.save();

For other functions available, please check JavaScript API.

When using Arrow keys to navigate the grid, how can I enable automatic scrolling to the current cell?

A: Please set the Grid Max Height attribute. This will enable the grid to scroll automatically when navigating with the arrow keys.

How to edit date and time

A: Enhanced Grid Pro currently only supports a Date picker with no time picker support. You can still let users edit the date and time by using the “Plain text” column type and setting a Format Mask in the Appearance section. This will also make sure that valid dates are entered.

Can enhanced grid pro handle large Clobs (>32k)?

A: Yes, you can query, display, and edit large clobs in with Enhanced Grid Pro.

Can I use my Shared Components LOVs for select lists in Enhanced Grid Pro?

A: Unfortunately APEX does not support selecting Shared Component LOVs for region columns. You can support my APEX idea/feature request so that the APEX team can consider adding this feature in the future.

As a workaround you can query your existing LOVs with a query:

select display_value, return_value
  from apex_application_lov_entries
 where application_id = :app_id
   and list_of_values_name = 'YOUR_LOV_NAME'
  ;

How can I save the grid with CTRL+S?

A: Adding native support is on our roadmap. For now, you can use the following JavaScript code to allow users to save the grid with CTRL+S:

async function saveGrid() {
    const gridInstance = $("#ucGrid_STATIC_ID").ucGrid("instance")
    await gridInstance.save();
}

apex.actions.add({
    name: "save-grid",
    label: "Save the grid",
    action: () => {
        saveGrid()
    }
});

apex.actions.addShortcut("Ctrl+S", "save-grid");