Help with on the fly string.

Discussion in 'Tally Developer' started by Sohail Khan, Dec 21, 2020.

    
  1. Sohail Khan

    Sohail Khan Member


    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
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Please Study.........[Field: State Name Field] .... it may help you.
     


  3. Sohail Khan

    Sohail Khan Member


    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:mad:@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:mad:@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
     


  4. Sohail Khan

    Sohail Khan Member


    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:mad:@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:mad:@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
     


  5. abhinand vk

    abhinand vk Active Member


    upload_2020-12-22_15-20-6.png

    you can ask tdl douts to tally solutions post in the create new ticket
     


  6. Karthick MS

    Karthick MS New Member



    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"
     


Share This Page