2013-07-31, 03:46 PM
MountLag Wrote:Is it possible to have an update form that allows multiple submissions at once? Preferably one that allows text submissions so I can copy paste from excel.
I don't feel like clicking for 44 different farms lul
As long as you use the same column headings as my 'Form Responses 1' I can paste results into that table manually - that's how I copied the Aliens and Humanoids group from Chilly's doc. Um. Either link to a google spreadsheet containing it, or I can give other people write access on the Responses table. The 'Timestamp' column is how I'm picking which is the most recent update, so it should be filled in with the time you checked the farms. (which reminds me, I should add a note on the Form saying it should only be used for Farms you've checked recently). If you leave it blank the query seems to assume it's the oldest result.
[MENTION=5248]Chilly[/MENTION]; 'Copy of Information' is actually sorting by the following columns: 1. is the median expiry date in the future (hidden column, but the information is replicated by colouring the expiry date green), 2. ranks, 3. expiry date again (to break ties). It's completely self-contained and ready for duplication - the only reason I haven't replaced 'Information' is that it's the sheet I'm actively editing, so I'm breaking it at various intervals. Come to think of it, I could offer one sorted by rank and another independent one sorted by whatever else is useful (quantity?)
[edit] done changing things for now so I reordered the tabs to put the nicer one at the start.
[MENTION=4093]SaptaZapta[/MENTION]; that looks pretty reasonable. (I would also make a table with a dropdown select that only displays one monster, since it's easy to code, but having that table around is sensible) This time I'm going to ask before implementing, though: What questions should the Specials form have? My thoughts are
| Farm Name | text input |
| Monster Type | dropdown (note you can type the name of the mob into these and it picks the one you mean) |
| Quantity | text input |
| Expiry Date | date |
Currently, to indicate a farm no longer has a type, just submit a form with the name, type, and all ranks blank. Not sure if there's a better way to handle that.