Solved: Is it possible to limit number of options chosen f... - Page 2

neardj · 02-26-2021 07:20 AM

Hi,
I am developing my first App with AppSheet.
I created an “EnumList” column that uses “Ref” as the “base type”.
I tried to do as suggested in this topic: https://community.appsheet.com/t/is-it-possible-to-limit-number-of-options-cho/2789/2?u=neardj

but in my case it doesn’t work.
On “Valid IF” I have this formula: T_ROSA [ID_CICLIST] (which I use to retrieve the data for the EnumList) how can I also add the formula: COUNT ([_ THIS]) <= 8 ? (I want to limit max 8 choise)

Finally I wanted to ask you if you think it is possible that each value chosen by the EnumList goes on a new line instead of in a list delimited by a separator.

Thank you
Neardj

Steve

The fix I offered previously:

LIST()
+ SELECT(
  T_ROSA[ID_CICLIST],
  OR(
    ISBLANK([_THISROW].[IDSQUADRA]),
    ([IDSQUADRA] = [_THISROW].[IDSQUADRA])
  ),
  TRUE
)

View solution in original post

Is it possible to limit number of options chosen from an EnumList with base type "Ref"?