The Lightning Tools’ Data Viewer App provides your Office 365™ users with the ability to see SharePoint® list content or external content data stored outside of SharePoint® within an easy to configure App Part. Users can add the App, and then within seconds configure a connection to data with the ability to select the columns that they wish to see, apply data formatting, conditional formatting, grouping, filtering, sorting and to build calculated columns.
Using the Lightning Tools’ Data Viewer App for Office 365™, users can easily configure views using the Display tab. Columns can be re-ordered, column Aliases set (FName = Firstname as an example), columns widths configured, along with sorting and grouping. Formatting options are then configured simply by setting properties such as Bold, Italic and Underline. Conditional Formatting can also be set individually on each column. Conditional formatting allows users to highlight important data such as Tasks that are due today or past due, Tasks assigned to you, Documents checked out to you, or products with a low stock level.
You can easily select columns from your data source to include within your view. With other products, columns need to be added by writing code such as XSLT or HTML. With the Lightning Data Viewer App, you simply select the column, re-order by dragging the column name up and down, and then also set filters using the filter icon on the right of the column. Filters can also span multiple columns, for example, Tasks Due Today AND Assigned to Brett Lonsdale.
To use the Data Viewer app within your Office 365™ tenancy complete the following steps:
- Install the Data Viewer app from the SharePoint Store, which installs a 14-day trial license.
- Add the app to a site.
- Add the Data Viewer App Part to a page.
- Configure the Data Viewer App Part.