# \[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:** 3
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [November 28, 2021, 10:54am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/41 "2021-11-28T10:54:39Z")
where is your formula located? in what tab?
just replace sel!$B$2 with $G$1
when sel was present, sel!$B$2 was just the race number. but if you code the race number on G1 (as in my example), you just refer to it there.
---
### Author:  [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)
#### Post date: [November 28, 2021, 11:01am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/42 "2021-11-28T11:01:14Z")
> **[YABANCI LİG](https://docs.google.com/spreadsheets/d/1LAf0OycXAJOXSAQEQZRLRyIWw_YpwQmpOR1gPKfrEHY/edit?usp=sharing)**
>
> qual
>
> Driver,Team,Bahrain,Italy - Imola,Portugal,Spain,Monaco,Azerbaijan,France,Austria,Great Britain,Hungary
> Carlos Sainz,Scuderia Ferrari,6,16,2,4,5,3,15,7,0,3
> Charles Leclerc,Scuderia Ferrari,18,20,11,14,12,12,11,11,12,13
> Max Verstappen,Redbull...
res tab c,d,e,f,g columns and till row 21
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [November 28, 2021, 11:03am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/43 "2021-11-28T11:03:49Z")
Just a suggestion @manyone, @unsalberkay1905cfbe ,
If you can compile all results in one single sheet and add a column to the selection which is repeated in every row then easily implement this to hide all rows not complying with user selection.
So when user selects group 1 only rows with the group column equals to **1** will be visible and the other rows will be hidden.
This simplifies the sheet design.
---
### Author:  [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)
#### Post date: [November 28, 2021, 11:12am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/44 "2021-11-28T11:12:55Z")
> [@muneer](#):
>
> If you can compile all results in one single sheet
to do that i need to sort this function aswell
=IF(index(qual!C1:L21,row(A2),(sel!$B$2))=0,“DNF”,index(qual!C1:L21,row(A2),(sel!$B$2)))
and i have to sort these by quali pos and race pos , so i will have lots of columns in 1 sheet
you can check out my sheet [https://docs.google.com/spreadsheets/d/1LAf0OycXAJOXSAQEQZRLRyIWw\_YpwQmpOR1gPKfrEHY/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1LAf0OycXAJOXSAQEQZRLRyIWw_YpwQmpOR1gPKfrEHY/edit?usp=sharing)
all this stuff goes on at res tab
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [November 28, 2021, 11:19am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/45 "2021-11-28T11:19:17Z")
i hope you are working with a different copy of the project and different copy of the sheet.
try this first. rename res to res1, type the value of 1 in cell M1
then change all formulas such that sel!$b$2 becomes $M$1
then make a copy of res1 and call it res2. in thunkable, replace your screen res with res1 and create a copy of it and call it res2.
did you try to work with the model i gave? in this model, there is no update on any cell in the sheet.
---
### Author:  [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)
#### Post date: [November 28, 2021, 11:26am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/46 "2021-11-28T11:26:43Z")
> [@manyone](#):
>
> rename res to res1, type the value of 1 in cell M1
you mean formula?
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [November 28, 2021, 3:18pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/47 "2021-11-28T15:18:41Z")
In the sheet, rename the tab res to res1. In cell m1, enter 1 (ie. The race number). Then duplicate the sheet and rename it to res2, plus change the value of m1 to 2., repeat 20 more times. ( for testing you can create up to 5).
At the same time, go to project and rename screen res to res1 and fix the blocks so they refer to res1. Copy the screen. Add a new screen, copy from the saved screen and rename it to res2. Repeat 20 more times. (Make 5 for testing for now)
test multi user functionality
Yes. I mean enter the value 1 inside cell m1. What other meaning could it be? If I meant text I would have said text
---
### Author:  [@denemeyanilma892420](https://community.thunkable.com/u/denemeyanilma892420)
#### Post date: [November 28, 2021, 5:45pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/48 "2021-11-28T17:45:29Z")
thanks, will try that
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [November 28, 2021, 9:27pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/49 "2021-11-28T21:27:37Z")
I am considering this idea. It replicates the data downwards while my approach extends it to the right. I think Google sheet can compute 21 screens faster accompanied by a computed/“indexed” thunkable navigate block. compared to one long sheet with 400+ rows and a thunkable block looping thru 400+ rows and selecting 20+ to display whichever matches the desired group.
But thanks for the idea. I’ll try it later.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [November 29, 2021, 6:51am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/50 "2021-11-29T06:51:43Z")
Do not worry about speed.
I have a sheet of over 1700 rows and use this trick to filter and you can hardly feel a delay.
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [November 29, 2021, 7:21am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/51 "2021-11-29T07:21:33Z")
it works!
but the full list shows first then the filtered result replaces it - after the filter runs - so i had to set the visibility of data viewer list to false then turn it on after the filter. i’ll run it by @unsalberkay1905cfbe
thanks again, muneer!
---
### Author:  [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)
#### Post date: [November 29, 2021, 7:24am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/52 "2021-11-29T07:24:29Z")
> [@manyone](#):
>
> rename res to res1, type the value of 1 in cell M1
i was so tired yesterday 😃 , increbile 😃
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [November 29, 2021, 7:26am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/53 "2021-11-29T07:26:20Z")
i’ve just implemented muneer’s idea into the tiny model i have and it works - i’ll be publishing shortly - you’ve got to study it and see if it applies for you.
---
### Author:  [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)
#### Post date: [November 29, 2021, 7:28am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/54 "2021-11-29T07:28:38Z")
i am sir , thanks for the help ,
---
### Author:  [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)
#### Post date: [November 29, 2021, 7:31am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/55 "2021-11-29T07:31:39Z")
My m1 column is full , i will use J1
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [November 29, 2021, 7:32am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/56 "2021-11-29T07:32:59Z")
you should hold off on my earlier approach - muneer’s idea is more practical and less work.
---
### Author:  [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)
#### Post date: [November 29, 2021, 7:36am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/57 "2021-11-29T07:36:37Z")
then i m waiting demo from you
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [November 29, 2021, 7:50am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/58 "2021-11-29T07:50:53Z")
here’s muneer’s idea applied to the tiny model i have. all formulas and navigations are based on the assumptions i have at the start mainly - some external process computes and populates **qual** and **pen** tabs, the way i’ve envisioned them. you have to extrapolate them into the form and structure that your project has evolved into.
here’s the google sheet, make sure you upload this to your google drive as **races2**
> **[races2](https://docs.google.com/spreadsheets/d/18zaERg0xaf3QLCZ1BBo09Ij00d7HCxnDEQqx2TBRrGU/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...
here’s the link to the project - do not open until races2 is uploaded to google drive
[https://x.thunkable.com/copy/6e85607f4ef03cae18258eb5a91ddf13](https://x.thunkable.com/copy/6e85607f4ef03cae18258eb5a91ddf13)
the approach of this method is the same. the **race\_table** is local. and the selection via grid results in a variable called **race\_num**.
the tab **res** is pre-populated , computed at the time the qual and pen tabs are updated.
here’s what the res looks like (using tiny model - 8 players and 4 races).
note the formulas - the race number is now part of the row it is a good idea to fill all formulas for race1 first then copy the rows downwards, each time changing the row number to the next sequence.
how to run: select the race from the grid view. the next screen will show everything in res that matches the race\_number selected.
here’s the result of selecting portugal.
note: i don’t know how to make a custom layout for the data viewer list that’s why i only show 3 elements. it’s important to include the column race\_num in the data viewer layout because the filter refers to it.
i hope this works for your needs. good luck! (thanks again, muneer!)
---
### Author:  [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)
#### Post date: [November 29, 2021, 7:54am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/59 "2021-11-29T07:54:41Z")
Thans a lot , starting to work
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [November 29, 2021, 8:11am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/60 "2021-11-29T08:11:03Z")
i think you will need sorting, download the google sheet again, i added a Sheet 9 which sorts res using 2 columns. in this case sheet9 will now have to be the data source for your data viewer.
[Previous page](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565.md?page=2)
[Next page](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565.md?page=4)