Answered

Daily Employee Attendance Tracker

Like (0) Share

Report

Posted on 23 Mar 2020 13:59:32 by adyboon

I've spent hours trying to come up with a way to track daily employee attendance. Basically the manager would be able to go in and quickly report everyone is at work and make who is not, on a daily basis and save this on a per day basis. Essentially we would be able to see a week or two worth of attendance. We would also need to be able to add a reason for being out.

While I can make it work by doing one employee at a time, I have not been able to update all employees with either a toggle or check box, quickly, from the gallery. I also have been unable to record successive dates in a row. If the employee is out a button wold allow the manager to go to a further edit screen and detail why. I have several Sharepoint lists such as, employees, department, checkin, supervisor, reason out, and dates.

This stems from being able to track who is out and who is in, in reference to the current Covid virus. My industry requires field people to continue working and we want to be able to track who is in and out and why.

Any ideas would be greatly appreciated.

Categories:

General Questions

All responses (3)

Answers (1)

Verified answer

WarrenBelz 146,976 Most Valuable Professional on 29 Mar 2020 at 04:03:45

Like (0)

Report
Re: Daily Employee Attendance Tracker

Hi @adyboon ,
All of this is possible from a gallery with an UpdateIf statement - I will give you some basics to explore.
Firstly you need to have the ID or some other unique identifier in the data source forming the Items of the gallery. It does not have to be displayed, it just needs to be in the data. I will run with ID on this one.
In its most basic form, I will simply save the true/false when the checkbox is updated, but you can edit anything in a gallery including having edit/save/cancel icons using this methodology and a Variable based on the ID.
So on both the OnCheck and OnUncheck of the checkbox, put this (note you will have to change the names to yours)
UpdateIf( YourDataSourceName, ID = ThisItem.ID, {YourYesNoFieldName: YourCheckBoxName.Value} ); Refresh(YourDataSourceName)
and in the Default of the checkbox
ThisItem.YourYesNoFieldName

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
adyboon 38 on 25 Mar 2020 at 12:52:19

Like (0)

Report

Re: Daily Employee Attendance Tracker

Thanks, I'm now at the point I'm trying to figure out how to save each person's status on a day. Say Mon-Friday with dates, and then the next week and so on? The supervisor would be going down the gallery and then to the edit form to change the daily status. Typically just, a yes or no if they are here and the date. So a sharepoint list with "yes/no", "date", "employee"?

If so, then how would it store the subsequent dates?
Community Power Pla... on 24 Mar 2020 at 09:30:48

Like (0)

Report
Re: Daily Employee Attendance Tracker

Hi mate,

To update a toggle/checkbox value for everyone in the gallery, set it up like so:
Add the toggle to the gallery, and set the Default Value to enableAll
Add a button, lets call this Change all
Set the OnSelect property of this button to: UpdateContext({enableAll: !enableAll})
Voila! You will now be able to update the status for every record in the gallery at once 🙂

As for the rest of the items, I would need to see a bit more of your setup and what you're aiming to do. I'm available to do a Teams meeting if required.

Regards,
Jacob Shand | Automation Specialist
NextStep Creations

Taking your PowerApps Skill the NextStep