How to update and create a record in the table

NAIDILE S
Tera Contributor

Hi,

I have a case where there is attestation table and control table in IRM.
when ever a user does "not attest "(meaning take survey) and exceed the due date , on the control table the status to be set as non-compliant and issue to be created at the same time (issue is other table ).

How can i write the script for it?
kindly help me with this.

thanks , 
naidile

2 REPLIES 2

Mark Manders
Mega Patron

Why do this via script? If you use the Flow designer, you can just configure it. You can trigger it on a daily schedule and the first check is for the attestation being overdue.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

Hi @Mark Manders 
got it , thanks 
Here i don't have direct link b/w control and attestation , i mean in the attestation form no reference to the control.
In this case how can i consider?