# filterByFormula against AirTable part 2
**URL:** https://community.thunkable.com/t/filterbyformula-against-airtable-part-2/2928297
**Category:** Questions about Thunkable X
**Tags:** airtable
**Created:** [April 4, 2024, 12:40am UTC](https://community.thunkable.com/t/filterbyformula-against-airtable-part-2/2928297 "2024-04-04T00:40:50Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@steve\_synopsis](https://community.thunkable.com/u/steve_synopsis)
#### Post date: [April 4, 2024, 12:40am UTC](https://community.thunkable.com/t/filterbyformula-against-airtable-part-2/2928297/1 "2024-04-04T00:40:50Z")
Hi,
There is a very [informative thread](https://community.thunkable.com/t/filterbyformula-via-airtableapi/2226104) on performing a filterByFormula against an AirTable base.
While this shows a solution for passing more than 1 search variable, I am trying to get a search done against a View.
The API call ([https://api.airtable.com/v0/\*\*\*base\*\*\*/\*\*\*table\*\*\*?filterByFormula=AND({reg}=“D34”)&view=OdoDateTime](https://api.airtable.com/v0/ ***base*** / ***table***?filterByFormula=AND(%7Breg%7D=%22D34%22)&view=OdoDateTime)) works fine in Postman.
However, when I try various implementations in Thunkable -
and this
I get
```auto
{"error":{"type":"INVALID_FILTER_BY_FORMULA","message":"The formula for filtering records is invalid: Unknown field names: view, ododatetime"}}
```
Would appreciate any assistance.
Thanks
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [April 4, 2024, 1:54am UTC](https://community.thunkable.com/t/filterbyformula-against-airtable-part-2/2928297/2 "2024-04-04T01:54:29Z")
It’s really helpful that you included the link to that original topic because it explains what you have reviewed and also gives me a refresher about this tricky object creation for Airtable’s API.
The first screenshot looks right to me. Is the `create object` block connected to a `QueryParameters` block? And are you using a `Get` block to contact the API?
As a troubleshooting step, if you use the first screenshot’s configuration and set a text input’s text (so you can copy and paste here) to output the formula, what do you get? The easiest way to do that is probably to set the text input’s text to the `join` block.
I’m not sure it will work but Airtable has changed in certain ways since that original topic. Have you tried entering the entire url ([https://api.airtable.com/v0/\*\*\*base\*\*\*/\*\*\*table\*\*\*?filterByFormula=AND({reg}=“D34”)&view=OdoDateTime](https://api.airtable.com/v0/ ***base*** / ***table***?filterByFormula=AND(%7Breg%7D=%22D34%22)&view=OdoDateTime)) as the Web API url and not worrying about the query parameters? I think you would format it as
`https://api.airtable.com/v0/ ***base*** / ***table***?filterByFormula=AND(%7Breg%7D=%22D34%22)&view=OdoDateTime `
---
### Author:  [@steve\_synopsis](https://community.thunkable.com/u/steve_synopsis)
#### Post date: [April 4, 2024, 12:26pm UTC](https://community.thunkable.com/t/filterbyformula-against-airtable-part-2/2928297/3 "2024-04-04T12:26:02Z")
@tatiang I figured it out - was staring me in the face [another post](https://community.thunkable.com/t/the-airtable-api-a-more-efficient-way-to-integrate-airtable-with-thunkable/1021167/44) -
Steve
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [April 4, 2024, 3:13pm UTC](https://community.thunkable.com/t/filterbyformula-against-airtable-part-2/2928297/4 "2024-04-04T15:13:44Z")
Oh! That makes so much sense now. Thanks for posting the solution!
---
### Author:  [@steve\_synopsis](https://community.thunkable.com/u/steve_synopsis)
#### Post date: [April 4, 2024, 5:47pm UTC](https://community.thunkable.com/t/filterbyformula-against-airtable-part-2/2928297/5 "2024-04-04T17:47:23Z")
Slightly more complicated now. Want to run a REGEX\_MATCH to find a value contained in a cell.
The URL is [https://api.airtable.com/v0/base/table?filterByFormula=REGEX\_MATCH](https://api.airtable.com/v0/base/table?filterByFormula=REGEX_MATCH)({fruit}, “grape”) tested in Postman.
I tried this in vain -
Thoughts??
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [April 4, 2024, 10:34pm UTC](https://community.thunkable.com/t/filterbyformula-against-airtable-part-2/2928297/6 "2024-04-04T22:34:51Z")
Fruits missing curly braces. Your searchfruit value is missing quotations.
---
### Author:  [@system](https://community.thunkable.com/u/system)
#### Post date: [July 3, 2024, 10:34pm UTC](https://community.thunkable.com/t/filterbyformula-against-airtable-part-2/2928297/7 "2024-07-03T22:34:58Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.