covaithe
Explorer
Hmm. How's this: (thinking out loud here)
1. Alice fills out the form to submit her new level 1 character, Noobicus Maximus. Yay! Nobody gets emailed. Noobicus gets added the the spreadsheet, which looks like this (it can have more columns, but these are the ones I want to see as part of the workflow).
2. Barbara has some free time and wants to review characters. She goes to look at the spreadsheet. She clicks on Noobicus' link. She finds some mistakes and makes some comments on the wiki page (which causes Alice to get an email). She marks Noobicus as "not approved" and puts her name down as reviewer 1, and explains why:
3. Charlie has time to help, too. He looks at the spreadsheet, sees that Noobicus has some mistakes, and reviews someone else instead.
4. Alice gets the email, and fixes the mistakes. Somehow she edits the spreadsheet. (I don't like this much; is there a way to do it with forms? I'd prefer if players didn't have to directly edit the spreadsheet, only reviewers.) It looks something like this:
5. Charlie looks at the spreadsheet, sees that Noobicus has fixed the mistakes, and looks him over and decides to approve him. He comments on the wiki (and Alice gets emailed) and edits the spreadsheet, thus:
Or maybe this instead, might be better:
6. Dan comes to review characters too, sees that Noobicus is ready, and approves him. He comments on the wiki (so Alice is emailed), moves Noobicus into the Approved Characters category, and edits the spreadsheet:
I think something like that would work as a workflow, if we can sort out step 4. I'd prefer to avoid a situation where every player has to have a google account to edit the spreadsheet. That could become chaos in a hurry.
Is it possible to do clever things with this spreadsheet, like filter it to hide rows where both statuses are approved, or sort and separate it in nontrivial ways, like this:
1. Alice fills out the form to submit her new level 1 character, Noobicus Maximus. Yay! Nobody gets emailed. Noobicus gets added the the spreadsheet, which looks like this (it can have more columns, but these are the ones I want to see as part of the workflow).
Code:
Date Char Player Status1 Reviewer1 Status2 Reviewer2 Comments
---------------------------------------------------------------------------------------------
6/1/2011 Noobicus Alice
2. Barbara has some free time and wants to review characters. She goes to look at the spreadsheet. She clicks on Noobicus' link. She finds some mistakes and makes some comments on the wiki page (which causes Alice to get an email). She marks Noobicus as "not approved" and puts her name down as reviewer 1, and explains why:
Code:
Date Char Player Status1 Reviewer1 Status2 Reviewer2 Comments
---------------------------------------------------------------------------------------------
6/1/2011 Noobicus Alice Needs work Barbara left comments on wiki
3. Charlie has time to help, too. He looks at the spreadsheet, sees that Noobicus has some mistakes, and reviews someone else instead.
4. Alice gets the email, and fixes the mistakes. Somehow she edits the spreadsheet. (I don't like this much; is there a way to do it with forms? I'd prefer if players didn't have to directly edit the spreadsheet, only reviewers.) It looks something like this:
Code:
Date Char Player Status1 Reviewer1 Status2 Reviewer2 Comments
---------------------------------------------------------------------------------------------
6/1/2011 Noobicus Alice fixed Barbara left comments on wiki
5. Charlie looks at the spreadsheet, sees that Noobicus has fixed the mistakes, and looks him over and decides to approve him. He comments on the wiki (and Alice gets emailed) and edits the spreadsheet, thus:
Code:
Date Char Player Status1 Reviewer1 Status2 Reviewer2 Comments
---------------------------------------------------------------------------------------------
6/1/2011 Noobicus Alice fixed Barbara Approved Charlie
Or maybe this instead, might be better:
Code:
Date Char Player Status1 Reviewer1 Status2 Reviewer2 Comments
---------------------------------------------------------------------------------------------
6/1/2011 Noobicus Alice Approved Charlie
6. Dan comes to review characters too, sees that Noobicus is ready, and approves him. He comments on the wiki (so Alice is emailed), moves Noobicus into the Approved Characters category, and edits the spreadsheet:
Code:
Date Char Player Status1 Reviewer1 Status2 Reviewer2 Comments
---------------------------------------------------------------------------------------------
6/1/2011 Noobicus Alice Approved Dan Approved Charlie
I think something like that would work as a workflow, if we can sort out step 4. I'd prefer to avoid a situation where every player has to have a google account to edit the spreadsheet. That could become chaos in a hurry.
Is it possible to do clever things with this spreadsheet, like filter it to hide rows where both statuses are approved, or sort and separate it in nontrivial ways, like this:
Code:
Date Char Player Status1 Reviewer1 Status2 Reviewer2 Comments
---------------------------------------------------------------------------------------------
Ready for approval:
6/1/2011 Noobicus Alice Approved Charlie
6/6/2011 Testocles Bob Approved Dan
6/9/2011 Aa'ia'la covaithe
Needs work:
5/7/2011 Quagmire covaithe mistakes Charlie you're an idiot
Approved:
1/1/1999 Lauto renau1g Approved covaithe Approved THB
1/2/1999 ...