Dynamic dashboard in the library homepage

This trick can help to create nice dynamic dashboards inside your AODocs library homepage based on the content of your library.

You may want, when opening a library, to have an overview of what's going on in it: how many documents, in which status they are, who is working on them.

image05.png

Here is what you need to do:

1) Prepare a view

In your AODocs library create a view with all the metadata you need to create your reports (you may want to hide the view from the navigation library).

image02.png

2) Prepare a spreadsheet

Create a spreadsheet and use the Google Sheet Add-On for AwesomeTable.

You can refer to the following documentation:  AODocs AwesomeTable connector for the details, but in the end you should have a spreadsheet like this:

image09.png

The interesting thing with the extension is that you can have these info automatically updated every hour, so don't forget to use the option "Activate sheet auto update":

 

3) Create report and charts

At this point you can create any chart you want based on the info in the spreadsheet.

I suggest to check the button image00.png in the lower right corner of your spreadsheet because it proposes nice charts.

image07.png

If you want automatic counts or calculations you may create a pivot tables and create charts out of it.

image06.png

I created 3 charts: 2 based on metadata and 1 based on the last editor of the documents (to see who is working on the library the most).

 

4) Publish your chart

Use the "Publish" option for a chart and remember to publish it as an IMAGE

image01.png

image03.png

5) Embed the picture in the AODocs library

For the rest, go back to the AODocs library configuration, and modify the Library description to include the images of the reports you just created, you can add the picture of the chart in the home page

image04.png

Consider that this picture is dynamic, so it will change every time your library content is updated and as often as the spreadsheet is updated by the Add-On (every hour).

8

Comments

0 comments

Please sign in to leave a comment.

Didn't find what you were looking for?

New post