Data grid data source

Data source appearance

Designers can select a display type of Data Grid for a data source. This display type is similar to a search question type with additional options such as pagination, sorting, search and a formula display fields.

 
If you have Data Grid display type you will be presented with the following additional options on the data source panel:

Selection type of (None)	This behaves like an uneditable data source, it is not possible to select a row.
Results Per Page	How many rows will appear on each page of the data source.
Search All	Checking this option enables a search text box to appear above the data grid.

Display fields for a data grid also come with additional options:

Display field 'Formula'	This allows a designer to enter a formula which will resolve per row of the data source. This is potentially slow as it is not cached in any way and is done after data has been fetched if you have a lot of rows and a complex formula it could take a long time.
Column Title	This allows a designer to specify the column title.
Sortable	Arrows will appear if sorting options if this is checked

Data grid options

Option	Description
Grouping Field	Groups rows with the same data in the selected column.
Results Per Page	Sets the number of rows allowed in each page of the data source.
Show Search	Enables a Search Bar which lets you search for a specific row
Live Refresh	Enables the data source to continually update itself Note: Live Refresh applies to Dashboard projects only
Refresh Period	The timer in second before the data source refreshes itself

📘

Note

DataGrids are not supported on Offline apps

Data grid operations

Operations such as (delete, reassign, unlock etc) and links (open, view history, load last answer etc) are available in Infiniti Dashboard Projects when using an Infiniti Data source with the Datagrid display type.

 

• In the Display Fields for a data grid of the right type two additional fields will appear
  ⋅⋅ Link - this is a drop-down with only a couple of options (eg: Launch Project, Launch History etc) that vary from the data object to data object. Adding a Link to a display field will cause a link to that behavior to appear on the display field when the data grid appears in Produce. 
  ⋅⋅ Operations Dropdown - this is a checkbox which when selected causes a dropdown to appear in the selected display field column of the data grid in Produce. The drop-down only appears if there is an operation available on that line of the data object, and only available operations will appear - possible operations include Delete, Reassign, Unlock etc.
• The appropriate selections must be made when adding or updating the Display Field item. If Links are available a column will appear to show which Display Field the link is attached to and which Link is attached.
• These options are only available for relevant data grids when the project type is Dashboard. These data grids and data sources can be used in Content project types, but the Links and Operations options will not appear.
• Links will appear on the text of any field of a Dashboard project data grid that has had a link type selected.
• When the link is clicked, the back button will return the user to the Dashboard project they came from
• Links may not appear if the current user does not have permission to link to that list item (eg: it is locked by another user etc)
• Operations appear as a drop-down in the selected field/column of any Dashboard project data grid that has had Operations Dropdown checked
• The form designer can't control what items appear in the Operations drop-down. Depending on the data object type the operations may vary - see the list below
• For User type data objects, the operations that appear are only those the current user can perform on the listed items. 
  *For Admin type data objects, all possible operations will appear but will not execute if the current user does not have permissions to perform those operations.

 
Possible Links:

User: Answer Files	Launch Saved Answer
User: Documents	Download Document
User: Form Activity	Launch Project; Launch History
User: Available Forms	Launch Project
User: Individual and Group Tasks	Launch
User: Individual Tasks	Launch
User: Group Tasks	Launch
Admin: In Progress Tasks	Launch

Possible Operations:

User: Answer Files	Resubmit; Delete
User: Documents	Delete
User: Form Activity	none
User: Available Forms	Reload the last answer
User: Individual and Group Tasks	Unlock; Reassign; Delete
User: Individual Tasks	Unlock; Reassign; Delete
User: Group Tasks	Unlock; Reassign; Delete
Admin: In Progress Tasks	Unlock; Reassign; Delete