Hello! We enabled an icon to display in the constituent header where an email is missing. An issue we are having is when only the HH record contains an email address, the affiliated records show the icon even though the header displays the household email address.
Can anyone help me with a SQL code so that email addresses at the HH level are taken into account when looking for a "missing email"? Here is an example...
Household record contains the email address:
Individual record displays the email address, but also the "missing email" icon:
Thank you in advance!