Assigning field value in a Syteline Form, based on another field value entered. (1)
In Syteline form, quite often, you would need to assign some field value, base on another field value entered.
Business case:
Let say in Customer Order, for certain payment terms, you would not allow partial shipment. So in the CO header form, when user select certain payment term, you want the system automatically uncheck the “Ship Partial” check box.
Syteline Technical Components:
Inline Script, Event Handler
Solution
In Syteline 7 & 8, there is quite a few differ ways to accomplish this. The first one we are going to discuss here is to use Inline Script.
1) In Customer Order Form, for form component: TermCodeEdit, add a data change event: TermChange. And the event handler will call an Inline Script
2) The Inline Script:
Option Explicit On
Option Strict On
Imports System
Imports Microsoft.VisualBasic
Imports Mongoose.IDO.Protocol
Imports Mongoose.Scripting
Namespace SyteLine.GlobalScripts
Public Class EvHandler_TermChange_0
Inherits GlobalScript
Sub Main()
if ThisForm.PrimaryIDOCollection.GetCurrentObjectProperty(“TermsCode”) = “128” then
ThisForm.PrimaryIDOCollection.SetCurrentObjectPropertyPlusModifyRefresh _
(“ShipPartial”, “0”)
end if
ReturnValue = “0”
End Sub
End Class
End Namespace
This script will assign the ShipPartial to 0, when user select TermsCode = 128.
Recent Comments