Filter (airtable populated) list by search term?

[karimoo]

@bgschust Now back at the big screen and system I did some testing with the Airtable API using Postman.

1. You an only have ONE filterByFormula. Adding to filter in Adalo will throw an error in Airtable:
   

   

2. It is possible to combine Search with filtering on fields Using AND:
   

   

My Example is using Treatments instead of your User ID:
AND(({Treatments}=‘PRP’),Search(LOWER(‘Karim’),LOWER({Patient})))

=> You are just missing some brackets for the first part.

Should be:
AND(({User ID}=‘User user id’),Search(LOWER(‘Search 38’),LOWER({Name})))