[Solved] User specific app (Database help )

This is the error
image

The value of Label1 in the DVL is undefined this is why the filter is not working.

but i dont get that error ? @muneer

1 Like

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

i deleted those 2 and added new one , do i need to share again
i sahred anyways Thunkable

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):

it takes a while (more than 5 secs?) to get this selection for #3, portugal

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
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.

oh yeaahh it works but cant we make faster
EDIT :probably @muneer went to sleep :smiley:

1 Like

I will look at it a bit later. Can you share the latest project and latest Google sheet, please?

Thunkable
@muneer

1 Like

I just tried running it and the speed is GOOD. It took less than a second. Or let’s say ONE second.

oh really?

it loads up in 1 sec but ,filtering takes 5 sec @muneer

1 Like

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.

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?

1 Like

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

1 Like

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.

1 Like

Firstly congrats @jared , and possibly , can you send me your 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!

choose item from that list preferably choose first 3


then after you choose please sent me this screen

top left tab say “siralama” thats the screen that i want
@jared @muneer @manyone

2 Likes

@muneer , @jared , @manyone have you guys tried it out, this way ?
EDIT :
When i clicked a race


after copule of seconds

And as you can see above Data viewer list tries to upload all of it then deletes

1 Like

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

1 Like