Calculate numeric value from text drop down field

[eddie_dodds]

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.

[anhelinak]

In order to calculate a sum of a few inputs and store them in a separate field you can add a beforeInsert() hook in which you will add your calculations.

You can find more information here:
https://www.wix.com/corvid/reference/wix-data.html#insert
https://support.wix.com/en/article/corvid-about-data-hooks
https://support.wix.com/en/article/corvid-tutorial-processing-user-input-before-it-is-stored-in-a-collection-with-data-hooks
https://www.wix.com/corvid/reference/wix-data.Hooks.html#beforeInsert

After the data is submitted you can use your calculated result and display it by using a “results” item that is returned from an insert() function.