In my oracle forms, I have created new trigger as "WHEN-NEW-RECORD-INSTANCE". So whenever, I run the form, this trigger also executes. But I wanted to call this only when user clicks on "INSERT NEW RECORD" and not on the first run of the form because I am assigning some values which will be used only when insert new record is clicked.
WHEN-NEW-RECORD-INSTANCE
:block_name.column := 'N';
set_item_property('column_name',enabled,property_false);
--Should be disabled only when user clicks on new insert record.
Step by Step Approach should be -
1. Run the form - The form should run as "initialise form" i.e fresh but WHEN-NEW-RECORD-INSTANCE shouldn't be called.
2. I save the transaction.
3. I click on "Insert New Record" --> WHEN-NEW-RECORD-INSTANCE should get fire and some fields should get auto populate as mentioned in the trigger.
How can I do this? Because as per the current scenerio, the fields are auto populating and it's not required at the first runtime of the form.