Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

How to automitacally append current date to Solution on Save&Close?

SOLVED
Go to solution
Highlighted
Jacek Pliszka_2
Regular Collector

How to automitacally append current date to Solution on Save&Close?

Hi!

Subject says it all. I use SD 4.5 SP14.

Is it possible to add current date to the end
of solution field when service call is saved ?

I can enter (Current person) but how to enter
current date/time ?

Thanks for any help
8 REPLIES
Moxie
Regular Collector

Re: How to automitacally append current date to Solution on Save&Close?

We do something similar with a log field.

In short, the following is how we do it.

Use a custom date field associated with your form and set this field to the current date based on the criteria you have.

For instance, if you only want this done when the call is completed, you may drive the rule off of status and possibly some other criteria (ie: when Solution is not empty)

You use a Data Update function to then set Solution to "concatenate" a function available when setting a value on a field, you want to "concatenate" the custom date field to the Solution field.

Remember the custom date field does not have to appear on your form and I also set it to "view" level access in the event it was ever put on the form by mistake. I used it as a timestamp and don't want it to be modified ever.

My system is currently down for maintenance but if you need more information, please let me know and I can get a copy of the rule to post here.

Hope this helps!
Do it right the first time
Moxie
Regular Collector

Re: How to automitacally append current date to Solution on Save&Close?

I found a doc I wrote on how I did this. The doc shows concatenation of a person (Information Modified by) and date (Information Log Timestamp) to a field Information and then conconcatenate all of this to whatever is already existing in the Information Log field.
Do it right the first time
Moxie
Regular Collector

Re: How to automitacally append current date to Solution on Save&Close?

BTW: the document is written from the bottom up so that the first screen in the doc is actually the last screen in the rule build process.
Do it right the first time
NHS Pete
Super Collector
Solution

Re: How to automitacally append current date to Solution on Save&Close?

Jacek

You can add the current date to the end of the Solution field using Concatenate.

You can Concatenate a Fixed Value which represents the current date and time as shown in the simple example below:

When a value has changed
where Solution (*) is anything
Concatenate Date time (Update Data) Solution set to (Concatenate
With $DD$/$MM$/$YYYY$ $HH$:$MI$)

Hope this helps.
Jacek Pliszka_2
Regular Collector

Re: How to automitacally append current date to Solution on Save&Close?

$YYYY$ etc. is exactly what I was looking for!
Thanks!

One more question - is it possible to add
a new line ? I tried \n but it did not work ...
Mark O'Loughlin
Honored Contributor

Re: How to automitacally append current date to Solution on Save&Close?

Hi,

You can add a new line. You need to add an extra concatenation and set that to a fixed value. Double click the "fixed value" field and it opens a box. Press enter to add a carraige return (which is the fixed value) and then ok and finish off the rule.

This should add a carraige return.
Jacek Pliszka_2
Regular Collector

Re: How to automitacally append current date to Solution on Save&Close?

OK I found out that new line is:

%line.separator%
Jacek Pliszka_2
Regular Collector

Re: How to automitacally append current date to Solution on Save&Close?

$YYYY$-$MM$-$DD$ and %line.separator% are the solution.

//Add this to "OnDomLoad" event