Good morning I have a recordtype field that has values 1,2 and 3. I am trying to have the field value to be displayed as 1 = Draft, 2 = In Progress and 3 = Finalized. can any assist me with this?
Discussion posts and replies are publicly visible
This seems to be some king of a status. I typically store literals to the database which would make my values being DRAFT, IN_PROGRESS and FINALIZED. Then I use an expression rule and the proper() function to display these.
In your case, a simple decision table might be the most low-code'ish approach. But there are more options, so let's see what the others think.
In the database the values are 1, 2 and 3. I want Draft to populate on the screen instead of 1 and In Progress instead of 2 and the same for Finalized