How to add calculated value into data collection after form submit?

Ask the community
,
1

For context, I have a form with multiple questions that have answers in the form of a 1-10 scale radio buttons. These answers are submitted into a data collection along with other user information.

I’d like to also add in another column in the data collection which would represent the average of the answers. How would I calculate the average of all the values of the checked radio buttons after submitting the form, and then adding that average to the same data collection?

2

Wix already have a code tutorial for a similar design, it should be good enough for what you are after and you can simply change the design to suit your own needs.
https://support.wix.com/en/article/corvid-tutorial-capturing-and-displaying-ratings