Search bar query for data from Google Sheet

💬 App Building
,
2

Hey @gemechisw,

An easy solution would be to add a search term to the table.
This filters the data displayed on the table. You can add {{ textInput1.value }} here:

image
image829×685 86.8 KB

If this doesn't work for you or it's not the intended behavior, you can change your query to match this format:

SELECT *
FROM {{formatDataAsArray(query1.data) }}
WHERE title ILIKE {{'%' + textInput1.value + '%'}}
1 Like