Pre-populate enum values from GCP MySQL Database?

[HSAI]

Hi all, 

Question for mysql users...

I have a mysql database with an ENUM field type. Is there a way to get Appsheet to pull through the values I have defined within the database? When I add them in manually, they are all dropped whenever I "regenerate column structure" 

Thanks 

[Marc_Dillon]

How are they "defined within the database"?

Column configurations typically shouldn't be changed upon regeneration, unless you're changing the name of the column.

[HSAI]

Hi Marc, The Datatype is ENUM('option 1','option 2')

[Marc_Dillon · Accepted solution]

Ahh, I see. I don't believe Appsheet has support for that. If it doesn't pull in automatically, then there aren't any other options to force it to. I just tested it too, it correctly assigned the Enum column type, but did NOT pull in the options. 

You could set up another table with your enum options, then use valid_if to pull them in.

https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if