# \[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:** 6
**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, 4:45pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/101 "2021-11-30T16:45:40Z")
This is the error ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/7/17cd0919a341cc7e25cb58d88daf3226e865910d.png) The value of Label1 in the DVL is **undefined** this is why the filter is not working. ---
**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, 4:46pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/102 "2021-11-30T16:46:59Z")
but i dont get that error ? @muneer ---
**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, 5:05pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/103 "2021-11-30T17:05:10Z")
In your project, you have at least **TWO** Data Sources with the name **races2**. Cab you remove what is not required. Testing becomes a lot difficult if you have multiple sources with the same name. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/6/c6799232e467230e3bd483bc32577be4dac55f8f.png) ---
**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, 5:05pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/104 "2021-11-30T17:05:41Z")
i deleted those 2 and added new one , do i need to share again i sahred anyways [Thunkable](https://x.thunkable.com/projectPage/6173bba055c164001133b9e3) ---
**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, 8:31pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/105 "2021-11-30T20:31:01Z")
i was able to show the rows of he selected race by using this block (apparently, you need to convert race\_num\_qual to number): ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/c/3cdd3c47cf76a448a00d61e6d763be62f07f8a73.png) it takes a while (more than 5 secs?) to get this selection for #3, portugal ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/0/90f0c2e4f3e0935bff7e3a40713b78ee2f634a57.png) for cell coloring, here’s the place to get the color values of google sheet cells: [https://spreadsheet.dev/how-to-get-the-hexadecimal-codes-of-colors-in-google-sheets](https://spreadsheet.dev/how-to-get-the-hexadecimal-codes-of-colors-in-google-sheets) you can hardcode the team number (be sure to adjust dev\_qual) and include it as a non\_display field in the data viewer layout, and use it to index into an array of team colors while setting the team color inside the for\_each\_item loop. ---
**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, 9:30pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/106 "2021-11-30T21:30:22Z")
oh yeaahh it works but cant we make faster EDIT :probably @muneer went to sleep 😃 ---
**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:** [December 1, 2021, 10:18am UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/107 "2021-12-01T10:18:54Z")
I will look at it a bit later. Can you share the latest project and latest Google sheet, please? ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [December 1, 2021, 12:04pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/108 "2021-12-01T12:04:32Z")
> **[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... [Thunkable](https://x.thunkable.com/projectPage/6173bba055c164001133b9e3) @muneer ---
**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:** [December 1, 2021, 4:16pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/109 "2021-12-01T16:16:04Z")
I just tried running it and the speed is **GOOD**. It took less than a second. Or let’s say **ONE** second. ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [December 1, 2021, 5:10pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/110 "2021-12-01T17:10:08Z")
oh really? ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [December 1, 2021, 5:13pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/111 "2021-12-01T17:13:16Z")
it loads up in 1 sec but ,filtering takes 5 sec @muneer ---
**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:** [December 1, 2021, 5:19pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/112 "2021-12-01T17:19:00Z")
> [@unsalberkay1905cfbe](#): > > ,filtering takes 5 sec Not in my computer. I was clicking back button and selecting different teams and it is always loading the list in the `Data Viewer` in a second. ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [December 1, 2021, 5:25pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/113 "2021-12-01T17:25:58Z")
> [@muneer](#): > > different teams you mean races ? @muneer @manyone EDIT: can you try to test from yarislar tab , pick a race and can you inform me after that please? ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [December 1, 2021, 7:36pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/114 "2021-12-01T19:36:32Z")
in my computer at live test , it does load up the ALL rows in 1 second , but obviously i want 20 of them per race , and to get those 20 it takes a lot of time in the app ---
**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:** [December 1, 2021, 7:38pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/115 "2021-12-01T19:38:03Z")
> [@muneer](#): > > > [@unsalberkay1905cfbe](#): > > > > ,filtering takes 5 sec This issue could have something to do with the underlying system running the app. I’ve ran an app on my iPhone that runs smoothly but while on an old low-end android phone the app was slower. Most apps run like Usain Bolt on my desktop in the browser! There may also be differences in the network connection speed you both experience. I also wonder about location as a reason for data transmission speed delays. ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [December 1, 2021, 7:42pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/116 "2021-12-01T19:42:18Z")
Firstly congrats @jared , and possibly , can you send me your siralama screen ---
**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:** [December 1, 2021, 7:56pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/117 "2021-12-01T19:56:26Z")
> [@unsalberkay1905cfbe](#): > > siralama screen I’m not quite sure what a siralma screen is? Is that Turkish for Ranking? If you give me an example I’ll do my best to share it with you if I have one! ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [December 1, 2021, 8:16pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/118 "2021-12-01T20:16:39Z")
choose item from that list preferably choose first 3 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/c/fcbba9e540792c23b924c707d5210950f878133a.png) then after you choose please sent me this screen ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/2/c218d9f83b946704dc2e55399d80b694de266a2a.png) top left tab say “siralama” thats the screen that i want @jared @muneer @manyone ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [December 2, 2021, 1:21pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/119 "2021-12-02T13:21:38Z")
@muneer , @jared , @manyone have you guys tried it out, this way ? EDIT : When i clicked a race ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/9/69734c621fe151c3c3a6639c31b11162096570da.png) after copule of seconds ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/c/3caf569cd294b9bb03b814463e65fdbb45c3ab4f.png) And as you can see above Data viewer list tries to upload all of it then deletes ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [December 2, 2021, 2:09pm UTC](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565/120 "2021-12-02T14:09:17Z")
New Design idea? by the way , lets say user pressed race 2 imola can we list row 22 to row 41? ( trying to say : cant we list by the row numbers ?) EDIT: program works fine but works slow , trying to make it faster [Previous page](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565.md?page=5) [Next page](https://community.thunkable.com/t/solved-user-specific-app-database-help/1630565.md?page=7)