Can Realted List data can be added to Activities field ?

[thirumala2]

Hi ,

Can we show / add related list data(document revision , user permission ,grp permission  etc ) or other tables data  into Activities /activities logs?

If Yes ,How ?

[Aman Kumar S]

Hey @thirumala,

Did you mark the incorrect response as correct, it will be confusing for others looking out for similar queries.

Request you to select correct response as correct.

Thanks

[Jaspal Singh · Accepted solution]

Hi Thirumala,

As suggested by Aman in comments before you need an After insert/update Business Rule on the Related list table that then updates the Activity of actual form where you see records as related list.

[thirumala2]

Hi ,

Thanks for replying .

I have tried the below script for  above problem :

I have used after inert/update br on dms_document_user_permission _table with condition as : User changes ,  but its printing duplicates users in activity logs .

var rev1 = new GlideRecord('dms_document');
rev1.addQuery('sys_id', current.document);
rev1.query();
if (rev1.next()) {
    var rev = new GlideRecord('dms_document_user_permission');
    rev.addQuery('document', rev1.sys_id);
    rev.query();

   while(rev.next()) {
        rev1.u_work_notes = 'User :'  + current.user.getDisplayValue()  +'Type :' + current.type;
        rev1.update();
    }

Can you please help me understand where it is going wrong .