[Solved] Retrieve data from Airtable based on condition

Hi,

First of all you need to get all records from a table in a list with a block of “getAllRows”. After that, local storage will contain all data from the table and they can work on any screen. List filterList stored filtered on two fields a “email” field and Age. This list is assigned to the ListViewer and it displays only the values for the field Name (values of _id non visible). Selecting from the list with the value of the Name field is also a unique key of _id entry in which the entry can always be found.

Working with the list of records is less effective than database queries. But the algorithm shown is universal and requires only one query to the database to retrieve data. After that you can do with the data whatever you want.

8 Likes