I have created a form personalization which fires when a field component_quanity is updated.
I have created a form personalization which fires when a field component_quanity is updated.when-new-record-instance is the trigger used not in enter query mode. The problem is that personalization fires as soon as I place my cursor on the field without even saving it. I want personalization to fire as after the record is saved. Also i need a query condition if multiple records are saved. My current condition to fire personalization is below:
( :B_INV_COMPS.component_quantity NOT IN (
SELECT component_quantity
disable_date
FROM
bom_inventory_components
WHERE
bill_sequence_id =:B_INV_COMPS.BILL_SEQUENCE_ID