Optimization of attendance control
The situation is as follows: I am responsible for monitoring the attendance of all employees at work. This happens in the following way: all employees are added to a Telegram group. In the evening, I send out a poll with options for responses “+”, “-”, and “will be later” for attendance tomorrow. I also send it in the morning. If an employee chooses +, it means everything is okay, they will be at work and on time. If -, they will not be there and they message me in private that they will not be there for some reason. “Will be later” is also communicated to me in private, indicating the employee will arrive later for some reason. After that, I need to generate a report in the form of a list: full names of those who will be at work, full names of those who will not be there along with the reason for their absence, and full names of those who will be later. I also need to compare this with the list of who has responded and who has not. I need to solve this using some special website or a Telegram bot so I don’t waste a lot of time reviewing who has responded and generating attendance reports.
Client's review of cooperation with Sergey M.
Optimization of attendance controlI couldn't implement my idea, from Sergey’s side everything possible was done, I have no complaints, just a bit strange)))
Freelancer's review of cooperation with Oleksii Mironenko
Optimization of attendance controlIt was a pleasure to work, quick responses to questions, good communication from the client, overall everything is great!
-
2174 4 0 Hello!
I am an automation and chatbot specialist, helping businesses reduce routine tasks and accelerate processes through Telegram bots. In your case, a solution can be implemented where:
The bot publishes the poll and collects employee responses,
Compares those who have responded with the overall list,
Requests reasons for absence or lateness via private messages,
…
Automatically generates and sends you a report in a convenient format: who will be there, who will not, who is late and why.
To understand the task precisely, please clarify:
In what format do you have the list of all employees (Excel, Google Sheets, manually)?
Do you need the bot to remind those who haven't marked their participation?
What format of the final report is convenient for you — table, text, file?
I would be happy to help implement this solution and save your time. Looking forward to your response!
Best regards,
Tatyana
-
236 0 1 Great idea to automate the process! We can organize attendance tracking through a Telegram bot that will:
Send a survey.
Record responses.
Receive messages about reasons.
Compare with the list of all employees.
Generate an automatic report in a convenient format.
-
168 Telegram bot for employee attendance tracking
I propose to create a simple Telegram bot that will automate the collection of attendance marks and generate a report in a convenient format. Suitable for groups where it is necessary to monitor who will be at work each day.
What the bot does:
1. Sends a poll to the group every morning and evening
– Options: +, -, Will be later
2. Processes responses
– If an employee chooses - or will be later, the bot automatically requests a reason via private messages
… 3. Generates a final report
– You receive a list:
• Who will be present
• Who will not be (with reason)
• Who will be later (with reason)
• Who did not respond
4. The report is sent to you privately
– Everything is clear, no manual vote checking
Deadline: 2–3 days
Price: ~2000 UAH (50 $)
Ready to start work and, if necessary, expand functionality in the future (integration with Google Sheets, report export, analytics).
If you agree — write, and we will clarify technical details.
-
7134 13 0 Hello, yes, a bot can be made. Attach the data to Google Excel, if necessary, you can connect a chart directly to the Telegram bot so that it pulls from Excel when pressing a button. Waiting for your response
-
3367 148 4 1 Good day.
I can write a bot for data formation.
If you have any questions, you can write to me in private messages.
-
648 5 0 Greetings!
Of course, with the help of the bot. I will connect this to the database and you will receive a ready-made list. Additionally, you won't need to write in the evening - the request for marking "for tomorrow" will be sent automatically to the employee. I also suggest recording the time in the morning when the employee arrives. The comparison will be automatic with a reminder to negligent employees.
In general, I can implement it quickly, write to me privately)
-
726 9 1 Hello! I have reviewed the project and am ready to start working. I am confident you will be satisfied with the result.
-
3367 84 0 Ready to take on the task.
Need to clarify the order details, write to me!
I think we can use a Google spreadsheet.
I will implement it with a script in Python + aiogram3/telethon.