For my Tasks, I have a CompletedDate field and a Completed? field represented by a checkbox on the form. I want to set the Completeddate to the current date when the checkbox is clicked.
This is what you are after: http://brendan-vittum.suite101.com/insert-a-date-stamp-shortcut-in-calc-a110315
Thanks, will look into it. As i was searching, I learned a little about database triggers. Does LO Base support them?
If you use HSQLDB as backend: http://user.services.openoffice.org/en/forum/viewtopic.php?t=25965
If you use MySQL as backend: http://dev.mysql.com/doc/refman/5.0/en/triggers.html
Not sure about the integrated database.