Append date value into string field every time field is changed to "yes"

(0) Share

Report

Posted on by Community Member

Hi experts,

I have a boolean (yes/no) field named "new_escalated" in the case record.

Whenever the user changes the field to yes, I would like to append the modified on date & time value into a custom text field called "new_escalationlog" .

How can I append a value onto a text field every time the escalated field is changed to yes? Basically I want to keep an audit log of the field on the record itself.

Thanks,

Jon

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi Jon ,

Are you talking about Dynamics CRM Modified On field value or at the time of on change using javascript you want to get the client machine date time ?

Seems it will be good if you register a method in onsave and based on field changes (You can check isDirty property)get the current date using javascript and append to your text field .

To retrieve dynamics CRM modified on field value you need to call WebAPI , however it will give you old value in client side not current date time.

Was this reply helpful? Yes No
Suggested answer

Swetha Poojary Sala... 326 on at

Like (1)

Report

I would recommend to write plugin on Post operation of on update that case new_escalated field. and their append the modifiedon date in "new_escalationlog" multiline text field. Also reset the escalated field to No.

Also remember to check depth in code. So plugin should not run in infinite time.

Thanks,

Swetha.

If found useful, please mark the answer as verified

Was this reply helpful? Yes No
gdas 50,091 Moderator on at

Like (0)

Report

I agreed with Swetha , you can get everything in the plugin post Image , you just need to set the value to your text box .

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Goutam,

I'd prefer using Javascript instead of plugin because of performance issues.

Also I dont mind using either CRM Modified On value or client machine time.

I think taking client machine time would be better because modified on would return inaccurate values.

Thanks,

Jon

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Swetha,

Thanks for your reply.

I'll look into this approach as well.

Thanks,

Jon

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
I have created this code to set the value of the computer time. How can I change my code to append to time to the field, so the previous values are not lost?

function saveEscalate() { var check = Xrm.Page.getAttribute("new_escalated").getValue(); alert(check); if(check == true) { alert(check); var today = new Date(); var date = today.getFullYear()+'-'+(today.getMonth()+1)+'-'+today.getDate(); var time = today.getHours() + ":" + today.getMinutes() + ":" + today.getSeconds(); alert(date+" "+time); Xrm.Page.getAttribute("new_escalationlog").setValue(date+" "+time); } else { } }

Thanks,

Jon

Was this reply helpful? Yes No
Suggested answer

Swetha Poojary Sala... 326 on at

Like (0)

Report

HI Jon,

you will need to get the value from "new_escalationlog" field and the append and set the value

example:

var oldvalue=Xrm.Page.getAttribute("new_escalationlog").getValue();

var newvalue=oldvalue + " " +date+" "+time;

Xrm.Page.getAttribute("new_escalationlog").setValue(newvalue);

Was this reply helpful? Yes No
Verified answer

gdas 50,091 Moderator on at

Like (0)

Report
Hi Jon ,

You need to get the value and append with new value with old value like below - Hope this helps.

function saveEscalate() { var check = Xrm.Page.getAttribute("new_escalated").getValue(); alert(check); if (check == true) { alert(check); var today = new Date(); var date = today.getFullYear() + '-' + (today.getMonth() + 1) + '-' + today.getDate(); var time = today.getHours() + ":" + today.getMinutes() + ":" + today.getSeconds(); alert(date + " " + time); var newValue = date + " " + time; var oldValue = Xrm.Page.getAttribute("new_escalationlog").getValue(); var newValue = oldValue + "\n + " + newValue; // Added new line in the text , you can add any other text as well like oldvalue and new value Xrm.Page.getAttribute("new_escalationlog").setValue(newValue); } else { } }

Was this reply helpful? Yes No