Appsheet introduce new features, OCR and other useful functions, they returns the values to the data fields as LIST types like {50, 80, 150, 300}
However, the important feature we are missing which have been discussed with the community.
In short, we are missing feature to “reconstruct the list with given conditions”
This is something like controlling “array” with forEach syntax in programming languages with “where” conditions.
Just borrowing name of JS function of forEach to make it clear, so the new expression is something like
ForEach([ListTypeDataField], “EachItem” >= 100) to return new list.
For the condition part, we are able to use existing appsheet expression off course, like
ForEach([ListTypeDataField], Contains([ListTypeDataField],“ABC”))
Somethin like intuitive expression desired.
Thank you for consideration.