- LIST("") | This doesn't seem to be working all that much for me anymore, anyone else?

[MultiTech]

Let's say I've got a list of child records, and out of those I wish to extract a sub-list of reference IDs - excluding any blanks, as there is the possibility of the field being blank.

To do this I would do something like

UNIQUE(
  [Related Whatevers][My_Column]
  - list("")
)

_____________________________________________________________________________________

For the past few days, this hasn't been working all the time.

• Especially when I send something off to a script; the scripts are now having to deal with empty values.

Anyone else seeing this as well?

[AleksiAlkio]

Hi Matt, for me it seems to be working just fine.

[Suvrutt_Gurjar]

Yes, it seems to be working fine for me also.

[Koichi_Tsuji]

Hi @MultiTech 

I saw the similar issue to deal with list (array) value using -LIST("") syntax, which would remove the duplicate. The consequence on the surface of the app is FORM view is broken (on the new desktop ux) while the blank view is presented with the legacy UX.  

I believe your error would disappear once you remove -LIST("") expression, i.e.

UNIQUE(
  [Related Whatevers][My_Column]
)

[Denny774]

Hey man,

have you tried this yet?

SUBSTITUTE(UNIQUE(
[Related Whatevers][My_Column]
- list("")
), ",", " , ")


😁