How to set conditionnal default value to a custom field

You could use a Read-only Custom Field with a select statement. I had used the below query for the select statement and you can change the conditions according to your requirements.

select case when :ENG_CHG_LEVEL='1' then 'A Part' else 'B Bart' end from part_revision

 

And the result was like below.

 

Hope this is what you were looking for.

 select case :PART_REV
when 'R01' then 'First Revision'
when 'R02' then 'Second one'
when 'R03' then 'Yet another revision'
when 'R04' then 'Fourth Revision'
else 'High Revision number'
end case
from eng_part_revision where part_no = :PART_NO and part_rev = :PART_REV

Hi Steve,

Thanks for sharing your thoughts. 
I just wanted to provide an example of how to handle this type of scenario. As you mentioned, according to the requirements, you may need to add the relevant parameters to the select statement. 

Thanks,
Avindu

Eric,

I’ve no idea where you got that screen shot from, but can’t the Context Substitution Variable of help?

Steve

Eric,

On what should the default be based? The entry of new data is not available, I'm not technical enough to understand what is going on in the GUI layer, but what you enter is always to late to be picked up by a trigger to form a default.

Hope you understand what I'm getting at.

Steve