checkbox to do a date time stamp

Question

checkbox to do a date time stamp

rphbrew (TechnicalUser)

(OP)

29 May 03 10:26

I have a database that I inherited that has a check box to be used when a task is completed. THis is also tied in to an agent that sends emails out to remind the responsible party to complete the task if the box is not checked.

I would like to add the functionality to the checkbox to have it write the name of the person who clicked the checkbox and the date/time stamp of when it was clicked.

any suggestions on how I would do this?

lespaul (Programmer) · Answer 1 · 2003-05-29 14:25:50

Create two hidden fields on your document (UpdatedBy, UpdateTime?). In the Exiting function of the checkbox write a script that if the box is checked, update the two hidden fields with the username and current date & time.
If the document is complete when the box is checked and it won't be changed again, that should take care of it. If it's a document that will be opened again, you'll need to do some programming to make sure that you only do this function if it wasn't already checked.

HTH!

Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!

ABOzIT (IS/IT--Management) · Answer 2 · 2003-06-02 21:58:58

This is how I've done it in one of my applications.

Create a checkbox field and call, it for example, "FormComp". Put "Yes" into the field choices and check the "Refresh fields on keyword change" box.

Create a computer text field called "CompUser" and put the following in as the default value:

@If(FormComp="";"";FormComp="Yes"& CompUser="";"Completed by "+@Name([CN];@UserName)+" on "+@Text(@Now);CompUser!="";CompUser;"")

This will place the username and the time in the CompUser field when the FormComp checkbox is checked. It will also remove the user and time info if the checkbox is unchecked.

Hope this helps

Come Join Us!

Posting Guidelines

checkbox to do a date time stamp