Database Operations & Manipulations

Dear Bubblers,
I need your help.

I have 3 databases, please see below the format.

I want to do some operations on them and the result will be the last one (Database 4).
How can I achieve this? Do I need to pull out all the information and then find the average and then send the result back to the database?

Or is there any other more simple way to achieve this?

Thank you.

First of all, having the average in the database will probably be a pain in the ass. I would prefer to calculate the average live on the frontend.

To make this easier, I would use another database structure. Instead of having a table for each sport, have each sport as a field in the user data type.

So the user data type would the following fields:
Name, Football score, Hockey score, Tennis score.

Then you can do things like

(User’s Football score + User’s Hockey score + User’s Tennis score ) / 3, as an example.

1 Like

Thanks buddy, I’m gonna try this.

The problem is that I’m not very comfortable yet with work with bubble database. I still get confused at times.
Do you have a tutorial I can go through that talks more about advance database operations of bubble?