2013-07-31, 03:59 AM
[MENTION=4093]SaptaZapta[/MENTION];
Any non-owners who want to sort by other columns can simply make a copy of the spreadsheet. The copy will be saved on their own account with full privileges.
Chilly can also use this method to save a backup copy periodically to use if a user with permissions deletes everything.
[MENTION=5248]Chilly[/MENTION];
I've got a lot of experience with google docs from creating my BM damage calculator. If you need any help implementing ideas give me a shout.
Possible solutions:
1. Individuals updating only their own farms
User permissions can be defined on a per page basis. You can create a page for a specific farm or group of farms that can be edited by the owner and then displayed in the general farm pages. There should be a way to hide these sheets from non-owners as well, but this may clutter things up for you as the owner of everything. It also means a lot of set-up work for you, but I don't know of any other ways of implementing this with sufficient protection from general editing.
2. Special (parents)
There's really only two options for this. Either a separate sheet or separate columns. I definitely favor the former.
3. Indicating trustworthy farms
You can use conditional formatting to change the color of farm names based on the update date. This would make it pretty obvious for users to quickly find accurate information.
4. Backup in case of emergency
Simple save a private copy of the entire spreadsheet periodically (I wish there was a way to automate this).
Any non-owners who want to sort by other columns can simply make a copy of the spreadsheet. The copy will be saved on their own account with full privileges.
Chilly can also use this method to save a backup copy periodically to use if a user with permissions deletes everything.
[MENTION=5248]Chilly[/MENTION];
I've got a lot of experience with google docs from creating my BM damage calculator. If you need any help implementing ideas give me a shout.
Possible solutions:
1. Individuals updating only their own farms
User permissions can be defined on a per page basis. You can create a page for a specific farm or group of farms that can be edited by the owner and then displayed in the general farm pages. There should be a way to hide these sheets from non-owners as well, but this may clutter things up for you as the owner of everything. It also means a lot of set-up work for you, but I don't know of any other ways of implementing this with sufficient protection from general editing.
2. Special (parents)
There's really only two options for this. Either a separate sheet or separate columns. I definitely favor the former.
3. Indicating trustworthy farms
You can use conditional formatting to change the color of farm names based on the update date. This would make it pretty obvious for users to quickly find accurate information.
4. Backup in case of emergency
Simple save a private copy of the entire spreadsheet periodically (I wish there was a way to automate this).