Menu
News
All News
Dungeons & Dragons
Level Up: Advanced 5th Edition
Pathfinder
Starfinder
Warhammer
2d20 System
Year Zero Engine
Industry News
Reviews
Dragon Reflections
Columns
Weekly Digests
Weekly News Digest
Freebies, Sales & Bundles
RPG Print News
RPG Crowdfunding News
Game Content
ENterplanetary DimENsions
Mythological Figures
Opinion
Worlds of Design
Peregrine's Next
RPG Evolution
Other Columns
From the Freelancing Frontline
Monster ENcyclopedia
WotC/TSR Alumni Look Back
4 Hours w/RSD (Ryan Dancey)
The Road to 3E (Jonathan Tweet)
Greenwood's Realms (Ed Greenwood)
Drawmij's TSR (Jim Ward)
Community
Forums & Topics
Forum List
Latest Posts
Forum list
*Dungeons & Dragons
Level Up: Advanced 5th Edition
D&D Older Editions
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Chat/Discord
Resources
Wiki
Pages
Latest activity
Media
New media
New comments
Search media
Downloads
Latest reviews
Search resources
EN Publishing
Store
EN5ider
Adventures in ZEITGEIST
Awfully Cheerful Engine
What's OLD is NEW
Judge Dredd & The Worlds Of 2000AD
War of the Burning Sky
Level Up: Advanced 5E
Events & Releases
Upcoming Events
Private Events
Featured Events
Socials!
Twitch
YouTube
Facebook (EN Publishing)
Facebook (EN World)
Twitter
Instagram
TikTok
Podcast
Features
Top 5 RPGs Compiled Charts 2004-Present
Adventure Game Industry Market Research Summary (RPGs) V1.0
Ryan Dancey: Acquiring TSR
Q&A With Gary Gygax
D&D Rules FAQs
TSR, WotC, & Paizo: A Comparative History
D&D Pronunciation Guide
Million Dollar TTRPG Kickstarters
Tabletop RPG Podcast Hall of Fame
Eric Noah's Unofficial D&D 3rd Edition News
D&D in the Mainstream
D&D & RPG History
About Morrus
Log in
Register
What's new
Search
Search
Search titles only
By:
Forums & Topics
Forum List
Latest Posts
Forum list
*Dungeons & Dragons
Level Up: Advanced 5th Edition
D&D Older Editions
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Chat/Discord
Menu
Log in
Register
Install the app
Install
The
VOIDRUNNER'S CODEX
is coming! Explore new worlds, fight oppressive empires, fend off fearsome aliens, and wield deadly psionics with this comprehensive boxed set expansion for 5E and A5E!
Community
Playing the Game
Play by Post
Living Worlds
Living 4th Edition
Discussion: Shifting some load off the judges.
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="covaithe" data-source="post: 5574444" data-attributes="member: 46559"><p>Hmm. How's this: (thinking out loud here)</p><p></p><p>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).</p><p></p><p>[code]</p><p> Date Char Player Status1 Reviewer1 Status2 Reviewer2 Comments</p><p>---------------------------------------------------------------------------------------------</p><p> 6/1/2011 Noobicus Alice </p><p>[/code]</p><p></p><p>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: </p><p></p><p>[code]</p><p> Date Char Player Status1 Reviewer1 Status2 Reviewer2 Comments</p><p>---------------------------------------------------------------------------------------------</p><p> 6/1/2011 Noobicus Alice Needs work Barbara left comments on wiki</p><p>[/code]</p><p></p><p>3. Charlie has time to help, too. He looks at the spreadsheet, sees that Noobicus has some mistakes, and reviews someone else instead. </p><p></p><p>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: </p><p></p><p>[code]</p><p> Date Char Player Status1 Reviewer1 Status2 Reviewer2 Comments</p><p>---------------------------------------------------------------------------------------------</p><p> 6/1/2011 Noobicus Alice fixed Barbara left comments on wiki</p><p>[/code]</p><p></p><p>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:</p><p></p><p>[code]</p><p> Date Char Player Status1 Reviewer1 Status2 Reviewer2 Comments</p><p>---------------------------------------------------------------------------------------------</p><p> 6/1/2011 Noobicus Alice fixed Barbara Approved Charlie </p><p>[/code]</p><p></p><p>Or maybe this instead, might be better: </p><p></p><p>[code]</p><p> Date Char Player Status1 Reviewer1 Status2 Reviewer2 Comments</p><p>---------------------------------------------------------------------------------------------</p><p> 6/1/2011 Noobicus Alice Approved Charlie </p><p>[/code]</p><p></p><p>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:</p><p></p><p>[code]</p><p> Date Char Player Status1 Reviewer1 Status2 Reviewer2 Comments</p><p>---------------------------------------------------------------------------------------------</p><p> 6/1/2011 Noobicus Alice Approved Dan Approved Charlie </p><p>[/code]</p><p></p><p>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. </p><p></p><p>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:</p><p></p><p>[code]</p><p> Date Char Player Status1 Reviewer1 Status2 Reviewer2 Comments</p><p>---------------------------------------------------------------------------------------------</p><p>Ready for approval:</p><p> 6/1/2011 Noobicus Alice Approved Charlie </p><p> 6/6/2011 Testocles Bob Approved Dan </p><p> 6/9/2011 Aa'ia'la covaithe </p><p></p><p>Needs work:</p><p> 5/7/2011 Quagmire covaithe mistakes Charlie you're an idiot</p><p></p><p>Approved: </p><p> 1/1/1999 Lauto renau1g Approved covaithe Approved THB</p><p> 1/2/1999 ...</p><p>[/code]</p></blockquote><p></p>
[QUOTE="covaithe, post: 5574444, member: 46559"] 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). [code] Date Char Player Status1 Reviewer1 Status2 Reviewer2 Comments --------------------------------------------------------------------------------------------- 6/1/2011 Noobicus Alice [/code] 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 [/code] 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 [/code] 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 [/code] Or maybe this instead, might be better: [code] Date Char Player Status1 Reviewer1 Status2 Reviewer2 Comments --------------------------------------------------------------------------------------------- 6/1/2011 Noobicus Alice Approved Charlie [/code] 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 [/code] 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 ... [/code] [/QUOTE]
Insert quotes…
Verification
Post reply
Community
Playing the Game
Play by Post
Living Worlds
Living 4th Edition
Discussion: Shifting some load off the judges.
Top