Any database you connect with Thunkable project will have the same problem of not allowing multiuser operation. Firebase is quick but in the other hand it is a JSON structured database and not table formatted although you can use it to store table like data.
The other drawback of Firebase connection is that you cannot connect it to
Data Viewer List / Grid.
The best workaround for your situation is to create a Local Table with the same structure of your results table and whenever the user selects a team then you will do the following:
- Clear all data in the local tables
- Loop through the rows of the selected team and add them to the local table
With this method and with the local table bound to the data viewer, your user will have the data of the selected team / country without effecting any other user because local tables are created in the phone.
Hope this helps.