Skip to content

Latest commit

 

History

History
24 lines (16 loc) · 1.37 KB

README.md

File metadata and controls

24 lines (16 loc) · 1.37 KB
Raw

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.