Hello thunkers ,
i made a racing league app (i guees everyone in thunkable knows )
so the question is ,
only one part of my app has to be user specific .Or i need to change design , or my database .
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.
That’s OK. I gave you my opinion based on the information I have about your app and from my point of view, if you change to Firebase it means changing over 65% of your work and you will not solve the multiuser problem.
In the app of @unsalberkay1905cfbe the user selects a team / country and then the app will assimilate information in a sheet and display it using the Data Viewer List bound to the same data source (Google sheet). If in the same time another user selects a different team then one of the selections will overwrite the other.
Using the same app and same design nut changing the data source from Google sheet to Firebase will not give the multiuser effect unless the design and the method of accessing the data is changed which in turns effect most of the coding.
Firebase just like Airtable and Google sheet will be accessed by multiple users at the same time as long as the user does not make a selection that effects the data stored in the data source.
Hope this is clear that I’m referring to the specific case of @unsalberkay1905cfbe not in a general sense.