Hi!
I have an expression that splits text in two parts:
substitute(
index(
split(
concatenate(unique([Combined list])),
concatenate([Current session number]," , "))
,2)
," , ",", ")
Sometimes the result is text that looks like this:
5,15, 34, 89
And sometimes the result is empty (nothing after the split).
My problem is that the record is shown even when nothing is in it. Iโve been able to hide such empty records with the following condition in the โShowโ spot:
len([Name of column])<>0
Still, I wonder why AppSheet doesnโt hide it automatically. Empty records are usually not shown.
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |