Array function SORT() not working in field setting "field value expression"

🧩 Low-Code Development
#1

I am trying to generate field content in a module by using existing field content. Sort of like an extra ID for, e.g., sorting.

The existing (filled) fields in the module are called

  • elter1_nname
  • elter2_nname

The field that will contain the generated ID is called familien_ID.

The field value expression of familien_ID should be:

join(sort([elter1_nname, elter2_nname],false),"_")

This generates the following error when creating/editing a record in the module on a dedicated record editing page:

cannot compare struct and struct. unknown state

Using the following field value expression works:

join([elter1_nname, elter2_nname],"_")

and results in the record field familien_ID being filled with <elter1_nname>_<elter2_nname> as expected.

This means that it seems to be the array function sort that doesn’t work.

Can anyone point me to my mistake, please?

#2

We avoid using field expressions as they are quite restrictive. Refer the docs.

We would use a workflow for your use case.