Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to Make Vendor Contact(s) inactive after Vendor Risk Assessment is Closed?

SandyL83
Tera Guru

Hello,

I posted this question the other day but haven't been able to resolve the issue. 

 

I have the requirement to set the user record(s) on the Vendor Contact table (vm_vdr_contact) to inactive after the Vendor Risk Assessment is Closed.

Has anyone done this? Any ideas on how to achieve this?

 

To add - 

I know this is done by a business rule. I started doing this by putting an After business rule on the sn_vdr_risk_asmt_assessment table. So, after the assessment state changes to Complete. 

 

From there, I need to glide to the core_company table and get the related list vm_vdr_contact entries. I need to make the users on the vm_vdr_contact inactive at this point. 

 

Any ideas on how I can do this? 

Thanks

0 REPLIES 0