Creating a Date and Time Stamp

(0) Share

Report

Posted on by Community Member

I wanted to create a date and time stamp whenever a box is checked for it to generate a time and date. It is inconvenient to have to enter it in manually and can be changed to easily. The created on box does it when the opportunity is created I want it when the record is changed or updated.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Community Member on at

Like (0)

Report

RE: Creating a Date and Time Stamp

I have worked with the scenario before. Create a sync workflow that triggers on the field change event. Create a second date/time field that stores the "field checked on" have the workflow write the workflow execution time or modified by time to that new field. You could additionally add the modified by field (string) to collect the user. If you are not reporting or searching on this field and want to just monitor who changed what, I would turn on auditing for that field.

Was this reply helpful? Yes No
Wayne Walton 13,728 on at

Like (0)

Report

RE: Creating a Date and Time Stamp

I think you could just make a process. Execute the workflow to update your custom field from the ModifiedOn field, then a next step to clear the checkbox on the field you're monitoring so you can check it again next time you need to update your datetime field.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Creating a Date and Time Stamp

So I would have to write a script for this or could I just create a process

Was this reply helpful? Yes No
Wayne Walton 13,728 on at

Like (0)

Report

RE: Creating a Date and Time Stamp

Then Allan's response should solve your problem, as it will only pull the ModifiedOn field to your new field whenever you want it to, instead of all the time.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Creating a Date and Time Stamp

I want to be able to generate a date whenever I mark a specific checkbox . Modified On is to broad I want it to be more specific to certain field so when I modify the field the date comes up.

Was this reply helpful? Yes No
Allan da Silva on at

Like (0)

Report

RE: Creating a Date and Time Stamp

Whenever a record is modified, the modifiedon atribute is updated. If you want to store the timestamp Only when that checkbox is marked but is not changed on future record updates you can create a script to copy the modified on and store it on a second field, you can also use Proccess for that, real time or not.

If i`m misunderstanding what you need, just please add more details on what you want to achieve.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Creating a Date and Time Stamp

I was looking to make it more dependent on a specific field not when I modify anything is there a way to do that ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Creating a Date and Time Stamp

I thought it would be like created on so I didn't try it but I will attempt it now and see if it was im looking for

Was this reply helpful? Yes No
Suggested answer

Mahadeo Matre 17,021 on at

Like (0)

Report

RE: Creating a Date and Time Stamp

You can write JavaScript on, on change event of checkbox, when check box is checked using javascript populate date time and store it in some attribute.

Also you can enable auditing, which will keep track of how many times checkbox is checked / unchanged.

Hope this will help..

Was this reply helpful? Yes No
Wayne Walton 13,728 on at

Like (0)

Report

RE: Creating a Date and Time Stamp

The ModifiedOn box already does this whenever the record changes. Does that not handle what you want?

Was this reply helpful? Yes No