Spotfire Ideas Portal
It is quite common to have to display a dropdown or multi-select listbox containing a choice of items by name, but when a user makes a selection, pass the actual IDs of the items for downstream processing, not their names.
This can be achieved using IronPython scripting, but it would be much easier to author and also to maintain if the "unique values in column" functionality allowed the selection of a second column as the ID field. Then whenever the selection changed, both the name and ID Document Properties are updated together.
I looked into creating a Custom Function to do this, but there is no option in the Spotfire SDK to create a custom pre-processor function similar to $map, $esc etc.