Filter data spreadsheet/ local table

[ingraulbarbosa70a]

Hello team

I hope you are good!

I´m working in a services app with a spreadsheet and local table.

I would like to make a filter for the information because the list in spreadsheet is to large.

I saw many videos like a make a two spreadsheets to reload the information in viewer list. So I have a filters into the spreadsheets but i think for the tarjet app don´t works for many users because if they will search in the same time, the information in the second spreadsheet (reload) send a diferent information or crashes, this is correct?

So i trying to make a filter to send (the information that the users needs typing in a label to find a service) the spreedsheet to second spreadsheet “reload” (it´s more visual if its working) and the in local table, but i don´t know to make to build it. the Blocks for the data sources are working?

Can you help me with this issue, please? in below you can check the imagen.

Beforehand thank you for your time and support.

[tatiang]

I’ve used Airtable for this because you can filterByFormula and get the results from the Airtable API. That doesn’t modify the data at all so many users can filter the same data in different ways without affecting each other.

You can see a discussion of that here:

Get particular row information via particular text from airtable column

Hi, I am trying to display row information of particular text in column . Ex: Column Named Skills has Garden Cleaning, Dusting, Fan Cleaning, Balcony Cleaning and so on… I want the row details of Dusting alone. If I have 2 entries for Dusting means then I should see only those 2 row details getting displayed in the listviewer. Sharing the blocks: [image] Also sharing the airtable snapshot: [image] Your input is highly appreciable…

And here:

Help with possibly adding a feature in my app

im trying to build a deck building app for a trading card game called flesh and blood and so far im using airtable to store the images of pictures and names of cards but I want to include filters so when people are searching for cards in the app , they wont have to go through a whole list. does anyone know how I can include that or which resources I should refer to. is there a database I should use instead of airtable or will airtable work to make a filter?

[manyone]

can you study this if this will work for you?

Quiz App using google sheet via google's visualization API Query Language (instead of Data Source)

