Report to check duplicated user accounts (records)

Andr_1
Tera Contributor

Hi

I have created a report to check the duplicated user accounts. To achieve this, I've created a new script include to return all the duplicated records by my field "Global ID".

Andr_1_0-1743781195461.png

 

 

 

To check if the script is correct, I ran it inside a background script, and it returned my duplicated "Global ID"'s. So I am  assuming that it's working well.

Andr_1_1-1743780511546.png

 

Now, when I try to execute the script include inside my report (on the global id field), it does not show any information

 

Andr_1_1-1743781129708.png

 


I was checking on the community and everyone is doing like that... but for some reason is not working for me.

 

Can someone help me with that, please?

 

Thanks

 

André Ramos

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

SwathiPedireddy
Kilo Sage

Hi @Andr_1 

 

Enable 'Sandbox enabled' checkbox on script include

 

Thanks,

Swathi

View solution in original post

3 REPLIES 3

Shivalika
Mega Sage

Hello @Andr_1 

 

What is Global ID - is it a different type of function field or something ? - where we can call script include and corresponding function. 

 

Because I don't think we have this facility in normal fields in any table. Can you give some background info?

 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

 

Regards,

 

Shivalika 

 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

 

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

SwathiPedireddy
Kilo Sage

Hi @Andr_1 

 

Enable 'Sandbox enabled' checkbox on script include

 

Thanks,

Swathi

Hi @SwathiPedireddy 

Thank you so much. It is working 

 

Regards,

André Ramos