Hi there, I just discovered AppSheet a few weeks ago, and feel like a kid in a candy store! What an incredible platform, have been looking for something like this for years.
I am going through the documentation now, and have a question about this example:
SELECT(Students[First Name], TRUE) : A list of first names (possibly with duplicates) of all students. Equivalent to
Students[First Name] ."
I just can’t figure out why this expression would possibly result in duplicates. Doesn’t distinct-only? being TRUE mean that there should definitely be NO duplicates?