i’ve just recoded my earlier quiz app which used airtable as datasource into a new version using google sheet as source of the quiz but NOT as a data source. Instead i’m using Google’s Visualization API Query Language to read the worksheet (see this recent discussion in the forum ). It’s a different approach for working with google sheets, but i like it! below is the contents of my worksheet. ( Note - in order to use the query language, the worksheet must first be shared such that anyone wit…

your spreadsheet is NOT a data source but as a URL parameter to webapi. you can do all kinds of SQL like queries against it
select…where clause with multiple conditions, group by, limit, etc. -
see below this for details:

Query Language Reference (Version 0.7)  |  Charts  | ...

after you issue your query what is a returned is a JSON object containing all the columns you specified, ready to be parsed.

i think it works best with a static spreadsheet (ie. not continually updated).
i hope it works for you.

[muneer]

Let me add another concern which was discussed yesterday in another post.

Usage limits  |  Sheets API  |  Google Developers

As you can see the date in the image, it is updated just a month ago and this could have an impact in the way Google sheets would serve as a data source.

[manyone]

you forgot to post the image?

[muneer]

@manyone

post the image

You have one API request per second.

[jared]

@muneer

You have one API request per second.

I believe it’s not metered to the second but based on a sum of events within a 60 second duration.

I wouldn’t use google sheets for this and hit their url endpoint. I’d use xano to search my table and return the appropriate data.

[ingraulbarbosa70a]

Hello Tatiang

Thank you for your quick response!

Today i´ll check it.

Nice day!

[ingraulbarbosa70a]

Hello

Thank you for your comments and support!

For sure, today i´ll check it too.

Nice day!

[ingraulbarbosa70a]

Hello everyone
Review the information that you kindly shared with me. I’m doing tests with the topic of filters with formulas for the airtable. On the other hand, I am using the data list viewer and the grid data viewer because I have images in airtable. After putting the information filter blocks,

how should I put the visualization of the viewer data grid and data list? This is beacuse i have the next information (into the airtable) in green color that i would show to users into the viewers

Sorry, this is a new topic for me.
Thank you for your support!

[tatiang]

The answer to that is going to depend on what your JSON response looks like. Can you post that response as text? It’s best to format it as code using the toolbar button on the forums or just placing ``` on a line right before it and ``` on a line right after it.

[ingraulbarbosa70a]

Hello,

The target is filter the data viewer list from airtable with a large information (check below a example in row no. 1).

So into the app a set up a data viewer list with all list from airtable.
When i select a letter from abecedary i would like to filter the data viewer list in the same format ( check the imagen below).

For that i have only this blocks:

Honestly don’t know what blocks should go with the JSON blocks. Are you so kind to help me please?

[tatiang]

@tatiang

The answer to that is going to depend on what your JSON response looks like. Can you post that response as text? It’s best to format it as code using the toolbar button on the forums or just placing on a line right before it and on a line right after it.

1. Add a Text Input to your screen.
2. in the “then do” section of your Web API Get block, set the text input’s text to the green response block.
3. Preview your project.
4. Copy the text from the Text Input.
5. Paste the text in a post here.

If step 4 is blank, then you need to check the value of the green error block and let us know what it shows.

[ingraulbarbosa70a]

Hello, i have an error: Network resquest failed

[tatiang]

Please see the two topics I linked to above. You have to configure the Authorization headers properly.

[ingraulbarbosa70a]

Hello Tatiang

I hope you are good!

The configurations are ready

What should I do to show the results in the data viewer list and grid?

Thank you for your support!

[tatiang]

If you have the data you need in the JSON response, then you will need to parse it to get the values you want and create rows in a blank local data source synced to a Data Viewer List/Grid.

If you want help parsing the values, post the full JSON response as text:

It’s best to format it as code using the toolbar button on the forums or just placing ``` on a line right before it and ``` on a line right after it.

[ingraulbarbosa70a]

Hello Tatiang

I hope you are good

I tried to built it but i´m not successful, these are my blocks:

Are you so kind to tell me what are the correct blocks that are needed?

These are the values:

{"records":[{"id":"rec15qhJfGs04g8fD","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Abecedario":"A","Palabra clave":"uñas","Categoría":"Apiterapias"}},{"id":"rec1WpqBQ32gNRb3V","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Micro pigmentación"}},{"id":"rec2Z6sm93HbXKYok","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Taxis"}},{"id":"rec3C7Wz2h09he8xk","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Florerías"}},{"id":"rec3LsZ3mCdr0ZOAi","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Enfermerías"}},{"id":"rec3aVWJwSIyW8Zc3","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Bazares"}},{"id":"rec3xqBWRZi2WGIS4","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Lavanderías"}},{"id":"rec4WwMP5D3zM2Rtx","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Farmacias"}},{"id":"rec4tsv0WKyoIpxFe","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Maquiladoras textiles"}},{"id":"rec6MUgD30uccOMQO","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Forrajeras"}},{"id":"rec7FCiCvSRG7lTxf","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Celulares"}},{"id":"rec7FUfWSr0MzhrK3","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Tiendas naturistas"}},{"id":"rec7lIf3uBjQ9W5h8","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Banquetes"}},{"id":"recAJUDqJNRBZ6flA","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Hospitales"}},{"id":"recAPjpgn4I5dDzmu","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Transporte privado"}},{"id":"recBQKRBjLmexHsZc","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Médicos generales"}},{"id":"recBfQl8bDbvLBDoy","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Hueseros"}},{"id":"recCrMfulEhzozz1c","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Hojalatería y pintura"}},{"id":"recDJFXW7COwyqWgE","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Veterinarias"}},{"id":"recDQ5j6jLkl1GCef","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Reparación de lavadoras"}},{"id":"recEDXZeTKNalmRfr","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Mueblerías"}},{"id":"recEDvCK702VWjV0D","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Ortopedias"}},{"id":"recEIZqFhZco6Dk5Y","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Licores"}},{"id":"recEcNQIVHhcJr3v2","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Consultorios dentales"}},{"id":"recHnA2yeVIDVjq6m","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Barberías"}},{"id":"recIPw7YdE0JlySEG","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Vidrierías"}},{"id":"recIR4JUdoxKLukgK","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Purificadoras de agua"}},{"id":"recIsSmmfydEnddOA","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Pinturas"}},{"id":"recJM4qxrkUvsUVgz","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Semillas"}},{"id":"recJZkCMKXzrirAes","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Autolavados"}},{"id":"recJxalnRCfwIj9Y1","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Imprentas"}},{"id":"recLDxpVyrX9ZNnQu","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Refaccionarias"}},{"id":"recLuBV2o6wE4VsG0","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Abecedario":"b","Nombre negocio":"poshi","Palabra clave":"Carros","Categoría":"Cerrajería"}},{"id":"recLwuZawYcLasohX","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Abecedario":"A","Palabra clave":"Carros-Carros-Cereales","Categoría":"Agencia de viajes"}},{"id":"recM3pdBPmXS6pKHW","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Uber"}},{"id":"recM9EfVapInucYuv","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Radiotécnicos"}},{"id":"recMWgmBHCpb7R4VB","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Podólogos"}},{"id":"recN61v8qQYYLCV2l","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Autobuses"}},{"id":"recNDbBt39K6womWa","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Renta de inflables"}},{"id":"recNOZJxg2YRGVrfM","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Meseros"}},{"id":"recOMvwtiLiLQAZxt","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Salones de fiestas"}},{"id":"recOfXQRTQWaSwfom","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Refaccionarias de motos"}},{"id":"recQBzQcfyK0EVYCX","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Costureras"}},{"id":"recQX8p6z3CzcPfii","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Plomeros"}},{"id":"recRCJuGm6WCLk5am","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Llanteras"}},{"id":"recSPwFrsh0rGsbcj","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Pollería"}},{"id":"recSa5Ls9U7DGpQmI","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Vulcanizadoras"}},{"id":"recSyllt5kkBkWuFy","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Spa"}},{"id":"recT4weEhxvQyOZ7d","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Albañiles"}},{"id":"recTjtTLoYZ6nuQkF","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Curanderos"}},{"id":"recU1HkwRHCf6985F","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Escuelas"}},{"id":"recU4WtEkSfwz9GUw","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Gym"}},{"id":"recU9YRVgsXzEu5cj","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Librerías"}},{"id":"recUTX8QZ61vgcodn","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Productos de limpieza"}},{"id":"recUcG6Le6WyE7q7i","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Fotógrafos"}},{"id":"recVYBZLNKSrw0Pea","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Metales"}},{"id":"recVctAc9zc0qxJtU","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Aplicación de uñas"}},{"id":"recWenxedwyEIOECn","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Mercerías"}},{"id":"recXO0ENu1VDBpnMm","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Oftalmólogos"}},{"id":"recXis4yEpLcZPkYJ","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Reparación de electrodomésticos"}},{"id":"recXp6nRDowOOUXWv","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Carpinterías"}},{"id":"recYC8sMjOxUqqVQ6","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Madererías"}},{"id":"recYSi275Wa8HGOWs","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Taller de suspensión de carros"}},{"id":"recYzdZUAqtjWPr9I","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Jugueterías"}},{"id":"recaYs6XfQ3kj1Xj0","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Fruterías"}},{"id":"recahm0XFU331fU4G","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Taller mecánico de carros"}},{"id":"recbStmqr6sXIg5k2","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Desechables"}},{"id":"reccHoeziHN3l9AZ4","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Dulcerías"}},{"id":"recdWV35sRRyrCeB1","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Expendios"}},{"id":"recdkeqgQjjxRT7bt","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Pisos y azulejos"}},{"id":"recdx2lipdNYJRE0z","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Telas"}},{"id":"recev1IRY5XCOCnrK","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Cajas populares"}},{"id":"recfKDblWCWKfDuLT","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Fumigadoras"}},{"id":"recg5mm9NabsY6Y4O","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Grúas"}},{"id":"recgjXujzRI3sINHB","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Renta de carpas"}},{"id":"recgkFITje9qFjIW8","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Zapaterías"}},{"id":"rechJBJN4i3ZGhJ85","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Taller eléctrico para carros"}},{"id":"reciBFK77tSQr8KdP","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Paleterías"}},{"id":"reciyA5y6ON3aSNFC","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Tortillerías"}},{"id":"recj3QUybOV7LUsaH","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Gas"}},{"id":"recjZaDLnmFTpWsqv","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Pescadería y marisquería"}},{"id":"reckkcksNP8ZLdRKq","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Nutriólogos"}},{"id":"reckl13MP3aiX2ThL","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Plásticos"}},{"id":"recko0JJsNJ0cxEU2","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Panaderías"}},{"id":"recl7lrWybsnB5TxC","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Taller mecánico de motos"}},{"id":"reclCM13wEwKovdcF","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Tornos"}},{"id":"recly21elEt9FwkLy","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Hoteles"}},{"id":"recmVp6SqnkXu99e2","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Abogados"}},{"id":"recnCjhWUzhvFBZKt","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Radiografías"}},{"id":"recoAr4njLrxzLNES","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Mofles y radiadores"}},{"id":"recoFEkbqBPmhIiu2","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Quiroprácticos"}},{"id":"recodKTWnWKVjMbSc","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Estilistas"}},{"id":"recogTlAoWowBpa5i","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Cyber"}},{"id":"recpEh9o6xijuzfBo","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Renta de rockolas"}},{"id":"recpNRglrmSAqxto6","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Carnicería"}},{"id":"recpQNnQ3op6AAF5I","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Materiales para la construcción"}},{"id":"recpqQiFcoHRBzhNl","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Mesas de dulces"}},{"id":"recq4bB92B7EHfNHg","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Renta de mesas y sillas"}},{"id":"recqL8Q2BakqGnBzV","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Películas"}},{"id":"recqTsYYjzpPJoZHL","createdTime":"2022-05-19T16:16:25.000Z","fields":{"Categoría":"Reparación de refrigeradores"}}],"offset":"itrgtstcXoqdm6l06/recqTsYYjzpPJoZHL"}

