2013-07-30, 11:33 PM
Double posting because I've made substantial progress and want people watching this thread to know there's something new to look at.
First, an update form.
Second, a viewable spreadsheet that updates on its own.
Basically the form lets you quickly enter a farm's monster info, the spreadsheet lets you view the accumulated info. I currently have it protected so only I can edit everything, unfortunately this causes the dumb looking stripes all over it.
The top right cell will let you pick the type of monster to display farm info for - it's a dropdown in Chrome, maybe other browsers - if it's not, just enter a name from the 'Details' spreadsheet.
If someone vandalises it I'll have to think about better ways to protect the form, right now it'll let anyone submit info and immediately list it.
L2 and A3 are the operative 'code' cells; if you want to duplicate this on your own you'll need to figure those out.
It'd be quite easy to paste other data into this or implement this for an existing table, I did it separately cause I wasn't certain it would work (and it does have a bit of a kludge). It'd probably be best to go with non-editable tables, I'm just lazy about copying the code 22 times. Can probably also retarget the form to enter another spreadsheet.
Hopefully the form is close to as easy to use as posting direct to this thread, if you have suggestions to make it more like the way you track farms then let me know.
First, an update form.
Second, a viewable spreadsheet that updates on its own.
Basically the form lets you quickly enter a farm's monster info, the spreadsheet lets you view the accumulated info. I currently have it protected so only I can edit everything, unfortunately this causes the dumb looking stripes all over it.
The top right cell will let you pick the type of monster to display farm info for - it's a dropdown in Chrome, maybe other browsers - if it's not, just enter a name from the 'Details' spreadsheet.
If someone vandalises it I'll have to think about better ways to protect the form, right now it'll let anyone submit info and immediately list it.
L2 and A3 are the operative 'code' cells; if you want to duplicate this on your own you'll need to figure those out.
It'd be quite easy to paste other data into this or implement this for an existing table, I did it separately cause I wasn't certain it would work (and it does have a bit of a kludge). It'd probably be best to go with non-editable tables, I'm just lazy about copying the code 22 times. Can probably also retarget the form to enter another spreadsheet.
Hopefully the form is close to as easy to use as posting direct to this thread, if you have suggestions to make it more like the way you track farms then let me know.