Empty text record shown

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.

0 6 255
6 REPLIES 6
Top Labels in this Space