Hello,
I am building a managers view for attendance,
I have already an app which will record if the members is logged in or logged out
and this is the Columns for this
And I am building this Manager's View App
I already filtered this gallery based on the members who is reporting to me.
The source on this gallery is this.
What I want now is to change the Icon Color based on the status on the Tracker.
In the Screenshot provided the Icon Color is Green because It already captured the old entry on the list.
* Looking on the first screenshot I already logged out which means the icon should be now red, but still captured the old one.
Mentioning sir @WarrenBelz on this.
Thank you!
Solved! Go to Solution.
Hello @Marlin-A
Add a column Status to your Members list. On the Log On button
If(
IsBlank(
Lookup(
Members,
Member_Email = ThisItem.Member_Email,
Member_Email //there is no item present
)
),
Patch(
Members,
Defaults(Members),
{
User_Email:User().Email,
Status:"Logged On"
}
),
UpdateIf(
Members,
Member_Email = ThisItem.Member_Email,
{"Status: "Logged On"}
)
)
On the Log Off button - the member will already be there
UpdateIf(
Members,
Member_Email = ThisItem.Member_Email,
{"Status: "Logged Off"}
)
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.
Hi @Marlin-A ,
From the previous post, you wanted to show the latest item for the user, this seems to be a different question again.
I thought we had solved the icon colour question - can you please elaborate on exactly what extra items you want to solve.
Ok @Marlin-A ,
You want one item only from the user (the latest) and you want the icon to change colour depending on what the status is and you have a list called Tracker which contains all logging information but you need one record from EACH user.
I had a go at this, but it is way too complex - you would have to cycle through the entire Tracker list in descending order and then on each item check if it was already in the list.
Can I please make another suggestion that would work perfectly. Have a list of users and a Status and simply Patch to this when a button was pushed. You could automatically add new users to the list if the user was not already there by doing a lookup and having a new item rather than an update.
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.
Hello @WarrenBelz ,
Thank you, What I am struggling to do right now is to make a column on my members list and then If I push the button it will also update real time on the Members list. So it is easy to called the status value.
Patch(
WFH_Tracker,
Defaults(WFH_Tracker),
{
Member_Name:DataCardValue2.Text,
Member_Email:DataCardValue1.Text,
Status:DataCardValue3.Selected,
Submission_Date:Now()
}
);
I have this patch syntax on my submit button, figuring out how can I update the specific column record on Members SP list based on the Member_Email
Thank you!
Hello @Marlin-A
Add a column Status to your Members list. On the Log On button
If(
IsBlank(
Lookup(
Members,
Member_Email = ThisItem.Member_Email,
Member_Email //there is no item present
)
),
Patch(
Members,
Defaults(Members),
{
User_Email:User().Email,
Status:"Logged On"
}
),
UpdateIf(
Members,
Member_Email = ThisItem.Member_Email,
{"Status: "Logged On"}
)
)
On the Log Off button - the member will already be there
UpdateIf(
Members,
Member_Email = ThisItem.Member_Email,
{"Status: "Logged Off"}
)
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.
User | Count |
---|---|
225 | |
101 | |
93 | |
56 | |
30 |
User | Count |
---|---|
286 | |
116 | |
109 | |
62 | |
57 |