I have seen this error a few times over the course of several months while working in this app.
The app gives approval levels as โFirstโ, โSecondโ, โThirdโ and โFourthโ. Most approvals are done by โSecondโ and above.
Whenever the text โSecondโ is the beginning value in list of literals, the expression assistant throws an error of โunrecognized tokenโ. See example below
This is easily fixed by moving the literal text in the list so its not first but could it be an indicator of the parser not recognizing first value list tokens?
Expression where the literal value of โSecondโ is first in list - Error "unrecognized token"
By simply moving โSecondโ to the end of the list - the expression passes parsing
What if you use LIST() rather than curly braces?
I can try to see if that makes a difference. Even if it does, it seems there is still a bugโฆwouldnโt you agree?
Yeah, itโs merely a workaround. My impression is that using curly braces to define arrays is a hack of the underlying library. Curly-brace arrays have a number of quirks. This looks like another.
I cant clearly remember, but when i pushed hardcoded array with curly brace, I got error. In stead, i switch to list expression which made through.
Yes, sounds likes curly-brace is not recognized correctly on certain user cases, I hope Appsheet dev team review over it.
Confirmedโฆusing LIST(โSecondโ, โฆ) does NOT suffer the same problem as with curly braces.
User | Count |
---|---|
18 | |
11 | |
11 | |
8 | |
4 |