# \[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:** 4
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 29, 2021, 8:37am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/61 "2021-11-29T08:37:45Z")
okay will do that ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 29, 2021, 1:45pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/62 "2021-11-29T13:45:10Z")
hi for the race\_num at res tab , do i need to enter race\_num’s manually ? ---
**Author:** ![manyone](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@manyone](https://community.thunkable.com/u/manyone)\ **Post date:** [November 29, 2021, 3:38pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/63 "2021-11-29T15:38:50Z")
You can enter the value manually for the rows in ithe first race. After that you use a formula of prior cell plus 1 - eg in my example. G2 thru G9 all have a value of 1 but G10 thru G17 will have a formula of =G2+1, G3+1, G4+1 … G9+1. you really only have to enter the formula for G10=G2+1, afterwards, just copy cell G10 to G11 thru G17 and all cell references wlll adjust automatically. Then if you copy the set of players downwards, all racenum are calculated properly. ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 29, 2021, 6:55pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/64 "2021-11-29T18:55:06Z")
because of the custom layout it gives error ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/5/2536b0f124ff018646d44036ef54d2fa4cf9c5c4.png) what to fill those spaces my layout: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/2/42ab8844061d6c7342a37e1f7c287f26c7053d32.png) ---
**Author:** ![manyone](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@manyone](https://community.thunkable.com/u/manyone)\ **Post date:** [November 29, 2021, 7:35pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/65 "2021-11-29T19:35:01Z")
first of all, modify your custom layout and add an entry for race\_num (from the res sheet). in the siralama screen, connect the data viewer list to the res screen and map the desired fields unto the custom layout. make sure to include race\_num. use the same block as mine: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/b/9b01683df5bfe96f4a83d34b830c9151e92a0dbc.png) but change the circled variable (ie. Text) to whatever is the name for race\_num in the custom layout. and verify the connection of the data viewer list to the correct screen name. (in the for\_each\_item block, the list of values should be coming from your res screen - why are you pointing to DVL\_QUAL?) ---
**Author:** ![trialerror19054v7or](https://avatars.discourse-cdn.com/v4/letter/t/779978/32.png) [@trialerror19054v7or](https://community.thunkable.com/u/trialerror19054v7or)\ **Post date:** [November 29, 2021, 9:25pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/66 "2021-11-29T21:25:30Z")
okay starting to work 😃 ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 29, 2021, 11:07pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/67 "2021-11-29T23:07:34Z")
this was delayed message from my new account @muneer ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 29, 2021, 11:09pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/68 "2021-11-29T23:09:30Z")
DVL\_ QUAL is my sorted tab for “siralama” > **[races2](https://docs.google.com/spreadsheets/d/18zaERg0xaf3QLCZ1BBo09Ij00d7HCxnDEQqx2TBRrGU/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... ---
**Author:** ![manyone](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@manyone](https://community.thunkable.com/u/manyone)\ **Post date:** [November 30, 2021, 2:26am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/69 "2021-11-30T02:26:32Z")
i fixed your formulas in res so if you want to extend downwards later you have to extend qual first to accomodate more races, then in res, simply copy the last set of rows (21 rows) to the next available space. ive saved over my old races2 sheet so i had to adjust my thunkable project to adapt to your sheet. the for\_each\_item block should be pointing to list of values in races2 in DEV\_QUAL\_PEN ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 30, 2021, 10:55am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/70 "2021-11-30T10:55:53Z")
thanks a lot @manyone > [@manyone](#): > > DEV\_QUAL\_PEN i dont see such a table called that , and dont i need to name H column , for data viewer list EDIT : i added race\_num to dvl\_qual and added a label for race\_num (height :0 , width, 0 , font: 0 ) but at blocks , because of the custom layout i dont have layout wrapper , so i tried to do it with row 1 but screen opens and freezes , so it didnt work @muneer you know anything about it ? and btw , i need to add teamcolour column for the layout design ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/0/30acb04b60de927ac7098e540c6123eba2640a9c.png) its not that late to do that right 😃 ---
**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 30, 2021, 1:42pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/71 "2021-11-30T13:42:14Z")
> [@unsalberkay1905cfbe](#): > > because of the custom layout i dont have layout wrapper Your layout wrapper in the custom layout is **Row1**. ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 30, 2021, 1:53pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/72 "2021-11-30T13:53:01Z")
not working ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/8/488da7caa592bce2239a8ece6b7ff436964444ed.png) i guess something wrong with blocks siralama(qual) blocks ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/6/e6b22151e554baae53b639b98b77e442fb1e4c9f.png) yarislar (races) blocks ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/0/607845d924b0100ce120b4705962bf8ebb67cf8c.png) and my local table ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/6/f697ac315544fcfaea511851a65223f308aa619c.png) EDIT : or i will just send my project link 😄 [Thunkable](https://x.thunkable.com/copy/31c76b7aaf17df1fdb8e78a02234d6b9) ---
**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 30, 2021, 2:00pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/73 "2021-11-30T14:00:36Z")
First try it without the `for each item...` loop and see that all records are showing then insert the loop and if nothing is showing make sure they have data. Add 2 labels to the screen and inside the loop one label shows the “race\_num” and another label shows the “Label1” text content. Make sure they are the same. I just checked your project. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/5/15dc9a245ed35bfd12a0c305cf977d12fe0364e5.png) This has error. ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 30, 2021, 2:04pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/74 "2021-11-30T14:04:28Z")
let me update my link for you : [races2 - Google Sheets](https://docs.google.com/spreadsheets/d/18zaERg0xaf3QLCZ1BBo09Ij00d7HCxnDEQqx2TBRrGU/edit?usp=sharing) ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 30, 2021, 2:07pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/75 "2021-11-30T14:07:03Z")
and without the for each my block : ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/1/91efa461c1973facbac993d0582214f993375517.png) and screen ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/d/3de76da35b0894eee09a8b58bdb84287c35d4e65.png) ---
**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 30, 2021, 2:07pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/76 "2021-11-30T14:07:08Z")
This is what I get when opening Data Viewer in your screen. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/8/a8b500f4a1cf366f871821c96b8ae0f9fec4b28b.png) When you disconnect a `Data Source` and connect gain, you have to reconnect the `Data Viewer` and the `blocks`. ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 30, 2021, 2:09pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/77 "2021-11-30T14:09:03Z")
but i dont have a problem on my screen ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/9/5999585735c02133cb2ad58a069d46daf5a709e4.png) ---
**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 30, 2021, 2:11pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/78 "2021-11-30T14:11:40Z")
Did you run it without the loop and see that data appears in a normal manner? When you share a project, do not use the URL that has **/copy/**. Use the link that has **/projectPage/**. This way I can test your app directly against your data. ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [November 30, 2021, 2:16pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/79 "2021-11-30T14:16:25Z")
i did without for each , i ll try to send you project page find it : [Thunkable](https://x.thunkable.com/projectPage/6173bba055c164001133b9e3) ---
**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 30, 2021, 2:39pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/80 "2021-11-30T14:39:13Z")
I logged in and I see this ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/f/8f39126bb186729b17a580ad87cebca575ff93db.png) Is this your expected list? I can see the first column always **1** The last column is like the serial number. [Previous page](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565.md?page=3) [Next page](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565.md?page=5)