Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

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