Q: Is it possible to have a UX text entry field without a backing column in a database?
I want the user to be able enter a weight in either LBS or KG. My design is to have a weight_value column, a weight_units column (constrained by ENUM) and a calculated weight_kg with a “Auto Compute > App formula” setting. All three columns would be present in the DB, to provide backing columns to the UX.
However, would it also be possible to have some kind of virtual (or similar) column (not DB backed) where weight_value and weight_units could be entered without the use of a corresponding DB column? Just want to make sure I am not missing something.