Problem adding the value of two or more columns together

Get Help Database
1

Hello Adalo Community

I wondered if you are able to help me resolve an issue I am having with adding the value of two or more columns together.

Any advice you can give me would be greatly appreciated

Thank you in advance Sarah

Background:

I have a ‘Total Score’ column in my database (number field)

As the user clicks Yes or No to a question, a value of 1 or 0 is added to the question number field in the database.

Each question is on a separate screen and the action of clicking Yes or no includes updating the current database with the new value.

After 5 questions I should have a value of between 0 and 5 in the Total Score database column

I currently get a number in the Total Score but it is 41 which is not what I am looking for :frowning:

Images of project:
adalo image 1

adalo image 2
adalo image 21343×525 44 KB

adalo image 3
adalo image 31213×559 65 KB

2

@SarahB this should be done in a way that each questions update the score board

3

Hi @SarahB,

Firstly: where is the “+” sign between the 2 sums in the TOTALCUBEDSCORE field?
Then: I’m not sure the general logic is correct here. You can calculate total only after all scores are set (not in the same action). And also if you’re calculating the total for the row, no need to use sum(), you just need to put Q1SCORE + Q2SCORE + …

Best,
Victor.

4

Thanks for your help - ive managed to get the correct score now :slight_smile:

1 Like