Automated Annual Leave Tracker version 1.0

Поделиться
HTML-код
  • Опубликовано: 11 сен 2024
  • In this video, we will discuss about an automated Business & Annual Leave Tracker version 1.0. You can easily customize this tool according to your requirement and start using the same.
    This tool has below mentioned features:
    1. Plan leave with automated form
    2. Generate report on Summary Page
    3. Review and amend the records in Database
    #AutomatedLeaveTracker
    Please follow the below link to understand the features and download the tool.
    thedatalabs.or...
    Please follow the below link to watch the tutorial on Customized Custom Calendar control.
    • Custom Calendar for Ex...
    www.thedatalabs.org
    Please like, share, comment and subscribe.
    Thanks for watching!

Комментарии • 55

  • @ezkul95828
    @ezkul95828 3 года назад

    First of all, thanks for your great works. I have my own tracker. When I see yours, I have more idea to modify mine.
    What I see is that some of the holidays are good for your country only i believe, and the holiday calendar is for the year of 2019. If we can change it to work for any year this would be prefect.

  • @margaretlopez2195
    @margaretlopez2195 4 года назад +1

    Wonderful...thank you for taking the time to show this. Much appreciated.

  • @jawadkhan4786
    @jawadkhan4786 5 лет назад +3

    Your videos are great. Learning a lot from you. Start a complete series on School management system. I know you can do it. Keep it up bro..

  • @rolandnormiljacques1678
    @rolandnormiljacques1678 4 года назад +2

    Very Nice! Great video,
    Thanks

  • @sanjeevchowdhry
    @sanjeevchowdhry 2 года назад +1

    Hello. It is a great application. But some how after downloading the sheet, I cannot view the sheet tabs. Please advise

  • @mfneyaz
    @mfneyaz 5 лет назад +1

    we are learning !

  • @oneskilltutorials964
    @oneskilltutorials964 5 лет назад +1

    Thank you so much

  • @habibtitu
    @habibtitu 4 года назад +1

    Hello brother it was really great database. I just love it. Thanks for sharing. I have some following issues 1. For example, if I have more than 500 employees how do we entry employee name ? 2. Can we use employee ID to avoid errors with same named 2 employees? 3. If I want to put data entry past leave for example today is 9th and I want put data who has already enjoyed leave 2nd to 7th than how do I give entry (because we collect paper leave form). 4 If I want see employee leave status in dashboard is it possible? Sorry I have asked a lots of questions. I am really facing lots problems at the moment we can’t buy software. It will be great pleasure to get kind reply from you. Thank once again.

  • @davidamoakoagyemang3365
    @davidamoakoagyemang3365 2 года назад +1

    This is great. Thank you. But unfortunately, i don't see any support sheet in my excel file. What could be the reason?

    • @thedatalabs
      @thedatalabs  2 года назад

      Thanks for your feedback! You can download it from the link available in the description box. Download is available at the end of the page. Thanks!

  • @happylife2407
    @happylife2407 2 года назад

    Thank you so much. This tutorial video is very great! I need to creat a annual leave application form for manager's approval, then collect data to an excel record, and finally goes to calendar for marking who's absences. How should it work? Thanks

  • @milospavlovic5160
    @milospavlovic5160 4 года назад +1

    Great video and very helpful. Is there any way that you can maybe show how to add one more employee from VB. I have no idea what i'm doing :)

    • @thedatalabs
      @thedatalabs  4 года назад

      Thanks for your appreciation! Please send your requirements on our email id. Will try to make changes whenever you will get time. Thanks

  • @jamesmwanza4289
    @jamesmwanza4289 2 года назад

    Great work, This will definitely help me. Kindly could you share the code in the project. It's somehow locked

  • @pawanmore948
    @pawanmore948 4 года назад

    I am not able to see support sheet in latest tool. May i know how i will get that sheet. Needs to Update Holiday and Name of employee ?

  • @amrichtetteh
    @amrichtetteh 3 года назад +1

    Can you provide the password to the sheet and the VBA?

  • @pratheekprakash9259
    @pratheekprakash9259 4 года назад +1

    First off all, Great application,
    I wanted to inform you that there is a bug in the code, let me explain this with an example.
    suppose I am applying for a Leave.
    first I click on Plan and select the employee name- employee 1, leave type as - CL/HL/SL not AL ( "because the code is working fine with AL, but not with CL,HL,SL" ), start date as - dec 10th 2019 and end date as - 9th jan 2020, after clicking on submit, the data is successfully stored in the database, but when we click on summary, the same date is also been added for the month of feb and march. for all the three i.e (SL,CL,HL) this is happening but not for AL. could you please rectify the issue !!? awaiting your reply !

    • @thedatalabs
      @thedatalabs  4 года назад +1

      Thanks for your appreciation and feedback! Please send the mail. Will rectify the code and upload it again.

  • @Patelbhaves231
    @Patelbhaves231 5 лет назад +1

    Dear Sir, I watch your video and it is amazing useful tool for small company. I am developing a other tool for my office. which is relate to Task organisation. detail of this i will email you.

    • @thedatalabs
      @thedatalabs  5 лет назад

      Thanks for your appreciation! I will Keep uploading Excel based automated tools. Please keep supporting on RUclips. Thanks! 😊

  • @sasmitasamuel6490
    @sasmitasamuel6490 3 года назад +1

    Can you kindly give the password for vba codes so that I can learn

  • @mantzboy
    @mantzboy 4 года назад

    wow that is great! Could you please make organizational chart using vba in excel. Thanks

  • @sanjuktabhagat4107
    @sanjuktabhagat4107 4 года назад

    Hello sir, This is a nice video, but I can't create the tracker. If you step by step make this every sheet then I will easily make this leave the tracker.

  • @mangjas
    @mangjas 2 месяца назад

    I downloaded the latest version and I believe there is an issue as it not deducting weekly off. How to fix this issue

    • @thedatalabs
      @thedatalabs  Месяц назад

      Will check and fix the issue. Thanks!

  • @borahan5882
    @borahan5882 5 лет назад +1

    Hi thanks for your great tools. However, when i open file, it doesn't show the worksheet and I can't change the emp name or leave type

    • @thedatalabs
      @thedatalabs  5 лет назад

      Thanks for your appreciation! Please check it again as this tool is working perfectly my system.

    • @borahan5882
      @borahan5882 5 лет назад

      TheDataLabs yeah i unhide it already, but the problem is that i add emp name but it doesn’t save in rawsummary and summary

    • @borahan5882
      @borahan5882 5 лет назад

      Can u tell me how to add new name and save to all worksheet when i add in plan form?

  • @nikkin9283
    @nikkin9283 4 года назад +1

    Please share link to download this macro , it would be of great help

    • @thedatalabs
      @thedatalabs  4 года назад

      You can find the link in description box. Thanks!

  • @kothawzinn
    @kothawzinn 4 года назад +1

    Could you provide passwords to unprotect workbook and VBA?

    • @amrichtetteh
      @amrichtetteh 3 года назад

      Did you get the password? Share with me if you got it.

  • @roshanfernandes4383
    @roshanfernandes4383 2 года назад

    There is no Download Link...🙄

  • @mdismailhossain5438
    @mdismailhossain5438 2 года назад

    full version hogi download ka lia

  • @kranthikirans3847
    @kranthikirans3847 4 года назад

    Hi, thanks for the video. But I could not find the link to download the excel file. Please share the link to download

    • @thedatalabs
      @thedatalabs  4 года назад +1

      You can find two different pages in website. One is dedicated to description and another is to download. Thanks!

    • @kranthikirans3847
      @kranthikirans3847 4 года назад +1

      @@thedatalabs Thank you very much

  • @hrd8569
    @hrd8569 3 года назад

    how to add employees

  • @ocean7447
    @ocean7447 4 года назад

    cannot find the support sheet and database

    • @thedatalabs
      @thedatalabs  4 года назад

      Please check the below link to download the file.
      thedatalabs.org/annual-leave-tracker/download-leave-tracker/

  • @nprakash5753
    @nprakash5753 4 года назад +1

    How do I download the file!!!

    • @thedatalabs
      @thedatalabs  4 года назад

      You can find the link in description box. Thanks!

  • @sanjaysrivastava1100
    @sanjaysrivastava1100 4 года назад

    Can't hear anything even at full volume please amp up the volume

  • @emilythewonderdog
    @emilythewonderdog 4 года назад

    Hi Sir,
    Can I discuss with you.

    • @thedatalabs
      @thedatalabs  4 года назад

      Hi Imran, please send your queries on our email id. Thanks!

  • @josemanalo9916
    @josemanalo9916 4 года назад

    Please how to download the system

    • @thedatalabs
      @thedatalabs  4 года назад

      Please download it from the link available in the description box. Thanks!

  • @abdulrasid1572
    @abdulrasid1572 4 года назад

    hello sir.. this video is very good.. Can i get it the file..

    • @thedatalabs
      @thedatalabs  4 года назад

      Thanks for appreciation!
      Yes, link of the file has been provided in description box. Please download it. Thanks!

  • @ravishankar-sg9ry
    @ravishankar-sg9ry 2 месяца назад

    Plzz in hindi

  • @khalidiqbalsiddiqui46
    @khalidiqbalsiddiqui46 3 года назад

    Very unuseful information