Working with ENUMs in Forms and Update / Insert Queries

ENUMs are a confounding data type when used in data entry / edit forms and update / insert queries:

  • If I try to insert or update Retool DB table with a GUI mode Insert or Update and provide the object, I get an error that the ENUM value from the form (the .value property of a Select component) is not in a valid format. So, I have to use the key / value pair method.

  • This appears to be required because a Select .value property sometimes is an array and sometimes a string, which seems weird, but I've watched it happen.

Is the above expected behavior? Am I using ENUMs incorrectly by populating a Select with the ENUMs (as both .value and .name)?