Enum Column and Google Sheets Data Validation

[Apalila]

So I have a column called Company Name on a table called  Company PoC (Company Point of contact).

The Column Company Name is an Enum column who's values are given via a list provided through Data Validation on Googlesheets where the list of values is pulled from another sheet called Company under the column Company Name (The list of companies these Points of Contact could belong to).

My issue is, under Form View, I cannot assign my PoC's to any company! If I manually add the PoC on the sheet then select the company, that company will show up on the Form as an option. 

How do I fix this so all Companies show as an option on the form?

[Steve]

I'm afraid I can't make sense of your problem. Could you restate it another way?

[Austin_QREW]

Hi @Apalila,

To show all companies on the form view you could make a table called Company like this example below: 

Company Table

ID	Company Name
fdAsf21d	Target
fdas78sD	Wal-Mart

This table would be the Parent Table of the Company PoC Table shown in your database above. Then rename your Company Name column to Company ID in your Company PoC Table and set this column type to Ref and the referenced table would be the Company Table. Once this is complete simply add all of your companies to the company table and set the Company name as the label and you will be able to see all of your Companies in the Company PoC form view. 

Also, if you use this method you can setup Interactive Dashboards for filtering data. 

Alternatively, you could enter all companies in your Enum Dropdown list and allow other values. 

Hope this helps let me know if you have any questions. 

Thanks!

Austin from AppSheet Training

[SkrOYC]

---

@Apalila wrote:

the list of values is pulled from another sheet called Company under the column Company Name (The list of companies these Points of Contact could belong to).

---

Add the table where the companies are to AppSheet and then add this as Valid_If or Suggested Values, depending on your need:

UNIQUE(TableName[ColumnWithCompanyName])