Conditional Default value/type for a form item
662805Aug 1 2009 — edited Aug 2 2009Hi
I have a interactive report with a form on table 'A' which has 'who' columns like "CREATED_BY" , "LAST_UPDATED_BY". Now I was auto-populating these columns in the form with the &APP_USER. function. The scenario is when user 'P' clicks "CREATE" button on the report, these columns in the report get populated by P's info.After commiting this record, user 'Q' edit this same record with "Edit" link of this record. Both the columns get populated by Q's info, ideally only LAST_UPDATED_BY should get populaed by Q's info, and not the CREATED_BY column, as it is 'P' who created that record.
For that, I guess in the default value type for these items, I have to use "PL/SQL Function body" instead of "Static Text with Session State Substitutions". Problem is how to code the filter : whether the user pressed "create" button or the "edit" button. Please help
Thanks
Bhavesh