I’m working on a Inspection survey app.
What I’m looking for is a notification (workflow) that checks if the amounts of defects for an
specific Employee, for today and for an specific group is Greater that X number that comes from an other table, if so… advice me!!
This is my formula:
AND(
SUM(
SELECT(
Inspection Detail[# Defects],
AND(
[Employee] = [_THISROW].[Emplyee],
[Date] = TODAY(),
[Group]="Group #10"
)
)
) >
ANY(
SELECT(
Alerts[Maximun Amount of defects],
[Defect]=[_THISROW].[Defect]
)
)
,
[_THISROW_BEFORE].[ID Inspection Detail]<>[_THISROW_AFTER].[ID Inspection Detail])
It looks mostly correct to me. How is it not working? Have you tried splitting the expression into smaller parts and confirming that they are working as expected?
Perhaps just a simple typo?
I do not understand what this part is for, is it pertinent?
Hi @Marc_Dillon !!.
The [Employee] was a type error, but is not the main problem.
I do not understand what this part is for, is it pertinent?
This is because sometimes I get multiples notifications for the same record, so that is a way to avoid that
Perhaps you should use a report rather than a workflow? Then you can guarantee the notification gets sent only once.
I’ll Do it
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |