Display only last four digits

Discussion in 'Free Source Codes' started by Rohit Khedar, Apr 1, 2021.

    
  1. Rohit Khedar

    Rohit Khedar Member


    I want show Display only last four digits in tally give plz any idea.
    Code:
    Ex.
    
    :-Mobile Number  = ***-***-1111
    :-Bank a/c Number= ****-****-****-2222
    :-Aadhar Number  = ****-****-3333
     


  2. Bipin Damania

    Bipin Damania Active Member


    Use
    $$Stringpart
     


  3. Rohit Khedar

    Rohit Khedar Member


    not work Bipin ji
    [Field : democontct]
    Use : Name Field
    Style : Normal Bold Italic
    Set as: $$Stringpart:mad:@Ledmbl:4
    Color : Blue
    Width : 12

    [System:Formula]

    Ledmbl:$LedgerMobile:Ledger:$LedgerName
     


  4. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    Set as:$$stringpart:mad:@ledmbl:4:12
     


  5. Rohit Khedar

    Rohit Khedar Member


    Thanks Pankaj Ji hear good work for mobile but starting six digits no show in ******

    Set as : $$StringPart:mad:@Ledmbl:6:4
     
    Last edited: Apr 1, 2021


  6. Sanjeev S

    Sanjeev S Active Member


    Try this.....

    Code:
    [System    :    Formula]
        PartyCell                :    $LedgerMobile:Ledger:#EIConsignee
        MyCellWidth            :    $$StringLength:@@PartyCell
        MyCellL4Digits    :    $$StringPart:@@PartyCell:(@@MyCellWidth - 4):4
    
     


  7. Rohit Khedar

    Rohit Khedar Member


    Sanjeev S# Good work but still starting six digits no show star type ******

     


  8. Sanjeev S

    Sanjeev S Active Member


    In the formula you are getting no of digits replace them by no of "*"s
     


  9. Rohit Khedar

    Rohit Khedar Member


    manualy set "******"
     


  10. Rohit Khedar

    Rohit Khedar Member



  11. Sanjeev S

    Sanjeev S Active Member


    No of Starts are (@@MyCellWidth - 4)
     


  12. Rohit Khedar

    Rohit Khedar Member


    Sir ji my Query is when enter mobile no in field and enter after show mobile no in formates

    Ex. Mobile no 1234567890

    ******7890 ;; i want this type
     


  13. Rohit Khedar

    Rohit Khedar Member


    ******7890 ;; i want this type in field

    [#Line : EI Consignee]
    Add : Option : democontctno :mad:@IsSales

    [!Line : democontctno]

    Add : Fields: Medium Prompt, democontct

    Local : Field : Medium Prompt : Info : $$LocaleString:"Phone No :"


    [Field : democontct]

    Use : Name Field
    Set as : @@MyCellL4Digits



    [System : Formula]

    PartyCell : $LedgerMobile:Ledger:#EIConsignee
    MyCellWidth : $$StringLength:mad:@PartyCell
    MyCellL4Digits : $$StringPart:mad:@PartyCell:(@@MyCellWidth-4):4
     

    Attached Files:



  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Set as : $$String:"******" + $$String:mad:@MyCellL4Digits
     


  15. Bipin Damania

    Bipin Damania Active Member


    You are trying hard...
     


  16. Rohit Khedar

    Rohit Khedar Member


    Amit sir this is right heare manualy do set condition for user control "******"
    but sir hear if we set for condition admin control then how to show full mobile no
     


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    If CmpUser = admin then $mobilenum:led:#eiconsignee else ........that value

    Above not real formula...just a rough syntax.........you can do it........:)
     


  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Or else SIMPLE...... you have given condition for FIELDS to be shown only if it is SALES......... just add...CmpOwner to that condition.

    Then only Owner can see full mobile...... there is no need for any funky characters like * or X or anything.
     


  19. Rohit Khedar

    Rohit Khedar Member


    tnx amit sir i think this idea good for me .
    i want creat a wallet and have in this all my private id ,pass and no etc.
     


  20. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Good luck.......
     


  21. Rohit Khedar

    Rohit Khedar Member


    Thanks
     


  22. subash pal

    subash pal Member


    I want to fetch data like this

    master level field value
    kathamandu
    butwal
    Pokhara

    In report
    KTM
    BTL
    PKR

    Means Kathmandu = KTM, Butwal = BTL, Pokhara=PKAR

    and Can we Fetch more than 2 field Value in one report Field, If yes Please Guide me sir
     


  23. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Yes, you can, But you need to break the value after the 11th and it should go to another Formula.....
     
    Last edited: Apr 11, 2021


  24. subash pal

    subash pal Member


    Thank you Sir

    I will try
     


  25. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    **Formula ...... not field

    You need to define the parameters in SYSTEM : FORMULA
     


Share This Page