Crow Canyon List View advanced settings

Applies to: NITRO for SharePoint Online and On-premises

Description

Crow Canyon List View is a NITRO component that provides enhanced capabilities to view SharePoint list items. It also provides a host of features to do operations on listed items. This articles lists the advanced features of this component for use in various business applications.

 

Detailed Description

Delay loading of items

Enabling this option will delay the loading of items in List View web part in page. This will increase the performance of a page in case of multiple web parts exists in a page.

Load after

Items will load automatically after the specified time in the list view web part. User can also use “Click to load items” link to load the items manually.

User initiated

Items will not load automatically in the list view web part, we need to click “Click to load items” link to load the items.

Hide Export to Excel Button

Use this option to hide the “Export to Excel” button from the List View web part.

Column Width JSON

To have specific width for columns in the List View grid, specify the column internal name along with width in pixels in JSON format.

Ex:
{
"LinkTitle": {
"width": 150
},
"Title": {
"width": 150
},
"ID": {
"width": 80
}
}

Note: Specify column internal names and not the display names of the columns in the JSON

 

Extended Settings JSON

Example configuration:

{
"Export" : {
"AllowedGroups" : ["NITRO Members", "NITRO Owners"],
"ColumnsToExport" : ["AssetID","Title","AssetCategory"],
"ExcludeColumns" : ["LinkTitle"]
}
}

Export to Excel feature customization

Currently, extended JSON settings can be used for customizing the Excel to Export feature. Please follow the above format, details are given below:

AllowedGroups

“Export to Excel” button will be visible only for the users in SharePoint groups specified in this node. Multiple groups can be specified and if logged-in user is not in any of these groups then button will be hidden. This settings is optional, if it is not specified then all users will see the button. Also refer NITRO Site Settings for site level permissions for Export to Excel feature.

As per the above sample configuration, “Export to Excel” button will be visible only for the users in “NITRO Owners” and “NITRO Members” groups.

Columns included in the exported data

By default all columns present in the selected view are exported. If advanced settings are specified then below rules are applied:

  1. Column has to be present in the selected view
  2. If ”ColumnsToExport” node is present, then only those columns that are specified in this node will be exported
  3. If “ExcludeColumns” node is present, then columns specified in this node will be excluded

As per the above sample configuration, “AssetID”, “Title” and “AssetCategory” columns will be exported provided they are present in the view. “LinkTitle” column will be excluded from the export even if it is present in the selected view.

Note: We need to use the internal name of the column in Extended Settings JSON.

List View Example