We currently have a dropdown list displaying an option set that the user can customize (they can change what options are available)
The options are stored as a list of texts, and the value is a text
In a table, we display the row entry’s current value as the default, which the user can then change (and hit an update button to update the database)
That creates a problem however when the user changes the available options: now the text stored in the row value is not one of the options, so the dropdown displays nothing
What we’d like to do: we’d like the dropdown to display the default text value even if that is not one of the dropdown options. We could then color that red with a conditional, flagging to the user ‘hey this needs to be changed’
Pretty sure that your issue is that value loaded in default value is not set in choices source. Load choices source:plus item if needed to add the default value if not available from the choices source
Thanks @Jici ! Yes that’s exactly the issue, but that’s by design - we’d like to be able to display a default value that is not in the choices source (so that when the user changes the choices, the existing data isn’t lost, and instead we’ll color it red to prompt them to update it)
Your idea of adding it to the list is a good one, the only problem there from a UX perspective is that it can lead to users continuing to use the ‘old’ item, rather than updating it
one possible idea - I wonder if we could display a textbox behind the dropbox, that has the current value (if it’s not in the option set)
You could. You could also show a text message in red under the dropdown to say that this option is not available anymore and user need to select a new one. Set this field mandatory.
