Change Verbiage based on View

[mykrobinson]

I’d like to be able to change the values showing in this view so that if In Hospital = N, the group shows “Recently Discharged” instead of “N”, and if it equals Y, the group heading shows “In Hospital” instead of Y.

Is this doable?

Thank you

[Suvrutt_Gurjar]

Please try below.

Please create a VC called say [In Hospital Description] of text type with an expression

SWITCH([In Hospital], TRUE, “In Hospital”, FALSE , “Recently Discharged”, “Other”)

The show_if of this VC can be CONTEXT(“ViewType”)=“Table”

Then please include the new VC [In Hospital Description] in the Group by setting of the view instead of [In Hospital] column.

[mykrobinson]

oh, thank you! Not sure if i’ve used the switch function, always glad to learn more about the tools available!

[SkrOYC]

Also, you may want to use a custom Y/N label.

[Suvrutt_Gurjar]

Hi @SkrOYC : Yes, that is an option. I had thought about suggesting to use the label, but it would have been probably cumbersome for data entry with big descriptions , so suggested the other approach.