asked 2012-05-06 01:56:59 +0200

Anonymous

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.

delete close flag offensive retag edit

1 Answer

Sort by » oldest newest most voted

answered 2012-05-07 22:08:36 +0200

mahfiaz

2031 ● 19 ● 20

This is what you are after: http://brendan-vittum.suite101.com/insert-a-date-stamp-shortcut-in-calc-a110315

link delete flag offensive edit

Comments

Thanks, will look into it. As i was searching, I learned a little about database triggers. Does LO Base support them?

Jim ( 2012-05-10 23:49:19 +0200 )edit

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.

mahfiaz ( 2012-05-11 16:39:29 +0200 )edit

http://user.services.openoffice.org/en/forum/viewtopic.php?t=25965

mahfiaz ( 2012-05-11 16:39:30 +0200 )edit

Resources

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Stats

Asked: 2012-05-06 01:56:59 +0200

Seen: 184 times

Last updated: May 07 '12

How to update a DATETIME field when a checkbox is clicked?