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 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.
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.
So I would have to write a script for this or could I just create a process
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.
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.
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.
I was looking to make it more dependent on a specific field not when I modify anything is there a way to do that ?
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
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..
The ModifiedOn box already does this whenever the record changes. Does that not handle what you want?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (