[Solved] Selecting one of hundreds of lists from a dataviewer and getting the values in that list?

i took the liberty of interpreting your request. you probably need a structure opposite to what you originally thought. i assumed you might need a google sheet that looks like this:
image

my first screen shows the sorted list of all words in column word so it’s really using a data source pointing to the spreadsheet.

it’s a different story for processing the word that was selected, i’m using the Visualization API Query Language from google because it features a fast way of obtaining row/s from the spreadsheet using a simplified SQL statement with a WHERE condition and the returned value is a json string containing the row/s that satisfy the query.

you can read more about this process here

here’s the word selection screen
image
and here’s what you get when you select a word to obtain the related words:


.
here’s the link to the spreadsheet:

and here’s a link to the project
https://x.thunkable.com/projects/632aa7733b27ec0224e0513a/ab6da954-35cf-4ab8-ac85-36bf9caa8d45/designer

i hope this works for you.

2 Likes