Multi-Select Text and Image Label Rows

Hello All,
I have an issue I have been working on for a few days and keep getting stumped.

I have two tables 1) Cookie Cutter Inventory and 2) Orders.

I have a field in the orders table where I want the user to be able to choose from the list of Cookie Cutters in the Cutter Inventory. This is simple enough, but there are some additional criteria…

  1. What I NeedThey need to be able to select multiple cookie cutters. What I’ve Tried: Tried a REF column but couldn’t choose more than one cutter. So, I’ve made the column an ENUMLIST with a ValidIf statement for the Cookie Cutter Inventory Table. However this only allows me to display either the cutter name or a photo, leading to requirement 2.

  2. What I Need User to see both name and photo of cutter when selecting from list. The end result that is put in the field can be either just the image or just the text but I want to see both when they are choosing What I’ve Tried: ValidIf Statements work for one or the other but I can’t get it to show both. If I do text and a validif statement for the cutter name I get the name and the same for the photo.

3.What I Need A way to search the within the list when selecting an option. Some users may have hundreds or thousands of cookie cutters so scrolling through all the photos and/or names wouldn’t be as efficient as if I could start typing in the name and have the list narrowed down.

I’ll include some photos below! Appreciate the help!

One last thing…when I tried EnumList basetype ref pointing at the cookie cutter inventory table I get this

I believe you could have both Cutter name and image columns in Cutter table defined as label columns so that both will display in Enumlist selection. AppSheet allows one image and one text column as labels simultaneously.

In the Orders table, please make the Cutter table key column as Enumlist type with base type as reference.

1 Like

Sadly it’s still not working. The frustrating thing is that it was working before and I’m not sure what happened. I’ve included some photos to show how I tried to implement your suggestion if you can see if its right…Do I need a Valid If formula?

As suggested, in the orders table, please make the base type as ref instead of image and reference table as “cutter table”

1 Like

Woops I overlooked that. Changed it and now I’m just getting a blank list :thinking:

Could you mention what warning you are getting in that column setting.

1 Like

Column Name ‘Cutter Used’ in Schema ‘Orders_Schema’ of Column Type ‘EnumList’ should have a list of allowed values or allow the user to add other values.

I have allowed other values…

Please make the display , sorry input mode as “dropdown” for that column.

Edit: changed display to input

1 Like

Also is the column set as editable?

1 Like

Yes editable and dropdown selected. Still nothing returned on the list.

Thank you please set " auto complete other values" to yes

1 Like

Yes this was selected and it is till returning a blank popup with no values to select.

Thank you. I believe it is one setting that is causing issue.

I will revert in case I find something concrete. Of course, each previous suggestion I had tested on a test app and the functionality is working correctly at my end.

Could you update what is the key column of Cutters table.

1 Like

Thank you so much for all your time trying to help me! I’m new at this so I really appreciate it!

The Key Column is called Cutter ID and uses the UNIQUEID() expression to populate.

Thank you. Nothing that immediately occurs remaining to be tried.

I will revert in case I find a solution.

Just to be doubly sure that all settings of the enumlist column are as required, you may wish to reshare all the settings of that Enumlist column.

1 Like

Hi Brittney_Neal. I have exactly the same problem. Even thinking that there was something wrong with the definitions, I made another couple of example tables to create a case of EnumList Type ByRef and the exact same thing happens to me. THE LIST IS EMPTY !!!
Have you been able to solve it?