Skip to main content

Hi, 

I have a table; with a start_date and a end_date column. 
Both are a DATE domain. 

The end_date column has a domain with a constraint on it; start_date < end_date. 

However, I don't see anything happening in the gui. What should it do? 

I assume you know what I want here.. and I would like to display a custom message, explaining what's going on. 

Any advice on this? 

Thanks! 

Alex

Domain input constraints can only perform checks on the input value provided by the user for a field or parameter that uses this domain.

For more dynamic constraints based on interdependency between fields, you’ll have to use other logic types such as Default logic, Handlers, Triggers or Task logic.

@Blommetje the functionality I would recommend to use for this particular scenario is not mentioned by @Anne Buit: Check constraints! See this great blog, which uses the same scenario as example: 

 

@Blommetje the functionality I would recommend to use for this particular scenario is not mentioned by @Anne Buit: Check constraints! See this great blog, which uses the same scenario as example: 

 

Ah some light reading for an afternoon. Thanks! I’ll look into it.

@Anne Buit  I have a def_proc, works ok. Was fiddling with stuff. 

Terms & ConditionsCookie settings