Multiselect Dropdown

[Romulo88]

Hi everyone,

i started working in Appsheet and I am currently facing a challenge.

I have a field "Specialist" within the Table "Projects". I want to set the field "Specialist" as a dropdown field. The list of "Specialist" should come from another Table (lets called "dropdown_specialists"). My users should have this drop down list as a multiselect value. Specialists name should be stored and separated via ",".

Is this possible?

Thanks in advance!

[balanis]

@Romulo88 it sounds like you might want to do an Type:Enumlist, Base Type: Ref, and select your Table that has the list of specialist. In that same setup you should be able to set yourItem separator. 

[Suvrutt_Gurjar]

Please go through the help article

https://support.google.com/appsheet/answer/10107665?hl=en#:~:text=AppSheet%20displays%20a%20drop%2Dd...)

[Romulo88]

Hi, i saw the post but it was for me unclear the topic ref. I place reference and select the Table "dropddown_specialist". However the table has more than 3 columns (row, id, specialist, level). How do i pre established that the dropdown multiselect will display the values from the column "specialist".

[Suvrutt_Gurjar]

Please make the field specialist as label of the dropdown_specialist table

[Romulo88]

Thanks for the response. I do habe a dropdown option (using ","). What is the difference between Base type  "Text" and "Ref"? I selected the "Text" option because with "Ref", It displays an yellow icon next to the field.

[balanis]

Its likely that you might need to specify suggested values as well. In the expanded type field navigate to Auto Compute > Suggested Values > TableName[Key]. This should take care of the warning.