- Release notes
- Getting started
- For administrators
- Designing automations
- Creating an automation from an idea
- Creating a project
- How to start an automation
- Managing project files and folders
- Connecting automations to your accounts
- Configuring activities
- Managing the activities in a project
- Passing values between activities
- Iterating through items
- Managing the data in a project
- Configuring a project to use your data
- Using file and folder resources
- Running and testing your projects
- Managing automations
- App projects
Studio Web User Guide
Edit Grid
The Edit Grid control allows you to list, edit, paginate, or search tabular records.
-
Data source - The source of data you want to edit inside the grid. By default, creates a workflow with a Query Entity Record activity. You can also reference an object of the type AppsDataSource.
Once you fetch the data source, the grid automatically detects the data columns. Clicking the More icon of each column navigates you to the following properties:
-
Name - The display name of the column header.
-
Source - The field of the referenced entity.
-
Edit mode view - Determines how to interact with the column:
Edit mode view option
Description
Textbox
Cells in the column behave as a Textbox control.
Datepicker
Cells in the column behave as a Datepicker control.
Checkbox
Cells in the column behave as a Checkbox control.
Dropdown
Cells in the column behave as a Dropdown control.
Multi select
Cells in the column behave as a Multi select control.
-
Hidden - If true, hides the column at runtime.
-
Editable - If false, marks the content of the column as read-only.
-
-
Add new column - Add new columns to your data by clicking the plus "+" icon.
-
Hidden - If true, hides the control at runtime.
-
Editable - If false, marks the control as read-only.
-
Add rows - If true, allows app users to add new rows at runtime. If false, users cannot add new rows.
-
Delete rows - If true, allows app users to delete rows. If false, users cannot delete rows.
-
Search - If true, exposes a built-in search capability.
The Date Picker in the Edit Grid does not support editing column types which contain time values. Configure the column in your Data Service entity using the Exclude time option to avoid errors in your data.
If you need to include a time column, set the Edit mode view option of the column to the Textbox type.
-
Row selected - Configure what happens when a row is selected.
-
Row added - Configure what happens when a row is added.
-
Row modified - Configure what happens when a row is modified.
-
Row deleted - Configure what happens when a row is deleted.
-
Control Alignment - By default, inherits the parent alignment. A different alignment other than the parent can be set. To default back to the parent alignment, deselect the overridden options.
Note: The alignment is dependent on the layout selected for the parent (Vertical vs Horizontal). -
Background color - The background color for the Grid header and Grid body.
-
Border - The border for the control. Border Thickness, Color, and Radius can be configured.
-
Font - The font attributes for both the Column header and Column body text, such as font family, size, color, or style (Bold, Italic and Underline). By default, the control inherits the font family of the immediate parent container which is indicated by the keyword "Inherited".
-
Margin - The margin of the control. By default, a margin of 4px is set. Top/Bottom and Left/Right margin properties are combined. These properties can be detached using the Link button at the right side of the Margin section.
-
Size - The width and height of the control. By default, the size is set to
auto. To set minimum or maximum values, click the three dot icon (...). If the size of the control is smaller than the options, a scroll bar is displayed.
|
VB property |
Data type |
Description |
|---|---|---|
|
|
|
References the currently selected item in the control. |
|
|
|
References the data source for the values inside the Table control. |
|
|
|
References the item being created by the Add row option. The Row added event references this property. |
|
|
Boolean | Determines if the Edit Grid is editable. |
|
|
Boolean |
Determines if rows can be added to the Edit Grid. |
|
|
Boolean |
Determines if rows can be deleted from the Edit Grid. |
|
|
Integer |
References the index of the row for update and delete operations. Should be used for process integration where there entire dataset is in-memory. |
|
|
Boolean |
Enables or disables the search function. If true, search is enabled. |
|
|
| The currently selected value of the control.
|
|
|
Boolean | If true, hides the control at runtime. |
|
|
Boolean | If true, disables the control at runtime. |
