Returning a Value

[briseno1984q]

Hello Everyone… first post here.
I am making a “Sign in, Sign Out” Hall Pass App.
Students enter their ID Number ----> Google Sheet will record: Name, Time, Teacher, Location etc.

I am having issues returning a student name based on them entering their ID Number.
This is what I have, and for the life of me it is not returning anything.

I have tried:
Initialing a list with "list of values in 2023-2024 in Sheet 1 in ID Number
Assigning variables for the index and using “list of values in 2023…, this lead to my app crashing.
I tried creating a list from text with the " ,”, but that also ended up crashing my app and giving me the “check blocks error”
I know that it will return a name if i put a specific number for the row id.

But when I don’t, the Index always returns 0.

I created a similar app a while back and used the Create object Json text to post on a Google sheet and it worked fine.
Please help. I have a list of 700 if that makes a difference.

[tatiang]

Hi and welcome to the Thunkable forums!

There is a problem with the way you are using variable blocks. Please see this topic and let me know if you have any questions after that: Setting and Getting Stored Variables - Keep getting Null

Your question seems to be how to do a vlookup. This question comes up frequently on the forums and I would encourage you to search for that term if you haven’t yet.