You need to sign in to do that
Don't have an account?
Agaden
? About adding a date stamp to a text field
Im not sure if this is possible or not. Essentially what we have is a textbox field on the opportunity form where folks can put in some free form notes about the opp. I'm looking to see if there is a way to have the current date populate into the text field when the user clicks into the field to add some notes.
I'm thinking it may be able to be done with an S-control and Im just looking for a little guidance/advice on if something like this is possible.
Thanks,
~ Nazeer
As a separate object, the Note will have all the standard Salesforce meta fields ( Created Date, Last Modified Date, etc. ) applied automatically so you won't have to worry about additional configuration.
Message Edited by jpizzala on 04-04-2008 04:26 PM
- Create a new workflow rule on the Opportunity object
- Have the workflow evaluate every time a record is created or edited
- Run this rule if the following formula evaluates to true:
- AND( NOT( ISNULL( Notes__c ) ) , Notes__c <> '' , ISCHANGED( Notes__c ) )
- Basically, this will update the field if the field is not empty and its value is different than the previous value (assume the field name is Notes__c)
- Add a field update workflow action that will update the Notes__c field
- Use the following formula to set the new value:
- TEXT( TODAY() ) & ': ' & Notes__c
- Save and activate the workflow
Now for the team training. Since this will add a date stamp to the BEGINNING of the Notes__c field, you will have to have your team always add new notes ABOVE their previous ones (all in the Notes__c field, of course).For instance, say the current value of the notes field is:
- 2008-04-06: Here are some notes that I typed on April 6, 2008
So when adding a new note, you will simply put the new stuff before the existing stuff like so:- Here is a short little note blah blah blah
And when you save the record, the workflow rule will evaluate and add the date before the new note automatically so the field will end up looking like:2008-04-06: Here are some notes that I typed on April 6, 2008
-
2008-04-07: Here is a short little note blah blah blah
Hope this helps!2008-04-06: Here are some notes that I typed on April 6, 2008