Dear Experts, I am trying to get on the fly string in this field for New Vehicle Number, so that if the vehicle number is not from the Collection: CMP Vehicles the cursor hovers to New Vehicle. Please Help me in the code. ;;;;;;;;;To Get Motor Vehicle Number;;;;;;;;; [#Field: EI Trader MotorVehicleNo] Table : CMP Vehicles, NewVehicle, Not Applicable Show Table : Always Dynamic: "" Trigger : New Vehicle Number : $$IsSysNameEqual:NewVehicle:$$EditData Act on Table Element: $$IsOntheFlyItemSelected : Set : SVNewVehicleNumber : $$GetOnTheFlyString Act on Table Element: NOT $$IsOntheFlyItemSelected : Set : SVNewVehicleNumber : "" On : Accept : Yes : Field Accept [Variable: SVNewVehicleNumber] Type : String [Report: New Vehicle Number] Title : $$LocaleString:"New Transport Name" Auto : Yes [Form: New Vehicle Number] No Confirm : Yes Full Width : No Space Top : 1 Space Bottom: 1 Space Left : 1 Space Right : 1 Parts : New Vehicle Number Output : New Vehicle Number [Part: New Vehicle Number] Lines : Form SubTitle, New Vehicle Number Local : Field : Form SubTitle : Info : $$LocaleString:"Vehicle Number" Local : Field : Form SubTitle : Delete : Border [Line: New Vehicle Number] Fields : New Vehicle Number [Field: New Vehicle Number] Use : Short Name Field Width : 35 Max : 100 Set as : ##SVNewVehicleNumber [Collection: CMP Vehicles] Title : "Company Vehicles" Type : Voucher Fetch : BasicShipVesselNo Format : $BasicShipVesselNo, 20 [Collection: NewVehicle] Title : $$LocaleString:"New Vehicle" Object : NewVehicle Format : $$Name, 25 ClientOnly : Yes [Object: NewVehicle] Use : On The Fly Object Name : $$SysName:NewVehicle
Sir , its working now. [#Field: EI Trader MotorVehicleNo] Trigger : NewVehicleNumber : $$IsSysNameEqual:NewState:$$EditData Act on Table Element: $$IsOntheFlyItemSelected : Set : NewState : $$GetOnTheFlyString On: Accept : Yes : Set : NewState : "" On: Accept : Yes : Field Accept Default Table Item : NOT $$IsActionObject Dynamic : "" Show Table : Always Table : CMP Vehicles, NewVehicleTable, Not Applicable Set as : if NOT $$IsEmpty@EIBasicShipVesselNo then @@EIBasicShipVesselNo Else $$Value Set Always : Yes ;[Variable: NewVehicle] ; ; Type : String [Report: NewVehicleNumber] Use : NewCountryName Title : New Vehicle Number Form : NewCountryName Local : Part : New CountryName : Local : Field : New CountryName : Set as : ##NewState Local : Part : New CountryName : Local : Field : Form SubTitle : Set as : "New Vehicle Number" [Collection: NewVehicleTable] Use : Master Name Method Format Object : New Vehicle Client Only : Yes [Object: New Vehicle] Use : On the Fly Object Name : @@NewVehicle [System: Formula] NewVehicle : $$EvalParamExp@NewVehicleName:##SelectedVehicle [System: Formula] NewVehicleName:$$SysName:NewState [Variable: SelectedVehicle] Type : String Default : "" [Collection: CMP Vehicles] Title : "Company Vehicles" Type : Voucher Fetch : BasicShipVesselNo Format : $BasicShipVesselNo, 20
but when im trying to change NewState Variable with NewVehicle Variable its not working. [#Field: EI Trader MotorVehicleNo] Trigger : NewVehicleNumber : $$IsSysNameEqual:NewVehicle:$$EditData Act on Table Element: $$IsOntheFlyItemSelected : Set : NewVehicle : $$GetOnTheFlyString On: Accept : Yes : Set : NewVehicle : "" On: Accept : Yes : Field Accept Default Table Item : NOT $$IsActionObject Dynamic : "" Show Table : Always Table : CMP Vehicles, NewVehicleTable, Not Applicable Set as : if NOT $$IsEmpty@EIBasicShipVesselNo then @@EIBasicShipVesselNo Else $$Value Set Always : Yes [Variable: NewVehicle] Type : String [Report: NewVehicleNumber] Use : NewCountryName Title : New Vehicle Number Form : NewCountryName Local : Part : New CountryName : Local : Field : New CountryName : Set as : ##NewVehicle Local : Part : New CountryName : Local : Field : Form SubTitle : Set as : "New Vehicle Number" [Collection: NewVehicleTable] Use : Master Name Method Format Object : New Vehicle Client Only : Yes [Object: New Vehicle] Use : On the Fly Object Name : @@NewVehicle [System: Formula] NewVehicle : $$EvalParamExp@NewVehicleName:##SelectedVehicle [System: Formula] NewVehicleName:$$SysName:NewVehicle [Variable: SelectedVehicle] Type : String Default : "" [Collection: CMP Vehicles] Title : "Company Vehicles" Type : Voucher Fetch : BasicShipVesselNo Format : $BasicShipVesselNo, 20
You don't have NewVehicle in System Name. So you have to use as follows Trigger : NewVehicleNumber :$$EditData = "New Vehicle" [Object: New Vehicle] Use : On the Fly Object Name : "New Vehicle"