okay will do that
1 Like
hi for the race_num at res tab , do i need to enter race_num’s manually ?
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.
1 Like
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:
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?)
2 Likes
okay starting to work 
1 Like
this was delayed message from my new account @muneer
1 Like
DVL_ QUAL is my sorted tab for “siralama”
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
2 Likes
thanks a lot @manyone
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
its not that late to do that right
1 Like
Your layout wrapper in the custom layout is Row1.
not working
i guess something wrong with blocks
siralama(qual) blocks
yarislar (races) blocks
and my local table
EDIT : or i will just send my project link
Thunkable
1 Like
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.
This has error.
let me update my link for you : races2 - Google Sheets
1 Like
This is what I get when opening Data Viewer in your screen.
When you disconnect a Data Source and connect gain, you have to reconnect the Data Viewer and the blocks.
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.
i did without for each , i ll try to send you project page
find it : Thunkable
1 Like
