I am sure that there is a formula for this but I can’t seem to find it or I don’t write it in a correct way.
With a API service of a third party software I pull data from my Airtable. This data is dynamically filtered by using filterByFormula. The data I need is in the column called “groupcode” and has numeric values varying from 100 and 900. These numbers stand for product categories.
Normally if I need products from the category with the number 212 I use the following formula.
But now I need products from category 212 and 268. Is there a way I can display only the records of two different specifc values ?
Go to airtable.com/api and it will show you how to properly construct your API call for the “list records” GET request. It’s pretty awesome because it will give you actual examples based on your own base.