Library V2 (build2112a)

✨ New Features

• Added new features to Log Sheet by @chriskyfung in #22

  1. Save the filename of downloaded files in Column E in the "Logs" sheet

  2. Show the thumbnail preview and open the file on Drive by hovering and clicking on a hyperlinked filename.

     

  3. Delete multiple items and their corresponding files from Drive by selecting the checkboxes in Column F and then clicking on "Delete Selected" of log sheet page.

     

Full Changelog: lib-v1...lib-v2

---

🛟 Update Guide

How To Add The New Features To Your Existing Google Sheet File

To use the new version in your existing Google Sheet file, you need to update it by:

• making a new copy of our Google Sheet template, or

• following the below steps to manually update your Google Sheet file.

  1. Go to Logs sheet, add Saved Filename and Select to the cells E1 and F1 as the column headings, respectively.

  2. Select Insert > Drawing from the main menu.

  3. In the Drawing dialog, create a button-like shape with adding the text Delete Selected on it. Then, click Save and Close button.

  4. Move and scale the button drawing it to appropriate size and position.

  5. Select Extensions > Apps Script from the main menu to open the Apps Script Editor.

  6. Double-click IGStoriesToGDrive under the Libraries section in the left pane.

  7. Change the Version to 2 from the dropdown (as the picture below). Then, click Save.

     

  8. Add the following code to your Google Sheet's Apps Script:

     function deleteSelected() {
       const IGSF = IGStoriesToGDrive.getInstance();
       IGSF.deleteSelected();
     }

  9. Click the Save project icon to save the change.

  10. Go back to your Google Sheet file, right-click the button drawing and then select the three-dots ( ⋮ ) icon > Assign script.

  11. Enter deleteSelected (as the picture below). Then, click OK to close the dialog.

      

  12. Test the script by clicking the Delete Selected button. You should see a prompt like this:

      

  13. Click No to cancel running the script.