# filterByFormula via AirtableAPI
**URL:** https://community.thunkable.com/t/filterbyformula-via-airtableapi/2226104
**Category:** Questions about Thunkable X
**Tags:** beginner
**Created:** [January 17, 2023, 8:20am UTC](https://community.thunkable.com/t/filterbyformula-via-airtableapi/2226104 "2023-01-17T08:20:40Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)
#### Post date: [January 17, 2023, 8:20am UTC](https://community.thunkable.com/t/filterbyformula-via-airtableapi/2226104/1 "2023-01-17T08:20:40Z")
Dear All,
I am trying to retrieve information from 2 different table via filterByFormula, what happens is it gives the right information for the first time , later the datasource blocks automatically updates to the last search i.e recordid and index.
Sharing the blocks :
A)
Another table:
B)
A & B- are the one where the record id and index gets changed as per the last search though different variables are used to store.
Can’t we use two Airtable API in one app ? Also can we use And & or operator in filterByFormula?
Your valuable assitants and input is highly appreciable.
Regards,
Sasi Preetha
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [January 17, 2023, 8:47am UTC](https://community.thunkable.com/t/filterbyformula-via-airtableapi/2226104/2 "2023-01-17T08:47:54Z")
Yes, you can use AND and OR in _filterbyformula_. See this: [The AirTable API (a more efficient way to integrate AirTable with Thunkable) - #22 by jared](https://community.thunkable.com/t/the-airtable-api-a-more-efficient-way-to-integrate-airtable-with-thunkable/1021167/22). And you should be able to access multiple tables using the Airtable API.
The `get value` blocks sometimes do not return updated values. Are you having a problem with the API not returning the correct values or with the data source blocks not returning the correct values?
Are you `app variable featurerecordid1` list items row ids for Airtable? Because typically, you would use an **integer** for the row id. See this: [I want to search in DataSources and get the column ID - #2 by tatiang](https://community.thunkable.com/t/i-want-to-search-in-datasources-and-get-the-column-id/1766281/2)
---
### Author:  [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)
#### Post date: [January 17, 2023, 10:23am UTC](https://community.thunkable.com/t/filterbyformula-via-airtableapi/2226104/3 "2023-01-17T10:23:10Z")
Thank you for your response. Probem with Data source .
app variable featurerecordid1 list gets the row id .
I used 2 table. for one table I used list as recordidloca2 to get the row id and for the second table I used list as featurerecordid1 to get the row id .
Then to retrieve the full details of that row I passed listviewer index .
Actually what happens is though I use 2 different list names and 2 different index the variable name automatically gets updated with the same name which is strange.
Sharing my project link.
[https://x.thunkable.com/copy/319a0b58fa47d60476b8084634627ff0](https://x.thunkable.com/copy/319a0b58fa47d60476b8084634627ff0)
Will try And and or suggested bt Jared and share my input.
---
### Author:  [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)
#### Post date: [January 17, 2023, 12:20pm UTC](https://community.thunkable.com/t/filterbyformula-via-airtableapi/2226104/4 "2023-01-17T12:20:54Z")
Via Or in filterbyformula worked.
sharing the blocks.
Thank you so much for your assistance.
---
### Author:  [@system](https://community.thunkable.com/u/system)
#### Post date: [April 17, 2023, 12:21pm UTC](https://community.thunkable.com/t/filterbyformula-via-airtableapi/2226104/5 "2023-04-17T12:21:50Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.