Sum all value in multiple database fields

Ask the community
,
6

Ok, what you have to do is remove the columns no1q … and add 3 numeric ones, let’s say you want to call them responseD, responseI, responseS, responseC.

now let’s pretend that the user answers S to the first question, the code will be this:

wixData.query('DISC')
                    .eq('name', varWithTheName) //better to use the id
                    .limit(1)
                    .find()
                    .then((returns) => {
 let item = returns.items[0];
                        item.responseS = item.responseS + 1;
                        wixData.update('DISC', item)

this is used to update the data already existing in the collection, so when the user answers row is created you must assign a default value of 0 to all answers.
So maybe you can make an ‘enter name’ field and a start test button that creates the row when pressed.

Also I recommend that you put this code in the backend of the site so as not to overload the client

or you create numeric variables that are updated at each answer and the data is saved at the last answer