As you can see below this is where the issue happens. If I replace the get value with part with the greyed out one it works but the issue is that its really slow because there is alot of data in the google sheets. How it works is that the SearchResult_List takes data from a list of all the values in the sheet but because its a regular list and not a Data_Viewer_List i cant really get both the definition and the name. I did this because I needed a search function which Data_Viewer didn’t allow me to make easily. Long story short I need a function that can get the row that specific word is located in and retrieve the definition using the row number. Note index won’t work because the list changes when the search function is used.
It’s hard to know how you expect this to work without seeing the actual data from the spreadsheet. Also, you should really never put a variable block inside of a set app variable block. You’ve just told Thunkable to create a variable with an empty text string as the name because you set app variable definition to “” and then set a variable with that variable as the name… anyway, it gets confusing. My advice: don’t use the set app variable " " block unless you have a really good reason to. Just use the set app variable definition block from the top of the Variables drawer.
Also, what do the blocks on the next screen look like?
Hey, I see what you mean and will improve now. Also here is the data that you need to understand the structure of my goal.
The next screen that just sets the variables in the according text boxes.
This is how the spread sheet is structured.
This is the rest of the code above the previous one.
The issue is the current two methods take soo much time to get to the row as the row number increases. Is there an optimal way? I heard from a friend that while might work faster, will attempt that now.
Ok I think your advice fixed it. Removing the variable in variable thing was the issue.
1 Like