Hello I am wondering if anyone could help me finish this script because I am stuck.
So far I have made it so I can narrow down the sheets I want to renumber based on a Browser Org parameter. The SHEET.RENUMBERRENAME node needs a sheet input and I don’t know how to get the sheets from the Sheet numbers I get at the LIST.DROPITEMS node. I believe that if I feed the SHEET.RENUMBERRENAME node with the same amount of numbers and sheets that I get from the RANGE node, it will renumber them all but I might be mistaken. Thanks in advance for your help!
Hello @ADG,
It seems that you have correct names and number for your sheets. Whatever you do for your sheet number list, you can do the same for your sheet list to keep the correct sheet elements matching with your list.
After you sort the sheet number, you can use List.IndexOf and List.GetItemAtIndex node to reorder your sheet list and then use the same List.DropItems node for sheets as well.
It’s more a matter of if I were to add or delete sheets. I would want the script to renumber them, but right now the problem is I can’t seem to extract the sheets from their current numbers. Is there a way to do that?
aite im from this post. tbh i recommend splitting the addition/removal of sheets and renumbering into two separate scripts. they will be more self-contained and deterministic and more digestable. especially before u finish reading the primer. otherwise, u may get lost easily.
I am wondering if anyone could help me finish this script because I am stuck.