Home » Fusion Middleware & Colab Suite » WebCenter Suite & Portal » Changing Form field values on Update?
icon5.gif  Changing Form field values on Update? [message #136244] Tue, 06 September 2005 21:42 Go to next message
RobB
Messages: 7
Registered: September 2004
Junior Member
I have a Portal Form that enters a record into a table. How do I create an audit trail by recording the user name of the user who edits the record using the form?

When the record is created, the user name field is automatically populated with the user name, but when the record is updated, how to I change the user name field automatically if it already has a value?

TIA
Re: Changing Form field values on Update? [message #137390 is a reply to message #136244] Thu, 15 September 2005 01:26 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you considered using a database trigger on your table?

David
Re: Changing Form field values on Update? [message #137745 is a reply to message #137390] Fri, 16 September 2005 08:14 Go to previous messageGo to next message
RobB
Messages: 7
Registered: September 2004
Junior Member
Yes. I was hoping for a Portal Form solution, but am considering either a trigger or javascript to set the fields correctly.
Re: Changing Form field values on Update? [message #139788 is a reply to message #137745] Thu, 29 September 2005 10:14 Go to previous message
RobB
Messages: 7
Registered: September 2004
Junior Member
Added a Before Insert trigger to modify the fields.
Previous Topic: Deregister Portlet
Next Topic: How to create Oracle Portal?
Goto Forum:
  


Current Time: Fri Oct 30 06:35:31 CDT 2020