HomeGuidesRecipesAPI
HomeGuidesAPILog In
Guides
These docs are for v10. Click to read the latest docs for v31.

Data grid data source

1620

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 PageHow many rows will appear on each page of the data source.
Search AllChecking 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 TitleThis allows a designer to specify the column title.
SortableArrows will appear if sorting options if this is checked

Data grid options

OptionDescription
Grouping FieldGroups rows with the same data in the selected column.
Results Per PageSets the number of rows allowed in each page of the data source.
Show SearchEnables a Search Bar which lets you search for a specific row
Live RefreshEnables the data source to continually update itself

Note: Live Refresh applies to Dashboard projects only
Refresh PeriodThe 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 FilesLaunch Saved Answer
User: DocumentsDownload Document
User: Form ActivityLaunch Project; Launch History
User: Available FormsLaunch Project
User: Individual and Group TasksLaunch
User: Individual TasksLaunch
User: Group TasksLaunch
Admin: In Progress TasksLaunch

Possible Operations:

User: Answer FilesResubmit; Delete
User: DocumentsDelete
User: Form Activitynone
User: Available FormsReload the last answer
User: Individual and Group TasksUnlock; Reassign; Delete
User: Individual TasksUnlock; Reassign; Delete
User: Group TasksUnlock; Reassign; Delete
Admin: In Progress TasksUnlock; Reassign; Delete