In post 22, Kison wrote:I believe there is an onSubmit event you can have trigger when a Google Form is submitted. You may be able to have it scan the sheet, determine whether a hammer already has been placed, and either block the submission or perform some additional write to the sheet in that event.
both of these work tooIn post 23, PeregrineV wrote:You could have a log that completes each time a vote occurs?In post 0, zoraster wrote:Major:
1. When the hammer is reached, the mod won't know about it if a vote is changed. The mod could go back and figure it out from the transcript, but this is designed to make life easier and be foolproof. Is there a google spreadsheet thing I can do to have a switch go if a certain value is reached that won't go back if the number goes down? In other words, I'd like Cell A1 (or whatever) to contain the # needed to lynch. IF Vote Total Cell is ever equal to or greater than A1, B1="Yes" EVEN IF Vote Total Cell is currently below A1.
https://docs.google.com/spreadsheets/d/ ... sp=sharing
Check the hammer condition each time a vote is placed.