AnsweredAssumed Answered

Script seems like it is not always working

Question asked by user2148443 on Jan 15, 2019
Latest reply on Jan 17, 2019 by user2148443

I have the Below Script i manually trigger to update a relationship. however when i monitor it and review the data, it does not always refresh the linked fields or even some of the fields in the script. Ideas what can cause this. File is located on a server, hence the .5s delay.

 

 

#

# Prepare the record

Freeze Window

Allow User Abort [ Off ]

Set Error Capture [ On ]

Set Variable [ $BillingID ; Value: Site Contacts::_PK_Contacts_ID ]

#

If [ not IsEmpty ( TO_002____Customers::_FK_BillingContact ) ]

Set Field [ Site Contacts::Billing Contact ; "Yes" ]

Set Field [ TO_002____Customers::_FK_BillingContact ; "" ]

Set Field [ Customer__Billing_Contacts__Link::_FK_Billing Contact_ID ; "" ]

Pause/Resume Script [ Duration (seconds): .5 ]

Set Field [ TO_002____Customers::_FK_BillingContact ; $BillingID ]

Set Field [ Customer__Billing_Contacts__Link::_FK_Billing Contact_ID ; $BillingID ]

Else If [ IsEmpty ( TO_002____Customers::_FK_BillingContact ) ]

Set Field [ TO_002____Customers::_FK_BillingContact ; $BillingID ]

Set Field [ Customer__Billing_Contacts__Link::_FK_Billing Contact_ID ; $BillingID ]

End If

Beep

Commit Records/Requests [ With dialog: On ]

#

Outcomes