Use the Files Cabinet add-on to effortlessly update your datasource and view.
In the previous tutorial, you learned how to run the Files Cabinet add-on to create a dynamic view of your target folder’s contents. Now, you will learn how to update or refresh the same datasource and view using two methods detailed below.
Let’s say you or members of your team* added (or deleted) files from your specified Files Cabinet folder (or subfolder). How will you display the updated contents to your view or website? With the Files Cabinet add-on, updating your datasource and view is quick and easy.
Automatic Hourly Updates
To activate the automatic hourly updates for each Files Cabinet created using the previous version of the add-on, you need to run the new version once. To do this, follow the procedure below on how to perform manual updates.
Perform Manual Updates
For instances where your newly added files need to be published immediately (and waiting for the hourly update isn't an option), you can perform a manual update on the specified directory.
1.) To update your Files Cabinet within Google Sheets, select Add-ons > Files Cabinet by Awesome Table > Start Listing.
2.) Click the Update list of files button (image below).
3.) Click the Open button to see your updated view (this will open the same view generated earlier in Step 7 in the previous tutorial).
* Note that there are now 29 files.
You’ve just learned how to use the Files Cabinet add-on to:
- display Google Drive contents and how to
- update your datasource and view with just 1 click of a button.