Select a value from an Enumlist of another table

AppSheet AppSheet Q&A
1

Hello everyone, a question. I thank you in advance.

I have a table 1 with a list of values, that list is type “Enumlist” of BaseType Ref in another table 3.

I have another table 2 from where I need to select some of the items that are in that box.

What type should the column in table 2 be?

What expression should I use if lists are only available in virtual columns?

I will try to explain myself better:

I am in table 2 and I need to be able to select the content of a row in a column A of table 1.

In table 1, the column A that I want to select is of type enumlist, with which, I can bring these values by dereferencing column A [Table 1].[Column A]; I enter point because I need only one row and not the whole column; if I didn’t put point, all rows would be selected.

Now, once the row [Table 1].[Column A] is fetched, I get an enumlist full of values separated by a comma.

To these values I need to see them in the form of a list to choose 1 of all of them and I don’t want to choose more than one.

How I do this?

Thanks

2

I don’t fully follow your question. In case it’s helpful:

  • If you have a value comprising a concatenated series and you instead need that to be a list of separable values (e.g., to enable the user to select one value from the series), use the [SPLIT](AppSheet function list - AppSheet Help function to convert it to a list.
2 Likes
3

First of all, thank you for your time and acknowledge that you are always answering my questions. Greetings from Argentina.

I was not aware of the Split function, but to tell the truth it is very useful for me. I thank you for the answer.

2 Likes