Today, I would like to request updates to the functionality of these two expressions.
AppSheet’s TRIM currently only removes extra spaces at the beginning and end of a string. Excel’s TRIM does the same but also removes all but a single space inbetween words. I would like for AppSheet to match this functionality, perhaps, by adding a optional argument on which version of TRIM is used (I feel like that would help maintain any backward compatibility).
FIND(needle, haystack) is a great little expression. Currently it returns with the character position of the needle within the haystack or 0 if not found. And while it technically seems to work with non-Text columns, it does seem to auto-concat the haystack and treat it as a string anyway. I would like FIND to get updated with handling of lists, in which it returns the INDEX number of the result. We can use IN to get a true/false. We have INDEX to pull a specific piece out of a list. But we have no good way to compute where in a list a particular option is. This will also allow for fun with
INDEX([SomeList], FIND("ME", [SomeList])+1) - Who, if anyone, is after me in this list?
CONTAINS could probably also benefit from this update. IN works to check if there is an exact match within a list. The same kind of update to FIND would also benefit CONTAINS as being a looser way to match in a list. i.e. Does any item in this list contain
Basically, on the backend, all I’m asking for is checking if the haystack is a list, and loop through it since us end users can’t create any kind of loops.