I have a custom check box field Holiday Gift {custentity_holiday_gift} on the Customer Contact record.
I have historically needed to know a list of Customers where no Contacts have this box checked and have used a "Customer" Saved Search with results as:
Formula (Numeric)>Summary Type = Count, Formula = DECODE({contact.custentity_holiday_gift},'T',1,0)
Now, 🤔We want the Sales Rep to determine and update:
of these Customers, that have no Contacts with a Holiday Gift {custentity_holiday_gift} designation, mark one of the contacts Holiday Gift = Yes.
The way the search started out, since it is a "summary" search AND from the Customer record, the Sales Rep cannot "in line edit" the list to update the Holiday Gift {custentity_holiday_gift} field check box. This is as expected.
The Holiday Gift {custentity_holiday_gift} field is on the Contact.
I need:
· Rebuild this search beginning with the Contact record.
· The results not summarized
· The results to include a list of all the Contacts for each Customer that does not have any Contact already designated to receive a Holiday Gift {custentity_holiday_gift}
· The Sale Rep to update the Holiday Gift {custentity_holiday_gift} check box using in line edit on the saved search.
How do I get my search to look at "all the contacts for each Customer" and only return
· the full list of all the customer contacts, only when no contact on the customer has a Holiday Gift {custentity_holiday_gift} field box, checked? (See screen shot example)
I can easily return a list of all the contacts including the Holiday Gift field values but there are too many results for the Sales Rep to scroll through. I can extract the results of the search and reduce what I give to the Sales Rep but this is not efficient for them or for me.
I can easily return a list of all the contacts that do not have the Holiday Gift box checked but some of those Customers already have one contact where the Holiday Gift box IS checked and should not have another contact with a box checked.
Can anyone give me any suggestions to produce a list of Customer Contacts where no Contact on the Customer has a Holiday Gift box checked?
Thanks all.