I would like to create a Before Integration Script that will change the State Code if the Pay Code is a specific code.
For example, if Pay Code = 1102, set State Code to NM
Does someone have an example or has done this before?
Thanks.
*This post is locked for comments
Hi Tom,
I have done a similar translation but not as a "before script"....I just changed the Rule on the state code field in Entries mapping to be "Use Script" then the script would need to be something like this:
If SourceFields("PR-Detail.PayCode")=1102 then CurrentField="NM"
ElseIf SourceFields("PR-Detail.PayCode")=1103 then CurrentField="TX"
Else CurrentField="PR-Detail.StateCode"
End if
Note/key:
Which integration tool you are using?
Please drop me an email with details at tejas.patel@flovianit.com, so i can provide you best solution.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,188 Super User 2024 Season 2
Martin Dráb 230,030 Most Valuable Professional
nmaenpaa 101,156