Aptorian, on 15 June 2020 - 11:42 AM, said:
Good idea to keep your own back-up's of the Excel ark but if this is your standard cloud based setup, you should be able to go back to older versions of the document using history. You can even keep track of who has accessed it the past days, weeks, months and pinpoint who the idiot is who accidentally overwrote two hundred entries with the word "hdqřćlo".
I also don't know about the sheet, but theres ways of restricting how data gets entered into the sheets. You can force it to only accept "YES" or "No" as opposed to YES Yes No NO YEs YES(space) no(Tab) etc........
Gorefest, on 15 June 2020 - 05:49 PM, said:
Aptorian, on 15 June 2020 - 11:42 AM, said:
Good idea to keep your own back-up's of the Excel ark but if this is your standard cloud based setup, you should be able to go back to older versions of the document using history. You can even keep track of who has accessed it the past days, weeks, months and pinpoint who the idiot is who accidentally overwrote two hundred entries with the word "hdqřćlo".
True, we stuck it on Google drive so there is a solid version history and rollback option in place. But better safe than sorry. But that was our own initiative, not Oxford instructions. I dunno, it all seems very wobbly. Then again, all the info is kept in 5-6 fold, with both paper copies and online spreadsheets, so everything is retraceable from volunteer to freezer tube. The user-friendliness is about 1 out of 10, though😁
buddy from experience, depending on how many people are there, accessing a version of a spreadsheet that is 6 months old could outright crash google chrome. We had that issue at work.
This post has been edited by LinearPhilosopher: 15 June 2020 - 11:21 PM