Problem with Slice, Ref and Enumlist

AppSheet AppSheet Q&A
1

I am having problems creating an Enumlist which allows me to choose several users from the list.

I have created one user table named Mission Team. In this table I have all users. I have a yes/no column named Active. This allows me to filter on users who are currently active in the organization. I also have a column named Group Name, which divides my users into three groups (Team, Volunteers and Retreatants. I have created slices for each group of Active and Not Active Users. I have also created a view for each slice. Those views correctly show the information. So, when I look at the Volunteers Active slice, it shows me only the currently Active volunteers. All good so far.

I have created another Table called On Site Teams. I want to be able to assign one or more Volunteers and one or more Retreatants to various job sites. In this On Site Teams table I have two columns, one is Volunteer ID and the other Retreatant ID. I have designated each as a Ref type column. Since I am having the same problem with both columns, I will only discuss the Volunteer Column.

In the Volunteer ID column, I have chosen a Ref type, and the Source is the slice I created called Volunteers Active (slice), and I selected the Dropdown option. I have no Valid IF or other filters. When I then go to the On Site Team Form and select the Volunteers ID box, I see a correct listing of the Active Volunteers. But the list will only allow me to select one Volunteer. It appears to be an Enum list and not an ENUMLIST.

If I change the Volunteer ID column to an ENUMLIST type, and the Base Type to REF and the Referenced Table Name to Volunteers Active (slice), the On Site Team Form displays no names in the Volunteer ID dropdown box. I have no other expressions, Valid If or App Formulas.

How do I make this work as an ENUMLIST to allow several volunteers to be selected?

2

When using EnumList of Ref, you must use either Valid if or Suggested values to generate a list of options.

3

I am not a programmer. Can you give me an example? I had tried to enter a Valid IF. Also tried Suggested Values. In both cases my expression did not work. I did not seem to be able to access the Slice I was referencing. I tried something like Volunteers Active[Row ID},True I also tried several other but could not come up with a good Enemlist. Any help is appreciated.

4

The “lookup/drop-down” data pattern

5

Prompted by a different post, I looked into this behavior deeper. It appears the Enum column type is broken. Please contact AppSheet Support for help with this.

Attn @AleksiAlkio @Adam-google

6

I was able to resolve this problem. I added the same expression in both, the Valid IF and the Suggested Values. It took me a bit to get the expression syntax correct, but I finally got it. I used the following for the Volunteers

SELECT(Volunteers Active[Row ID],True) and it did the trick.

Thanks for the help. I struggle with the expression syntax and getting it correct.