I created a quiz on my site based on wix input fields. The information collected from these fields is stored in a database. This database through the hook after query I added calculates the questionnaire score and stores it in this database.
I was wondering if it would be possible to send this score to another database that would calculate the average points of all the quizes that a given user made.
Tomás Martins
Are the users quiz results all stored in the same dataset and within the same users row, so that they would all come under that users owners id?
If they are then surely you can just use code to add up each individual users totals and display them onto their own dynamic page, like their own profile page for example.
If not and they are stored in different datasets, then you will need to query all the datasets with the scores in for that particular user so that you can then add the totals up and show it on their own dynamic page, like their own profile page for example.
Thanks in advance for the answer.
But I still can’t solve the problem.
I have the results of the questionnaires stored in different databases and I don’t know how to make calculations between these values that are in different databases.