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

null
    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    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

    • CLD
    • Valerio
    • 3 yrs ago
    • Reported - view

    Thanks Steven! Great!

Login to reply

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 413Views