ClearCollect(
colExistingRecord,
Filter(ButtonClicks, UserEmail = User().Email, ClickDate = Today())
);
If(
CountRows(colExistingRecord) > 0,
// If a record exists, update it
Patch(
ButtonClicks,
First(colExistingRecord),
{ ClickCount: First(colExistingRecord).ClickCount + 1 }
),
Patch(
ButtonClicks,
Defaults(ButtonClicks),
{
UserEmail: User().Email,
ClickDate: Today(),
ClickCount: 1
}
)
);
Patch(
ButtonClicks,
Defaults(ButtonClicks),
{
UserEmail: User().Email,
ClickDate: Today(),
ClickCount: 1 // Each press is logged separately
}
)
CountRows(Filter(ButtonClicks, ClickDate = Today()))
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2