DROP DOWN LIST

Discussion in 'Free Source Codes' started by Ruchit, Apr 30, 2019.

    
  1. Chetan S

    Chetan S New Member


    Thanks a lot Sir. Will Work on it.
     


  2. rony

    rony Member


    Just now I rectified my mistake of Amit sir suggestion on 8/2020 with silly mistake.Some times "batti gul ho ja ti hai to jalti hinahi"
    Set as : If $$IsEmpty:$$Value then "Regular" else $$Value. i did not put space between then and "Regular" .
    Regards
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    It happens and happens for good.

    Mistakes/errors are the best teacher. :):)
     


  4. NSA

    NSA Member


    You are absolutely right Sir.

    Sir,

    I have a doubt. Can I have a conditial tables for a field based on the value of another Field?

    For example

    [Field: Key Factor fld]
    Use : name field
    Table: <TableNameA>
    Show table always: Yes
    Storage : KFStorage

    [Field : Conditional Fld]
    Use : Name Field
    Table : If $KFStorage= "X" Then <TableNameB> Else <TableNameC>
    Show Table always: Yes
    Storage: ConditioonalFieldStorage
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Study many of the Fields in Developer and you can learn from it.

    Study --- VCH StockItem in Developer.........

    Syntax is-----
    Table : TableA : NOT ##ContraCondition AND @@IsSales
    Table : TableB : ##ContraCondition AND NOT @@IsSales
     


  6. NSA

    NSA Member


    Thank You Sir,
    It Worked for me. And it made a big relief for the works. I am new to the TDL Development. This group is really encouraging and helping me a lot. Thanks for your kind support and suggestions
     


  7. NSA

    NSA Member


    Thank you Sir..


    Really really, it was too helpful. And thanking you for the quickly reply as well
     

    Attached Files:



  8. gauravss

    gauravss Member


    can i know the source code for drop down list for dispatch details as i need to enter transporter name and vehicle number if drop down list according with group ledger master is selected will help in typo error
     



  9. @Amit Kamdar Can you elaborate and help me out on this coz I tried what u suggested and achieved to the point of adding but something is wrong as it shows on a single letter display once i press the key at the field. Then if i input the data it says accept i press yes but the list name doesnt get added

    I think I am missing a syntax or a action but due to my limited knowledge not able to complete this. Pls Help

    This is part of my code

    [Field : Salesman]
    Use : Name Field
    Width : 20
    Storage : SalesmanName
    Table : Typ
    Show Table : Always
    Set Always : Yes
    Key : NewSalesman

    [Table : typ]
    Title : $$LocaleString:"SALESMAN"
    List Name : "SAIF"
    List Name : "SHREYAS"
    List Name : "PRADEEP"
    List Name : "SRINATH"
    List Name : "YOGESH M S"
    List Name : "YOGESH R M"
    List Name : "DBSALES"
    Format : $Name,15

    [System:UDF]
    SalesmanName : String : 2

    [key : NewSalesman]
    Key : Alt + 3
    Action : Alter : typ3

    [Report : typ3]
    Form : Typ3

    [Form : Typ3]
    Part : Typ3

    [part : typ3]
    Line : Typ3

    [line: typ3]
    Field : typ3

    [Field : typ3]
    Use : Typ



     


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    So far you are on right track....... continue with the REPORT : typ3
    Define the size of report, the PART, LINE etc.....in the Field for Salesman ...define storage ........ and also make a aggregate collection.

    refer to this POST and you can learn a lot from it.........
    http://www.tdlexpert.com/index.php?...es-report-under-construction.7299/#post-45596
     



  11. @Amit Kamdar I guess I did not outline what exactly my query was properly. I have achieved what I wanted to do with regard to salesman mapping etc. But my question is regarding addition to the drop down list.
    I get the drop down list and when i press Alt + 3 which is the key i have defined it opens a prompt and inputs data and says accept but after that that data does not get added to the drop down list.

    My Basic Question is How do I define the Key Correctly such that It adds another Name to the predefined list typ without having to change the TDL every time to manually add a name to the list. Once the Salesman is added it should be automatically available to pick from the drop down list.

    i dont need any report or anything else .. I will use the default reports to fetch the storage value along with buyer name when I take a report. The report part is what I saw people have done to make the Key Work. If the list can be added to without having to define any report or part thats also okay for me. I hope my query is clearer now.

    Just need to be able to add a new value to a drop down list with the key

     


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I understood clearly what you need ....... and drew your attention to the code, .......in that code....... the button takes you back to the creation of Salesman list....... there is another method you can adopt......... that is LIST ADD ........ kindly refer Developer for the same .... you can add a new LIST through a function.
     
    Adeshwar Mehta likes this.



  13. @Amit Kamdar Thanks. Achieved what I wanted to using your guidance and reference post.
     


Share This Page