Technical names/keys for select field option values #2384
Description
Is your feature request related to a problem? Please describe.
When reading table data from the Nextcloud tables API via N8N, I get numeric values for option fields back ("2").
The meaning of these values can change when new options are added to a field.
Describe the solution you'd like
When adding options to a select field, there should be a way to provide a technical key.
Example:
- Create new column "Status" of type "selection" (single)
- Add new option "Neu" with key "new"
- Add new option "Gesendet an GeschĂ€ftsfĂŒhrung" with key "gf-sent"
- Add new option "Freigabe durch GeschĂ€ftsfĂŒhrung" with key "cleared"
To use only a single field, one could split key + title with "|": new|Neu.
This technical keys shall then be returned when fetching row/column data, instead of the numeric option IDs.
Describe alternatives you've considered
No response
Screenshot
When adding a new option value between 3 and 4 (by adding a new option, moving the 4 title to it, and changing the previous 4 value) , the internal value IDs change.
Additional context
Related: #1840 (for column names)