![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Updates to Scripts
Jan. 25th, 2018 02:02 pmSpreadsheet Template: https://docs.google.com/spreadsheets/d/195BZ1QPtTHjT_vvZzyolHFJSKq_Z9m-4RqRA2ZQz_JA/edit?usp=sharing
Updated the spreadsheet template so that (1) things are not dependant on the order of the columns and (2) there's some error handling so if you want to customize the sheet you're more able to do so.
The other major change, in order to allow more customization, the "hide/unhide columns" columns function which used to work of a predefined set of columns now takes an input.
So if you're hide column looked like:
The script would hide columns "E, H, I, and J" and unhide (if previously hidden) columns "L, M, N, O, P, Q, R, S, T".
Keep in mind: these two variables are allowed to compete over columns. So if in this example both "details" and "chapterInfo" had column "B" in there, details would hide the column but chapterInfo (since it runs after) would unhide it.
Updated the spreadsheet template so that (1) things are not dependant on the order of the columns and (2) there's some error handling so if you want to customize the sheet you're more able to do so.
The other major change, in order to allow more customization, the "hide/unhide columns" columns function which used to work of a predefined set of columns now takes an input.
So if you're hide column looked like:
| Hide |
| details |
| E, H, I, J |
| y |
| chapterInfo |
| L, M, N, O, P, Q, R, S, T |
| n |
The script would hide columns "E, H, I, and J" and unhide (if previously hidden) columns "L, M, N, O, P, Q, R, S, T".
Keep in mind: these two variables are allowed to compete over columns. So if in this example both "details" and "chapterInfo" had column "B" in there, details would hide the column but chapterInfo (since it runs after) would unhide it.