I am tyring to make a new app, something relatively basic just have something to start from scratch and try to retrain myself with a little more experience under my belt, and the hope that i will do a better job of planning from the beginning.
i am running into an issue already with trying to use the upper() function.
i have an enum data type column called [category], and the app is essentially going to be a fairly basic idea tracker to be used with our morning meetings where people come up with ideas to eliminate waste and make our jobs more efficient. the hope is that the app will help track ideas and testing on those ideas to record the outcomes. so the user would log their idea and assign it a [category] to show what department or area of work the idea focuses on.
i have a sheet called options_db and it has two columns, category and option. so the [category] column in the ideas_db table, as previously stated, is an enum with no hard coded options. i have added the following to the valid_if expression:
sort(
SELECT(options_db[option],[category]="category")
)
this works and displays the desired options, but i am wanting to convert all the values to uppercase. i tried using upper() in several areas but i am not getting the outcoming i was hoping for. i presume it is because upper() expects a "text" data type, and enum, and this column is list.
how do i get this all converted to uppercase in the UI? i don't mind the lowercase on the backend, but users will likely bark about it ๐
thank you
LinkedIn
Twitter
