How can a calculation be typed and hidden

Hello,
We are looking for a possibility to use a calculation for a dedicated type (other than calculate), like select_one (or date), but to hide it. This will have advantages for tabulation and data export (and for example SPSS import), as we can get a fixed type and the related labels (even in more than one language.)

image

Example age group, based on age, see XLSForm.

  • calculate type or hidden type will not allow a select_… type
  • disabled option (undocumented) will not even do the calculation. See table view (and export).

XLSForm
Age04.xlsx (15.2 KB)

Table view

Export

Age Groupe d’âge (calculé) Groupe d’âge (hidden) Groupe d’âge (calculate) _id
6 05-09 ans 5 5 255881367
17 15-17 ans 15 15 255881370

The Online validator gives a warning, related to the specification.
image
But relevant is not what we need here!

@Xiphware Might there be any advanced options, like using a bind (column)?

See also some previous discussion in the forum:
https://community.kobotoolbox.org/t/make-select-type-hidden-ui/17169
https://community.kobotoolbox.org/t/i-d-like-to-have-a-field-e-g-text-field-or-integer-but-don-t-want-to-show-it-on-the-form/14353
And on github
https://github.com/kobotoolbox/formpack/search?q=disabled%3DTRUE&type=issues