Web Forms Widget Grid Entry Screen

<< Click to Display Table of Contents >>

Navigation:  Enterprise > Widgets > Web Forms >

Web Forms Widget Grid Entry Screen

Manual data entry is performed on the Grid Entry screen of the Web Forms widget. The Grid Entry screen can be opened by clicking the Edit Col-Edit-Icon icon or the Create Ent-Web_Forms_Widget-Create_Icon icon of a data form in the the Web Forms List. The Web Forms List is replaced with the Web Forms Grid Entry screen. The data entry grid reflects the structure of the Collect template used to create the data form. If the Collect template has multiple forms, then each parent form will be a separate tab in the Grid Entry screen. Each field on the form will be displayed as a column header in the grid.




The widget header displays the name of the selected data form. Hovering the mouse over the name shows a tooltip with the name, Collect template, and EQuIS format of the data form. The widget header also contains buttons to perform actions for the Grid Entry screen and the widget title, which can be changed the Web Forms Settings Manager.


Note: A data form can only be edited by one user at a time. If a data form is already being edited by another user, the data form will be locked to other users. Multiple users can add/edit content in a data form before it is submitted to Enterprise EDP, just not concurrently.


The bottom of the Grid Entry screen contains paging controls for displaying the number of records at a time, as described below.  

Arrows – Use the left/right arrows to navigate through pages.

Go to Page List – Select a specific page to navigate directly to that page.

Rows per Page – Change the number of rows (records) to be displayed per page by using the drop-down menu. Default is 25 rows.

Count of Pages and Total Items – This control indicates the total number of records available in the widget, how many pages to display the records, and which page is currently selected.



Grid Entry Screen Header Buttons


Back – Returns the user to the Web Forms List.


Import and Export – Allows user to import data from a Microsoft Excel spreadsheet or export to an Excel spreadsheet. To import properly, the spreadsheet must be in the correct layout. The Export button can be used to generate the correct layout. Clicking the Export button will provide the user with an option to export the data form with data or to a blank spreadsheet. The exported file contains a separate worksheet for each form (tab) in the data form. Each worksheet contains the columns (aka fields) on that form.


When entering data in an Excel file for import into the widget, each row will need to have an ID and parent. The ID must be unique across the entire worksheet. The parent refers to the parent row ID in the parent form. If the row does not need a parent, use ‘-1’.


Save – Saves data entered to the data form but does not upload the data to EQuIS Schema tables. All data entered in the data form remains available to be edited. The Web Forms widget is automatically configured to autosave grid entry every 5 minutes (unless changed in the Web Forms Settings Manager. A data form will also automatically be saved when the user navigates from the Grid Data Entry screen or uses the browser forward/back buttons.


Submit – Uploads the data form to be checked by Enterprise EDP using the EQuIS format defined in the Collect template upon which the data form is based. Users will be asked to confirm data submittal prior to uploading to EQuIS.



Grid Entry Screen Operation


Collect templates can have parent forms and child forms (sub-forms). Thus, data forms created from the template can have parent forms and child forms. Parent forms and any forms without child forms will display as tabs at the top of the data entry grid. Selecting a tab in the Grid Entry screen will display the supported fields as column headers in the data entry grid. If child form(s) exist for the selected tab (i.e., parent form), the child forms will display beneath the data entry grid. In the example below, six child forms are associated with the "Borehole" parent form.




To open a child form, select a row in the parent form grid and then select a child form on the bottom of the Grid Entry screen. The Grid Entry screen will change to display each child form as a tab with the selected row from the parent form denoted above the tab(s). In the example below, borehole B-01 was selected on the parent form and the "Soil Component Lithology" tab (i.e., child form) is ready for data entry. Each child form tab can be accessed after any child form is selected.




Any forms that contain data will have the form name displayed in bold.


Note: If the Background Color attribute has been configured for the Collect Template that was used to create the Web Form, the Background Color will be displayed under same conditions. Please see the Collect Forms – Field Types and Attributes article for more information.



Supported Field Types


The Web Forms widget supports many field types available in a Collect template. Unsupported field types will be disabled. The following is a list of all supported field types:


Long String

Date Time







Group Selector

Group Multi-Selector

Dynamic Selector

Form Lookup






Data Entry in Grid


Users can add new records (i.e., rows) or edit any existing records in the grid. Select a cell in an existing row to make the cell active for data entry. For the selected row, the value of the form's header field (e.g., location, sample ID) and the field description for the active cell displays in the grid pane above the column headers. Hovering the mouse over any column header will display a tooltip with the field description. When changes have been made on the form, an asterisk will display to the right of the form name until the changes have been saved.


To add new row(s) to the data entry grid, click the Add Ent-New_Role_Button-Icon icon in the upper left corner of the grid. The Add Multiple Rows dialog will open. Enter the number of desired rows and click OK. A maximum of 50 rows can be added.


Users can also add a row while actively entering data. Press the Enter key when in a cell in the last row to add a single row. The Add Multiple Rows dialog will not open.


Click the Delete Ent-Delete_Icon icon to delete the selected records (i.e., rows) from the data form. A message dialog will request confirmation to delete the selected rows.


The Web Forms widget was designed to support keyboard data entry. Use the "Tab" key to move between cells for quick data entry. Cells containing formulas (i.e., calculated fields) will be skipped when using keyboard navigation. Hit the "Enter" key to save the record and start a new record. See the Keyboard Shortcut Menu section of this article for more helpful keyboard shortcuts.


Note: If the visibility or calculated value of a field is dependent upon the value of another field, the user must actively save the record to activate the calculation/code of the dependent field.



Selector Fields


Reference values and other lookup information can be populated using selector field options. For fields that have selector options, values can be obtained using either a drop-down list or a dialog. By default, the multi-selector fields will use the dialog while the single selector fields will use the drop-down. The default display mechanism can be changed in the Web Forms Settings Manager. The only exception to this is when a dynamic selector field allows for user values—the field will always use the dialog. When a user selects the options drop-down or dialog, both the field Code and Description will be displayed. Once an option is selected and the cell is no longer active, only the field Code will display in the cell.


The selector dialog has a search that can expand into an advanced search to find items more easily in long lists.


Advanced Search – Click the down arrow to expand the advanced search dialog window. Items that can be searched will appear in the first drop-down. By default, the first drop-down will be selected as Any. The Any option will search all the items to match the expression with any of the properties. The second drop-down allows the user to select an operator (e.g., Starts With, Ends With, Equals, Contains). By default, the operator is set to StartsWith. The operator defines how the expression is matched to the items being searched. Enter the expression to be searched in the text field. Multiple expressions can be set by clicking the + button below the first expression. Expressions can also be removed/cleared by clicking the button to the left of each expression. To collapse the advanced search dialog, click the up arrow at the bottom of the advanced search dialog. Note that collapsing the advanced search will not clear search expressions that have been setup.


When the field is a dynamic selector field and allows user values, the dialog will have code and description input fields for adding a custom option. The order and visibility of these input fields depends on the display format of the field.


Note: Each custom option for a dynamic selector field must have a unique code value. If an option with the same code value already exists, the custom option will not be used.



Image and File Fields


Files, including images, are added to data form records using image, multi-image, and file fields. A button will be displayed in these fields that users can select to open the file dialog to add files to the data form.




At the bottom of the file dialog is a button for adding files. If the field type is file or multi-image, users will be able to add multiple files. After adding a file or image, a section in the dialog contains a thumbnail for the file, the file name, and two buttons—one for deleting the file and one for downloading the file.


The file/image field buttons display the number of files added to the field. The file names are displayed in a tooltip when a user hovers the mouse over the button.




Note: Only file types listed in the RT_FILE_TYPE table can be added in the file dialog.



Keyboard Shortcut Menu


Clicking the Keyboard icon on the widget header will open a menu with keyboard shortcuts.






The Grid Keyboard shortcuts are also listed below.

F2 – Enter edit mode

Esc – Exit edit mode

Delete – Delete cell content

Ctrl + Delete – Deleter selected row

Enter – Edit next row

Tab – Edit next cell

Shift + Tab – Edit previous cell

Ctrl + S – Save

Ctrl + C – Copy cell content

Ctrl + V – Paste cell content

Ctrl + Alt + C – Copy selected row

Ctrl + Alt + V – Paste copied row


The Drop-down Keyboard shortcuts are also listed below.

F2 – Open drop-down

Arrow Down – Move cursor down

Arrow Up – Move cursor up

Shift + Arrow Down – Select while moving cursor

Shift + Arrow Up – Select while moving cursor

Space – Multi-select: Select item at cursor

Delete – Clear all selections