Forum Discussion

SaviNewman1's avatar
SaviNewman1
Qrew Trainee
10 months ago

Complex Formula maybe?

I understand what I want to do, and some of what I need to do - I just can't seem to implement it. We have many tables. We have 2 tables in particular that already have a relationship called W...
DonLarson's avatar
DonLarson
Qrew Commander
10 months ago

Savi,

Here is an architecture to support getting Notifications when a Retest passes.

There are two key pieces:

  • The Sample Type is is set to Retest and is a Look Up Field in the Sample Status Change Table
  • You build the Notification in the Sample Status Change Table.

Your Notification is straightforward.

When a Sample Status Change is Added

  • Related Sample Type = Retest
  • Sample Status = Pass

Then send the Notification.

This way you can have a hundred samples tested that are Random, Periodic or whatever you call Samples that are not Retests that Pass and no Notification will be sent.



------------------------------
Don Larson
------------------------------