Thank you for your support!

[jared]

have you tried this out?

Add search and filter capabilities using Airtable's API in your app

Project link: Project Link Purpose/description: Pulling in all data from Airtable can be too much sometimes. pulling in only the data you need, and having it presorted can save you time and processing power in your app. This project filters by Age and Sex, then sorts the data by age ascending. [Screen Shot 2022-05-24 at 2.33.12 PM] See how data comes in unfiltered when you remove the query parameters! Goes well with: Apps powered by airtable.

[tatiang]

A couple things I noticed:

1. When you get the green “response” block from an API call, its value is formatted in JSON. So you have to convert it to an object to be able to use the “get property of object” blocks in Thunkable. But you are using the “generate JSON from object” block. This is not correct. You need to use the “get object from JSON” block instead. I show an example of this starting at the 17:49 mark in the video I posted as part of my API tutorial: API JSON Tutorial (Video).

2. If I copy the text you posted (I re-formatted it above to add those ``` marks I keep mentioning because without those, the forum software formats quotes as smart quotes and it will look like the JSON is invalid) and paste it into Best JSON Viewer and JSON Beautifier Online, I can look at the property names in your response. I don’t find any properties called “Logo” or “slogan” or several other values in your screenshot above. I do see “Categoria” but that’s about it. So I’m not sure you’re getting the response you expect. That same tutorial video shows how to find the property names.