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");