Similar to how you can assign a Display Name for a column that shows instead of the column name, I’d like to be able to specify a Display Value.
Example:
Say I have a table of contracts, each with a contract ID, like “122”,“133”,“144”.
But I want these contract ID values to be displayed as “C-122” , “C-133” , “C-144”
So for the Display Value field I would enter: “C-” & [_THIS]
Obviously I could create another column to just concatenate a “C-” onto the id, but that seems unnecessary. I also think this kind of value “formatting” is similar to how assigning a column type as Price puts a dollar sign in front, or how we can turn on or off the thousands separator on a Number column, or set the number of decimal places on a Decimal column.