2013-09-02, 12:21 PM
Google Forms can't really get much more complicated than what I have, unfortunately. I wanted the mob entry to be more compact but this is pretty much the only layout it supports. I don't think they can write multiple lines to the spreadsheet either which makes it hard to accommodate variable lengths of input.
For myself the easiest way to do multiple entries is to copy the 'Spreadsheet Input' tab to a new document (just by selecting the top row and pasting it), and use spreadsheet tools to fill in the farm name and update time columns quickly. The downside of that is that the Monster Types need to match the names I used and there's no way to validate that automatically. So generally I just use the form multiple times.
I suppose I could make another spreadsheet that does the validation, which could be copied as a whole by anyone who wants to enter data that way.
For myself the easiest way to do multiple entries is to copy the 'Spreadsheet Input' tab to a new document (just by selecting the top row and pasting it), and use spreadsheet tools to fill in the farm name and update time columns quickly. The downside of that is that the Monster Types need to match the names I used and there's no way to validate that automatically. So generally I just use the form multiple times.
I suppose I could make another spreadsheet that does the validation, which could be copied as a whole by anyone who wants to enter data that way.