If I create an enum or a y/n column type, is there a way to add other kind of value in the cell?
Eg: If they select Yes, to add a value of 1 instead of true.
Short answer: no.
But you database may not take true/false but take 1/0 instead.
One possible approach and workaround is you create simple/independent table like this.
On your target column, set the column type to ref tyle to refer to this new table.
Set Value column as ID/Key as well as Label column as label.
I thought about this, but I have diferente answer values depending on the kind of question.
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |