Double post. Sue me.
I finished the new script. I tested it. It worked perfectly Upon opening the spreadsheet, nothing happened. Upon editing the spreadsheet, I got the "IN USE" indicator and the "TESTING" menu. Yay, me.
Then I opened a different browser, where I am not logged in to Google, so I could test from andre's viewpoint. I got the "IN USE" indicator and nothing more. I have no idea why. There's nothing in the documentation that would explain why custom menus do not activate for non-logged-in users, or whether there's a solution. Perhaps that's because the peeps at Google are arrogant enough to assume that anyone using a Google Doc MUST want to sign in first. Why else would they be there? That's a REAL shame, too, because it means that Google has gone the way of Microsoft; they now assume that anyone who doesn't subscribe to anything Google obviously doesn't own a computer.
Until I can implement a different solution, here's how to make the TESTING menu appear if it doesn't appear automatically for you.
*writes temporary workaround*
*tests temporary workaround*
*workaround doesn't work, either*
*throws computer out of a 50th-storey window*
*buys new computer*
Okay, if you don't log in to Google, you're not going to see a TESTING menu. Period, stop, end of discussion. Ain't gonna happen. That means two things:
1) I need to create a completely different way for people to run the scripts that make this spreadsheet work. I already know what I'm going to do, but doing will be a "female canine".
2) If you don't have access to the TESTING menu, please test, anyway. Put your collected data in the yellow fields, anyway. Then find someone in Chat who has access to the TESTING menu and ask them to run the two scripts on your sheet. If you can't find anyone in chat, then just let it go. No one will touch your data with the "IN USE" indicator present, so just leave it there and add more to it during your next data entry session.
2a) Yes, I could ask people to post here, but then what if it takes a while for someone to see it, and the script gets run while you're in the middle of entering something? Answer: I'm not sure, but it could corrupt the data, so let's not take the chance. Either find someone in Chat, or leave it there until I figure out how I'm going to do this.