WallManager

Google Script to increment file with a certain structure

How it works

Introduction

The script is for personal use. It allows you to manually perform a file renaming in a certain directory with a pre-defined nomenclature. This script need to be on an attached Google Spreadsheet so that the activeSpreadsheet trigger correctly.

Setup Usage

Setup Global Vars

You will need to setup 4 global variables. To do that simply open the associated Spreadsheet and wait till the menu appear in the toolbar. Here you will find 4 menus with "Setup" in the name simply do them one by one.

• SheetName : this is the name of the sheet where you want the script to trigger. You can find the name on the tabs under the sheet.
• Folder : this is the folder that contains files that you want to manipulate. You can find the id in the URL when you are in this folder.
• Prefix : this is the repeated name that you want to use for your files. ([Wallpaper -] 0001)
• Format : this is the max files that you want in the folder. (this will only affect leading 0 in the name)

Things that might happens

• If you delete a row in the spreadsheet it might affects the integrity of the script.
• If you run the script without setting the global var, it might affects your folder.
• If you rename the files like Wallpaper - 0001 to Wallpaper - 0002, it might affects the integrity of the script.