Solved

Default Value for Custom Field

  • 9 April 2020
  • 3 replies
  • 782 views

Userlevel 3
Badge +9

How can i add a default value for the Custom Field. I have created a custom field (type DATE) and i can see there is a default value column in this custom field details, how do i add a default value to it. Help would be appreciated.

icon

Best answer by Rusiru Dharmadasa 9 April 2020, 14:13

View original

3 replies

Userlevel 7
Badge +19

In APP9 onwards it is not allowed to set default value for date type fields.

 

Just to update, this is disabled purposely due to some issues that the framework can face if users set default values for these date types.

Userlevel 7
Badge +18

You can work around this by writing a “BEFORE INSERT” Oracle trigger on the CFT table.

Userlevel 7
Badge +18

this is disabled purposely due to some issues that the framework can face if users set default values for these date types.

Is this due to user regional settings?

Reply