I have created survey which populates a wix database. I have written some code to create a [sum] field within the database to total each participants score. When a survey is completed and the submit button is clicked, a lightbox appears showing, among other things, the total score for the participant. It works great when testing in the sandbox database because I can add the [sum] field to the schema. However, I cannot get the [sum] field added to the schema for the live database.
Is the live databse really that limited or is there a way to make this feature work as I have described above? Again, I'm looking to add the [sum] field to the schema in the live database so I may link it to a lightbox showing the score at the completeion of the survey.