# \[Solved\] User specific app (Database help ) **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** design\ **Created:** [November 23, 2021, 2:12pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565 "2021-11-23T14:12:56Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 23, 2021, 2:12pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/1 "2021-11-23T14:12:56Z")
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 . maybe can i use FireBase ? PS: basically i m drowning . ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [November 23, 2021, 2:54pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/2 "2021-11-23T14:54:53Z")
Firebase is the way to go! ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [November 23, 2021, 3:00pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/3 "2021-11-23T15:00:32Z")
Dear Berkay, 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. ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 23, 2021, 3:09pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/4 "2021-11-23T15:09:20Z")
sorry mr @muneer i know we discussed this , but i was kinda stuck thats why i post this thread ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [November 23, 2021, 3:12pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/5 "2021-11-23T15:12:38Z")
> [@unsalberkay1905cfbe](#): > > i know we discussed this 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. ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [November 23, 2021, 3:29pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/6 "2021-11-23T15:29:37Z")
Are you suggesting Firebase can’t be accessed by multiple users at the same time? Maybe I’m misunderstanding here. 😣 ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [November 23, 2021, 3:36pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/7 "2021-11-23T15:36:08Z")
> [@jared](#): > > Are you suggesting Firebase can’t be accessed by multiple users at the same time? 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. ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 24, 2021, 3:25pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/8 "2021-11-24T15:25:50Z")
This is so smart ,sorry for the late response (i’ve been dealing with funeral ) ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [November 24, 2021, 3:31pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/9 "2021-11-24T15:31:49Z")
> [@unsalberkay1905cfbe](#): > > i’ve been dealing with funeral Our condolences. ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 24, 2021, 3:39pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/10 "2021-11-24T15:39:59Z")
Thanks . ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 25, 2021, 4:13pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/11 "2021-11-25T16:13:17Z")
@muneer I created an excel (isnt that local table) , i can not connect ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [November 25, 2021, 4:39pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/12 "2021-11-25T16:39:50Z")
> [@unsalberkay1905cfbe](#): > > I created an excel Can you explain more? Thunkable can connect to: - Google sheet - Airtable - Local table The other database that Thunkable can connect to is **Firebase** but you will not be able to link it to a `Data Viewer`. ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 25, 2021, 4:45pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/13 "2021-11-25T16:45:36Z")
so you suggested me to create an local table , so i created an excel , (isnt excel a local table) but i guess this is not what u meant ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [November 25, 2021, 4:51pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/14 "2021-11-25T16:51:32Z")
If you can share an image of what you created so I can better understand. Sorry today my mind is acting slow. ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 25, 2021, 4:56pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/15 "2021-11-25T16:56:51Z")
> [@muneer](#): > > If you can share an image of what you created so I can better understand. Sorry today my mind is acting slow. i just copied my google sheet to local excel @muneer ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 26, 2021, 11:10am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/16 "2021-11-26T11:10:34Z")
@muneer how will i import my google sheet to local database? ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [November 26, 2021, 11:11am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/17 "2021-11-26T11:11:49Z")
No easy way, only by using codes and loop through the resords. ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 26, 2021, 1:17pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/18 "2021-11-26T13:17:30Z")
@muneer , is that whay you are saying , all those google sheet formulas needs te be done by using block codes and inputs? ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [November 26, 2021, 1:18pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/19 "2021-11-26T13:18:09Z")
> [@unsalberkay1905cfbe](#): > > needs te be done by using block codes and inputs? **YES** ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 26, 2021, 1:18pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/20 "2021-11-26T13:18:35Z")
oh shit , 🙃 so i will create 7 local DB s for my tables. i guess i will start with that what do you think 😃 or creating 22 screens for my app easier ? i think i ll change my design to yours [Next page](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565.md?page=2)