Enable multiple Reviewers to add comments to a submission

[anthrope communications]

Hi there. Thank you for creating such a great tool! I am a newbie to FormTools - but love the abilities it provides without significant PHP/MySQL knowledge.

THE PROJECT: I created a website for non-profit organization. Constituents can submit presentation proposals for an upcoming conference though a form on the site. I set all of that up through FT - and it works like a charm!
Part two of the process is that 10 reviewers need to be able to review each submission, add comments/grades to each submission, and then save their comments into the DB (attached to the submission).

MY APPROACH:
• I set the reviewer's up as CLIENTS.
• I added FIELDS to the form/database for the reviewers to add their input.
• Within FT I created a VIEW that show the submission + the reviewer's fields.
- It looks great. Challenge is that I realized that each time a a reviewer adds their input, the last reviewer's info get's overwritten.

THE QUESTION:
Is there a way to enable multiple reviewers to can ad their comments - without each new reviewer overwriting that last one's input? - perhaps have the complete form save out as a new submission when the reviewer hits "update."

Thanks for any help!
Chris

[Ben]

Hi Chris,

Cool! Glad it's worked out so far.

So does each reviewer delete the previous comments before adding their own? Assuming they're sharing the same field, they should always see all reviews made up to that point. If they *are* deleting the old comments, you may need to add separate comments for each reviewer - since there are only 10, that might not actually be so bad...

If it's a problem that the comments would then be in multiple locations, you could look into the Submission Pre-Parser module to automatically update a single field ("all comments") in your database with comments made by all users. Let me know if you need any pointers on this bit.

All the best!

- Ben