I wonder if this is something that can be automated. Working in Numbers I have to keep track of various metadata for cues including assigning new ISRC codes. What I do is this: Start a new Numbers Doc and fill in the metadata provided by the composers. I then have to open the last Numbers doc I finished (not necessarily the very last Numbers doc I opened), scroll to the bottom of the table and get the last ISRC code assigned. I either copy that number (or just remember it) and add that to the new doc but advancing it by one - so as not to duplicate the last number. Does this make sense?
What I would like is automation that would ask me to choose which document to pull from, look at the last ISRC column (which is always in the same column of the first table on the first sheet) copy that code (which is formatted like ABCYUD1801459), add one to the number, then put that new ISRC code into the new/open spreadsheet/table in the first cell. I can then fill down and be all set. It would be ok if it would just advance the number and copy it - then I could manually paste it in the cell I need.
This would save me the hassle of doing all this manually and I think it would be more accurate in the long run, not relying on my memory or forgetting to add one.
I used to keep all the collection is one large spreadsheet, but it got so big with so many columns, that is was hard to process just the rows I needed and it was clogging up my other Numbers formulas and automation stuff. And I have another AppleScript that needs the collections to be in their own spreadsheet, so I can’t go back to one large one.
What do you think is the best way to begin tackling this project?