How to SET an item value as I save changes
Hi guys,
hope that you are doing well these days.
I have an item P2_last_updated. the value of this item should be set to the current_timestamp AS an end user clicks the "Apply Changes" button in the form.
I created a Dynamic Action as following:
Event: Click
Selection Type: Button
Button: Save ( Apply Changes )
Action: Set Value
Set Type: SQL Statment
SQL Statement: Select to_char ( current_timestamp, 'DD-MM-YYYY HH24:MI') from dual ---- ( I do not need the seconds )
Affected Elements: item(s)
Item(s): P2_LAST_UPDATED
The problem is when I click the button "Apply Changes", the page does not get submitted. Only the value of the P2_last_updated item is set.
How can I perform that task ????
Having said that,
I also have to make sure that the end user really makes some changes before he/she clicks "Save Changes" button so I do not get a misleading last updated date.
I hope my question is clear, and I highly appreciate your collaboration .
Regards,
Fateh