Skip to main content
taavonb0596
taavonb0596
February 2, 2023
Question

recordtype field value

  • February 2, 2023
  • 7 replies
  • 0 views

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?

    7 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    February 2, 2023

    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.

    taavonb0596
    taavonb0596Author
    February 2, 2023

    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

    abhayd3663
    abhayd3663
    February 21, 2023

    displayvalue(1, {1,2,3}, {"Draft","In Progress", "Finalized"},null)

    Terms & ConditionsAccessibility statement