0
Email sent once Alla records are in given status
Hello, i would need ninox to send me an email once all the records are processed and changed in status at the end of the working day.
I was thinking of using the Trigger after update in the table settings but what i“m missing is the formula to count/check if there are no more records in a given status then send email to say ”all records completed ecc...“
Can someone help? Thanks!
2 replies
-
To check if there are records in some status you could use
if cnt(select yourTablename where status = “In Progress”) = null then .....(send email).... end
Steven
-
Thanks Steven! Great!
Content aside
- 4 yrs agoLast active
- 2Replies
- 413Views