Thread: Nesting Fixed set of Text Columns
View Single Post
Old 01-15-2021, 03:37 AM   #3
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,832
Karma: 30277270
Join Date: Mar 2012
Location: Sydney Australia
Device: none
I might have achieved something approaching what you want with:

This column definition ==>> Click image for larger version Name: Screenshot 2021-01-15 190312.jpg Views: 108 Size: 44.7 KB ID: 184746

And this setting ==>> Click image for larger version Name: Screenshot 2021-01-15 190445.jpg Views: 125 Size: 83.5 KB ID: 184748

The columns don't have a set of fixed pre-defined values, but I can use dot notation very effectively for categories that have a limited number of possible values, e.g. Mammals.Cats.Lion and Mammals.Cats.Tiger etc.

I use a similar column for Dates that have varying precision, such as: 1987, 1884.05, and 1995.07.29. I loathe having to conjure up false values.

BR
BetterRed is offline   Reply With Quote