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

mpibanez · 06-07-2023 10:42 AM

Hi,
It is possible to limit the number of data selections ?
What I did was create the data from a google sheet, in this way the users visualize the name of the column and then, the options to check off from the rows:
1.

2.

It is possible to limit the number of selections?

I try with COUNT([_THIS])<=5 in the valid if filed of the column but it didnt work.

Thanks!

Marc_Dillon

Yes, you should always start by explaining your setup.

So are you trying to limit the number of selections in the Evaluciones[Aguilidad Mental] column? That's where you put the COUNT() valid_if expression.
You can remove that existing valid_if expression, because Ref columns don't need them unless you're wanting to filter the referenced table in some way, which you aren't.
If you do need that in the future, put it in SuggestedValues.

View solution in original post

Is it possible to limit number of options chosen from a Text type?