cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adyboon Helper I
Helper I

Daily Employee Attendance Tracker

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.

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz Community Champion
Community Champion

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.

View solution in original post

3 REPLIES 3
JacobShand Helper II
Helper II

Re: Daily Employee Attendance Tracker

Hi mate,

 

To update a toggle/checkbox value for everyone in the gallery, set it up like so:

  1. Add the toggle to the gallery, and set the Default Value to enableAll
  2. Add a button, lets call this Change all
  3. 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

adyboon Helper I
Helper I

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?

WarrenBelz Community Champion
Community Champion

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.

View solution in original post

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (7,750)