I want to load data to Data viewer list from a spreadsheet as a data source, but I need to filter that database on a text contain in a cell, how can I do that.
Ex:
I have a table in google sheets named “Liquor”, table fields are “Name”, “ID”, “Occasions”.
Example data for Field “Occasions” are “parties, wedding, prom”
So what I need to do is get data of liquor which contains “parties” in the occasion field and display the on a Data viewer list
Any way to do this, couldn’t find blocks to create the logic
this was what i really want. (you can search my questions) but, belive me basically it is not possible.
One way to do it is creating filtered google sheets (let say 8). there is only One datasource and 9 dataviewers (original one and each every one of them) And save row id to each data. if someone add new data then it will added to original one and One filtered sheet.
But there are some issue here. maybe it is not to easy to SORT. becuz maybe you have to give up delete function cuz row id acts weird and it ruins. (sorry for not the best explanation)
Otherwise, if you use script in google sheet or zapier to airtable then it might work.
Or you can use list viewer using Clone, but they appear so slow.
in conclusion, nevertheless of all my effort, i GAVE UP. and im doing in another way. (not using data viewer)
You are mistaken. The Data Grid and Data List components can display filtered records, but this happens crookedly because of the DataSource’s performance curve.