Merge an ENUMLIST & Select() into another ENUMLIST

[1minManager]

I’m trying merge two lists into a single ENUMLIST so the use can check off various items. So the simplified formula for the suggested value is:

ANY(Select(Table[ENUMLIST],[Something]=TRUE))
+
Select(Table[TEXT],[SomethingElse]=TRUE)

Lets say that ENUMLIST=“a,b,c” and the select function pulls in “1”, “2” and “3”. What I’m seeing is:

a,b,c
1
2
3

whereas I want to see:

a
b
c
1
2
3

I’ve tried wrapping either, both and all in a LIST() equation. If anything that makes them group more.

Anyone have any idea what I’m doing wrong?

[Steve · Accepted solution]

Try:

SPLIT(Select(Table[ENUMLIST],[Something]=TRUE), " , ")
+
Select(Table[TEXT],[SomethingElse]=TRUE)

[1minManager]

@Steve awesome, that works!

[Ben_Rix]

This merge enumlist works great for single text values, however, say I have an enumlist that uses more than one word, for example

This piece of text,Another piece of text,Last/end piece of text

I would like to have a list produced as below

This piece of text
Another piece of text
Last/end piece of text

Are there any workarounds to produce a list like that?

[1minManager]

Create a list then display it in the App as an ENUMLIST?

[Aurelien]

Hi @Ben_Rix

The key-expression in @Steve 's answer is SPLIT, which use " , " as delimiter.
The number of words does not impact the expression, in my opinion.

Did you try it ?

[1minManager]

@Aurelien is right. Using SPLIT you get to define the break points. You’re only real issue maybe if you have a string of text with commas in

[Rafael_ANEIC-PY]

But if that’s the case you could just CONCATENATE() everything using a different separator, then split by it with SPLIT()

[1minManager]

Another good point @Rafael_ANEIC-PY . In an ENUMLIST you can specifiy the separator as well

[Ben_Rix]

Yeah ive tried it. I can only get it to separate by a space. Im just trying out a few test runs now with different data to see what the outcomes are.

The results I’m currently getting are:

[Aurelien]

try

SPLIT(Select(Table[ENUMLIST],[Something]=TRUE), ",")
+
Select(Table[TEXT],[SomethingElse]=TRUE)

(blank spaces around comma: out)

[Ben_Rix]

Ive i tried that aswell, blank spaces out. with no luck.

Is the delimiter not the resulting delimiter? Not the determining delimiter.

[Aurelien]

Ben_Rix:

Is the delimiter not the resulting delimiter? Not the determining delimiter.

No idea.

We will have to wait for the mega-master @Steve’s opinion
Unless @1minManager and @Rafael_ANEIC-PY have another idea ?

[SkrOYC]

General advice.

Never touch the Item separator under the EnumList column config. It really makes no sense why AppSheet allows us to change this. It should be automatic based on our language (similar to how .CSV files work)

Since you already did, the best long-term way to solve this is the following:

1. Go to your EnumList column config and change the item separator to be " , ". You can delete all of the actual content and then make sure to type space - comma - space
2. Go to your database and replace all the separators that are there in the fields to " , ".
   1. If your data looks like Text 1, Text 2, Text 3 you have to replace ", " for " , "
   2. If it looks like Text 1,Text 2,Text 3 you have to replace "," for " , "; you got the point
3. After that, you can use @Steve’s expression

[Ben_Rix]

Thanks so much for that, it worked!! Really appreciate the help everyone.