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!
@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.
Please go through the help article
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".
Please make the field specialist as label of the dropdown_specialist table
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.
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.
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |