I am trying to setup a framework to evaluate certain products and rank them on different properties.
I have used “Bouncing Balls” as an example in this post.
There are certain parameters that can be objectively measured, and certain parameters that can only be determined through subjective data gathering.
As an administrator of the evaluation, I or one of my colleagues would add each new product into the evaluation framework and insert the objective data.
After that, we would let a focus group of individual participants (somewhere between 5-30 participants per product) evaluate the product, under more-or-less controlled circumstances.
The participants will be handed the product, follow a guided method for evaluation, and use some type of form sheet to fill in a subjective value for each parameter.
Eventually, there could be around 30-40 products that have been evaluated and ranked against each other.
Some participants will evaluate most products, but many participants will just evaluate a couple of products.
I would really like to be able to use Coda for this, but I am not sure if it can suit my needs.
I know there are a lot of really smart people in this community so I would be very glad to hear your thoughts on this project!
I have shared a rough draft of how a picture the document at the moment:
To start with, I have a few concrete questions:
What formula should I use on the “Average Participant TOTAL SCORE”, in order to get an average value from all participants per Ball Model?
How to get participants to fill in the data for each Ball model without being able to edit the table?
Has anybody tried to connect Google Forms or Formtyper for something like this?
I saw that it is possible to use Buttons to create a kind of Form, but if I understand correctly the participants will either need to be logged in or they will not be able to save the data (I think).
I would like the form to dynamically load the products (as a multi-choice for the participant), otherwise there is a risk that the participant will use different spellings.
But I think that connecting Google Forms or Formtyper via Zapier is only a one-way communication to feed data into Coda, and not vice versa.
If the Participants cannot use Coda directly (but via a third-party form), then Coda is just used as a database.
Would it be useful to use Coda for this, or do you know any other solution that could fit me better?
Thank you for reading down to here, and I would appreciate any help I can get!