So, this most likely to related to Inline views change? issues, but I specifically have an real EnumList of Refs that I use for editing usage. I have a VC List of Refs with an app formula that just points to the EnumList that I use for display. It works just fine, however, the count that has now moved to the label only shows (1) regardless of the number of entries:
This seems to be a bug in which AppSheet is parsing the list incorrectly for counting purposes. I believe it counts the list as a single string, before it recognizes the three individual references.
If I try to concatenate/split the EnumList to force a new count, AppSheet forces the element type to Text and obviously breaks the view, but the count is right and text is technically correct.
If I try to create a new SELECT statement using the IN and SPLIT expressions to see if each item is in the EnumList, a completely different thing happens. It will let me set it to Ref, but then after saving AppSheet changes the target table to an all caps version of the name, gets the right count number, but fails to display any of the entries.
SELECT(SubCategories[SubCategory], IN([SubCategory], SPLIT([Flavor_SubCategories], ", ")))
If I don’t split the EnumList is the example above, the IN function will fail to accurately match and the reference table still gets forced all caps.
So, I guess, the point of me making this post is to point out the unexpected differences in how these are being handled and hopefully get whatever is causing this fixed. I have yet to find a solution that gets me the best of both worlds. But at this point I’m not sure if I can, in this instance, for now.