One of the most powerful features in Thunkable is the new LocalDB component, which allows you to insert a mini-spreadsheet directly into your app. This might be the first of a larger series of tutorials mimicking features found in other spreadsheets, but for now let’s get started with VLOOKUP.
What is VLOOKUP?
A VLOOKUP, or vertical lookup, allows you to search vertically down through a column of data and then find a corresponding value in your target row
Let’s start by adding a ListViewer with three items:
Next, in our LocalDB, we’ll create a 12 x 2 spreadsheet. Note that the “numbers” column has the same data as our ListViewer
In our blocks, the “sublist” variable will contain the selection of letters we want from the larger list of letters. I’ve also created an “index” variable to make it easier to keep track of where we are in our loop. NOTE: The index variable should be reset to 0. I’ve amended this in the remix-able project below
When the user clicks on an item in the the ListView (which will be either “one”, “two”, or “three”) we start by clearing out the sublist, and resetting the index:
The next thing we want to do is set up our loop, moving vertically through the data in the “numbers” column. After each pass through the loop we manually increment the “index” variable and when we reach the end of the loop we display the sublist in a label
Finally, we need to check whether or not a letter should be added to the sublist. To do this we compare the ListViewer item (called
item) to the Loop item (called
j). Now, using our index variable we can fetch the corresponding value from the numbers column.
If you want to take a closer look at my app or use this feature in your own app you can remix my project here.