QuickBaseCoachD
5 years agoQrew Captain
Re: One notification when certain criteria are met of all records
You can make a helper table with just 1 record in it.Call the table Timesheet Counts. The Record ID# will be 1.
Make a formula numeric field on the time sheets with a formula of 1 called [Link to Time sheet Counts].
Make a summary of the # of Open Time sheets Waiting Approval and # of Approved Time sheets.
Look up # of Open Time sheets Waiting Approval down to the time sheets.
now, make a Notification to fire when the time sheet status becomes approved and the [# of Open Time sheets Waiting Approval] = 0
Make a formula numeric field on the time sheets with a formula of 1 called [Link to Time sheet Counts].
Make a summary of the # of Open Time sheets Waiting Approval and # of Approved Time sheets.
Look up # of Open Time sheets Waiting Approval down to the time sheets.
now, make a Notification to fire when the time sheet status becomes approved and the [# of Open Time sheets Waiting Approval] = 0