This content has been marked as final. Show 2 replies
Instructions to set a default value of a hidden column for newly added rows, since I was having some trouble doing it.
In this example, we'll set "Column_Foo" to P0_DEFAULT_VALUE
1. Double click on Column_Foo to see its attributes
2. Display As: "Hidden"
Don't pick any of the "Display As Text" or else that column is not editable
3. Default Type: "Item (application or page item name)"
4. Default: "P0_DEFAULT_VALUE"
!!! Note this is NOT ":P0_DEFAULT_VALUE", NOR "&P0_DEFAULT_VALUE.", but just simply the name
5. Reference Table Owner, Reference Table Name, Reference Column Name should be set just like the other text field columns.