CRUD Grid

Description

Spreadsheet-like widget with ability to customize interactions

Settings

Name Type Group Required Description Default
Grid Data DATA_SETTING_TYPE Data true {“dataType”:“CALCULATED_DATA_TYPE”,“value”:“return {\“keyColumn\”: \“columnName\“, \“data\”: [{\“col1name\”: \“col1value\“, \“col2name\”: \“col2value\“, \“col3name\”: \“col3value\“}, {\“col1name\”: \“col1value\“, \“col2name\”: \“col2value\“, \“col3name\”: \“col3value\“}, {\“col1name\”: \“col1value\“, \“col2name\”: \“col2value\“, \“col3name\”: \“col3value\“}]};”}
Fetch Grid Data DATA_SETTING_TYPE Data true Used to fetch data from datasource when the grid is filtered, sorted, or refreshed.
Add Item Event DATA_SETTING_TYPE Data false
Delete Item Event DATA_SETTING_TYPE Data false
Update Item Event DATA_SETTING_TYPE Data false
Allow Create boolean Capabilities false Grant permissions for users to add rows
Allow Delete boolean Capabilities false Grant persmissions for users to delete rows
Allow Update boolean Capabilities false Grant persmissions for users to update rows
Allow Filter boolean Capabilities false Grant persmissions for users to filter rows
Allow Data Export boolean Capabilities false Grant persmissions for users to export table
Allow Column Sorting boolean Capabilities false Grant persmissions for users to sort columns
HTML Id text false Used to target widget element in the DOM
Allow Fullscreen boolean false