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.