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. 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