Enum list of allowed values imported wrongly

AppSheet AppSheet Q&A
, ,
1

Hello.

I have an Appsheet that consist of a series of tables. Each table is connected to a spreadsheet, where for most columns I have some data validation rules (dropdowns with “Value contains one from range”).

The structure of the spreadsheet is something like:

Column A: Text, Column B: Text, Column C: Dropdown (enum), Column D : Dropdown (enum)

When setting the column type to enum, and regenerating the schema, it usually imported the list of allowed values for each enum column correctly.

However, when trying to do this, I am getting the following list of allowed values in the enum columns:

List of allowed values for Column C: Values in Column A

List of allowed values for Column D : Values in Column B

Any ideas what could be the issue here?

2

What are your formulas in the Valid_If or Suggested values in these two columns?

3

I have nothing either in the Valid_If or Suggested values in those two columns.

As said, Appsheets was previously importing automatically into the “Values” property each of the allowed values in the Data Validation in the spreadsheet, but now the Values entered there are the ones in my column A, B, C and so on, instead of the ones that I included in the data validation.

4

I finally solved this by creating an auxiliary table that contained all of my dropdown values, and setting the columns in my original table to type ref. By using the Valid_if field, I selected which rows were the corresponding dropdown option for each of the fields.