I have a simple collection with 9 fields. Each field comes from a drop down with the same 4 entries. I want to calculate a score from the submission, store in the collection, return an image and relevant text for that score following the form submission.
So each field has 4 options with the value I would like assigned as shown in brackets here. Drop down options
Not at all (0) Several days (1) More than half the days (2) Nearly everyday (3)
You can therefore get a score of between 0 and 27 with all fields mandatory and the person submitting would see the score, associated text and an image.
I am new to the database side so wondered if anyone could help.