Change the result of a number to a string

Short question:
I use a select box and let a query fill the content. The results are numbers between 1 and 3, but I want "perfect" instead of "1", "good" instead of "2" and "poor" instead of "3" in the selection.
How do I get this to work?
I would like to read this myself, but I don't know where to find it.

Welcome to the forums.

Several options here depending on your needs and data sources.
You could use a transformer to add the detail to your data but that might not be suitable in all cases.
You could modify your select query to apply the labels there.
You could have a "lookup" that uses a static list of values->names for display purposes.

Here's a simple app that shows 2 options: first box shows what the data from your query would need to look like and how to display the labels. Second one doesn't modify the data but looks up the display name from a static object in a temporary state.

Hope this helps
forum (3).json (19.8 KB)


Thank you very much!
Now I can help myself! Perfect answer btw! :grinning: :+1: