# \[Solved\] User specific app (Database help )
**URL:** https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565
**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:** 2
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [November 26, 2021, 1:52pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/21 "2021-11-26T13:52:54Z")
I must say that I do not know enough details about your project. If I know I might be able to give you better advices on design.
---
### Author:  [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)
#### Post date: [November 26, 2021, 2:16pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/22 "2021-11-26T14:16:44Z")
What do you want to know sir 😃
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [November 26, 2021, 2:25pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/23 "2021-11-26T14:25:25Z")
Seems like each tournament needs its own “data sheet” right?
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [November 26, 2021, 3:47pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/24 "2021-11-26T15:47:29Z")
@unsalberkay1905cfbe
I just created a tutorial post.
Please check.
> [@Filter Google sheet Data and show the result in a DVL](https://community.thunkable.com/t/filter-google-sheet-data-and-show-the-result-in-a-dvl/1635841):
>
> Just wanted to share this trick to filter data in a DVL For Example, if I have a sheet with numbers and names then I need to add another column to be the condition to filter by [image] In this example I have a number column and a name column and the 3rd is the search column. In a separate sheet have the same two column headings [image] In the row immediately below the heading of the first column, enter this function =filter(Sheet1!A2:B7,Sheet1!A2:A7=Sheet1!C2) [image] Now in Thunkable, …
This might not be the solution to your issue here but it is something good to know.
---
### Author:  [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)
#### Post date: [November 26, 2021, 4:38pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/25 "2021-11-26T16:38:19Z")
yes , trying to solve that
---
### Author:  [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)
#### Post date: [November 26, 2021, 4:38pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/26 "2021-11-26T16:38:42Z")
it might help, but i have lots of data
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [November 26, 2021, 4:51pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/27 "2021-11-26T16:51:13Z")
In my mind the easiest or maybe not easiest but most effective thing to do would be to create the table in Firebase. This would allow you to have an unlimited number of virtual tables so to speak.
On the technical side, a table is just a collection of objects. It’s a list of objects that is nicely formatted to look like a table. So, one way to store the data would be to save lists of objects in a bucket that is specific to that tournament
Like this.
- Main DB
– Tournament1
You could expand infinitely and recall only the relevant tournament data this way. It would return in a Json format and easily be worked with to create other visual structures.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [November 26, 2021, 5:13pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/28 "2021-11-26T17:13:11Z")
As far as my understanding of the work of @unsalberkay1905cfbe , he is relying on Google sheet to do a lot of data manipulation and calculation. To change to Firebase he would gain the speed but he has to manage the calculations inside the app.
This is a choice he would need to make.
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [November 26, 2021, 5:16pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/29 "2021-11-26T17:16:05Z")
So many ways to accomplish the same task! 😂 😭
It can be hard to figure out what’s best sometimes. My go-to is always a lowCode approach but I also try to empathize that my lowCode solutions aren’t workable for all Thunkers.
---
### Author:  [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)
#### Post date: [November 26, 2021, 5:16pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/30 "2021-11-26T17:16:40Z")
> [@muneer](#):
>
> e he would need to make.
Actually i m looking for easiest way , i really dont want to make 21 screens for all those race inputs .
Actually local DB really works for me , but its really painful for me. isnt there a way to import my sheet to localDB, I know i ve been
---
### Author:  [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)
#### Post date: [November 26, 2021, 5:37pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/31 "2021-11-26T17:37:43Z")
i wish i have enough knowledge to make one of these things. 😃
---
### Author:  [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)
#### Post date: [November 26, 2021, 6:04pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/32 "2021-11-26T18:04:55Z")
@muneer my sheet uses vlookup at sel tab , but your vlookup does it inside the app right?
if that so your design is brilliant
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [November 27, 2021, 4:09am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/33 "2021-11-27T04:09:18Z")
> [@unsalberkay1905cfbe](#):
>
> your vlookup does it inside the app right?
No. I’m using Google sheet to do it.
---
### Author:  [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)
#### Post date: [November 27, 2021, 6:59am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/34 "2021-11-27T06:59:06Z")
Oh this might work out for me .
And you get text input , is it doable with grid?
And actually all i need to do is changing my google sheet system right? @muneer
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [November 27, 2021, 9:31am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/35 "2021-11-27T09:31:57Z")
> [@unsalberkay1905cfbe](#):
>
> is it doable with grid?
Yes, it is.
---
### Author:  [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)
#### Post date: [November 27, 2021, 2:22pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/36 "2021-11-27T14:22:21Z")
but @muneer arent we do the same thing ,
your app writes google sheet with text input , mine does it with data viewer grid , in my app when user presses item in grid viewer it writes down to google sheet. And i list those with index.
At sel tab
when you click an item on DVG, you change A2 , and i get the number of that race. Then i list those specific inputs at res tab… basically my row 2 is your WhattoSearch column
---
### Author:  [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)
#### Post date: [November 27, 2021, 9:13pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/37 "2021-11-27T21:13:36Z")
instead of all these stuff , what if i create 21 screens per race with DVL , and i just list them ?
will that slow the app? @muneer
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [November 28, 2021, 6:04am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/38 "2021-11-28T06:04:12Z")
you’re wondering about 21 screens - i have simulated it with 4 screens so you get an idea.
i do not guarantee that it will resolve your issue with multiple users but this time, there are no more
“live” computes based on user entry. all screens are computed one time, at the time you apply changes to the **qual** and **pen** tabs.
i still have the original model i sent you earlier so i modified it with these changes:
1. got rid of the **race** tab and put it in a local table called race\_table (containing race\_name, race\_num & photo)
2. i removed the **sel** tab. when you select a race from the grid view, it stores the name and number in variables. and you get transferred to the screen named “Res#” where # is the race number
3. since my example had 4 races, i made 4 screens Res1…Res4
4. check the attached google sheet and look at Res1, the number of the race is stored in the header line but it will be used in the formulas in all the rows. this way, Res2…Res4 are copies of Res1. no need to change formulas. just make sure the correct race number is coded in the heading line (see cell G1 and the formula in C2).
i hope it works for you.
here is the google sheet i’m using:
> **[races1](https://docs.google.com/spreadsheets/d/1KByMVRIQ2B3tiq4JCT_Rj_dU7SaBEd_MNZqPljPH0J4/edit?usp=sharing)**
>
> qual
>
> driver,team,r01pos,r01rating,r02pos,r02rating,r02pos,r03rating,r03pos,r03rating
> Raymond Craig,Renault,639,38,277,68,207,62,291,79
> Hywel Allen,Ferrari,645,67,517,62,427,60,203,34
> Avni Byers,Mercedes,663,26,320,90,531,71,222,70
> Josef...
make a copy of it and install as **races1** in your google drive BEFORE you open the thunkable link.
here’s the project link: do not open until you have a copy of races1 in your google drive.
[https://x.thunkable.com/copy/dc3213be7b5fc6b318392c39f073a004](https://x.thunkable.com/copy/dc3213be7b5fc6b318392c39f073a004)
---
### Author:  [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)
#### Post date: [November 28, 2021, 9:12am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/39 "2021-11-28T09:12:51Z")
looks good , this will help thanks @muneer and @manyone , i will keep you posted
---
### Author:  [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)
#### Post date: [November 28, 2021, 10:17am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/40 "2021-11-28T10:17:53Z")
normally i change 0’s to dnf with this formula =IF(index(qual!C1:L21,row(A2),(sel!$B$2))=0,“DNF”,index(qual!C1:L21,row(A2),(sel!$B$2))) , but since there is no sel tab how can i convert , @manyone
[Previous page](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565.md?page=1)
[Next page](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565.md?page=3)