Sorry if the topic doesn’t make sense, I wasn’t sure the best way to describe it. I’ve tried searching the community, but this same trouble describing what I am hoping to do has led to a yield of no results. I am sure this is pretty basic, but I’m just getting started with Thunkable X and having a …

Hello there, Welcome to our Community :smile: :tada: :tada: [image] martymcsupafly: When one of the states is clicked, So, I assume that u are using a listviewer to select States. I think, this can help u - [image] Hope it helps :smile: Thanks! :tada:

Thank you for the quick reply! What I’m hoping to accomplish is a little more complicated than that unfortunately. You’re correct about the list viewer with the 50 items (50 states). The local DB is filled with many locations. Each row has a column for the location name, a column for the address,…

Hello there, :wave: Okay. So here’s what u should do : Solution #1 If yr listview items & local db States’ column items are ditto (the same names & letterCASE), and arranged the same, like - [image] (Both have same names at same indexes) Then, this should work for u - [image] Else, (Both do …

This looks like it’s getting very close to what I am hoping to do! The table will look more like this: [25%20AM] When the list item Alabama is clicked, it would return Location 1, Location 6, and any others where State matches the clicked list item. There will be dozens of results for each of the…

Hi, @martymcsupafly ! :wave: **Try this : ** [image] Hope it helps! :wink:

This is starting to make a lot more sense! What I’m hoping to do with this list now is to take that list that will return all Locations and fill the List Viewer with all of the results. [01%20PM] Here’s what I’ve got based on what you suggested, but I’m not entirely sure how to add those results …

Here’s the solution for the listviewer : :blush: [image] Hope it helps! :wink:

Hi there, You can see a tutorial on searching and filtering a LocalDB here: http://community.thunkable.com/t/search-filter-localdb/68902?u=jane Thanks, Jane

This is also very helpful :smile:

Querying Local DB to Return List of Items that Have a Match to a Query in their Row

Questions about Thunkable X

kartik14 August 11, 2019, 3:11am 8

Here’s the solution for the listviewer :

Hope it helps!

Display data from airtable

Topic		Replies	Views
Template or project which uses list to display contents of local DB? Questions about Thunkable X listview	1	895	June 5, 2019
Local DB How Can I Use? Questions about Thunkable X	11	3934	February 7, 2019
Search local DB / get row Id Questions about Thunkable X beginner	4	611	January 10, 2021
[Solved] Return result depending items selected (combining variables) Questions about Thunkable X solved , localdb	9	442	March 29, 2021
Airtable listview click Questions about Thunkable X	3	518	April 29, 2020

Querying Local DB to Return List of Items that Have a Match to a Query in their Row

Here’s the solution for the listviewer :

Hope it helps!

Related topics