Hi, everyone How does one create an enum lis...

AppSheet AppSheet Q&A
1

Hi, everyone

How does one create an enum list from a google sheet and show it in a multiple selectable form entry in my AppSheet app?

I want to reference to selected column from a different table rather than use a predefined value in enum list defined in app sheet.

2

Enumlist column type will give you a multi-selection dropdown list.

You can populate that list from a table. Check out this page for more details: http://help.appsheet.com/app-design/modeling-tables-and-columns/the-lookupdropdown-data-pattern help.appsheet.com - The “Lookup/Dropdown” Data Pattern The “Lookup/Dropdown” Data Pattern help.appsheet.com

3

Also this link has useful information: http://help.appsheet.com/ux/dropdowns-in-forms/dropdown-from-valid_if

4

Thanks but it did not help much as what i’m trying to do is have dynamic items in my form which are ref from a different table.

5

Yes, I understood. Read the articles in the links I sent you. It explains that you can populate your dropdown list from a table using Valid_if

6

Thanks i’ll try this

7

Hi guys, I think to have a similar problem with creating a dropdown with multi-filtering values. Maybe some of you can help me to fix it:

[Filter/select depends on a particular list of values](https://community.appsheet.com/t/filter-select-depends-on-a-particular-list-of-values/22611) Questions

Hi guys, I have a problem with creating a dropdown or a list filtered considering multi values. My app is for quick search equipment can match with compatibles accessories. I have 2 main dataset: EQtab where I record all equipment ACCtab where I record all accessories All records in both tables has 3 column type YES/NO indicating the compatibility category: [Cat1], [Cat2], [Cat3]. So I’m creating a table called SEEK to record all research for each user. This tables has [IDcolumn], [UserI…