I have identified the data in a column, using a mathematical comparison to a stored variable. I have also initialised a variable as zero, to store the future row id. How do I then retrieve the correct row id to update the variable? In the code shown, the missing block is where I think the row id …

No, the find first occurrence of item block will return 0 if nothing is found that matches the item value but otherwise will return an integer for the first row (or list position) in which that item is found. So for example, if you have a list {3,6,9,9,12} and you get the first occurrence of 9, the…

Welcome to the community, @bigbluesquidtvku ! Try looking at this link: Data Viewer List - Thunkable Docs

Thank you for the reply. The only block I can find to retrieve a row id is when an item in the Data Viewer List is clicked or swiped. Are there others that I’m missing? My users don’t interact with the list directly, a calculator generates a number from the user inputs and compares the result to a…

[Screenshot_2024-01-09-22-21-15-569_com.android.chrome-edit] Try to Implement this kind of logic to return index. Thanks Abdul

Thank you, this is what I tried from your example but it doesn’t read the row id, presumably because I’m not using the when… click block? [image]

I’m not sure if you saw my example and @mannankhanabdul ’s example that both use the find first occurrence of item block. That’s the way to do what you’re wanting.

Sorry, I couldn’t get the row ID from the example. The docs say “find first/last occurrence” will return 0 or 1. As I’m using less than or equal to, there may not be an exact match. The app variable ID below returns 0: [image]

Thank you, that makes sense now. The Upper Limit column contains only integers. Note, in the screenshot below I’ve changed the name of app variable limits to app variable resultID. I don’t know if it’s elegant or efficient, but it works :smiley: [image]

If it works, then it’s probably fine! :wink: The only thing I notice is that you’re getting three values from the fifth row of the same data source so you could make things a little more efficient by getting the row object and storing it in a variable and then getting properties (“ID”, “Percent”, “…

Just as a reference for future readers, these are the final code blocks that worked, with the variables in place of the number 5: [image]

How to identify row id from data found in same row

Questions about Thunkable X

tatiang January 9, 2024, 3:23pm 3

See this: Thunkable and returns a corresponding value from my sheet - #2 by tatiang

Topic		Replies	Views
How to find and use row id with Data Viewer List? Questions about Thunkable X	2	2170	March 21, 2022
Getting the row selected from data view Questions about Thunkable X	5	426	May 9, 2023
"get Value From for row id" isn't working. Why? Questions about Thunkable X data-source	2	769	October 25, 2021
Using row id and if statement Questions about Thunkable X beginner	3	118	April 8, 2024
How do I make thunkable display a value from my google sheets table? Questions about Thunkable X beginner	7	469	December 11, 2023

How to identify row id from data found in same row

Related topics