Select(), Filter() or Lookup()

After a number of AppSheet prototypes and exploring Select, Filter and Lookup functions. Am I right to say that Filter is used when there are more conditions to be checked, Lookup is a more generic way to return data if there are similar records in the database, and Select is for getting specific data. There are specific ways to get data in Filter and Lookup as well. Also, the datatype also matters when forming expressions with filter, select and lookup.

1 Like