I have the following scenario that I'm tyring to put together, but I'm getting lost at a very easrly stage:
On a Customer (or Lead/Prospect) view, I want to have a field that shows the name of a particular type of support tech (one for our super special support program - ESSP). The field, when editing the Customer should only show the employees that are marked by a checkbox as being ESSP tech reps.
Where do I start?
well.. the first thing I did was create a new Custom Entity Field, of type checkbox, called "essp_tech_rep" and assigned this to the Employee Record Type. I think found the 3 appropriate employees, and checked this box for them (the other 100+ are left unchecked).
(and this is where I am getting lost)
So, now I need to create a new custom field, of type list/record (?) to be assigned to the Customer record type. The values in this custom field need to be ONLY those employees that have the "essp_tech_rep" field checked.
How do I do that?
I've tried creating a new Custom Record Type ('ESSP Tech List'), and then adding a field to it, where that field is of type "list/record" and the "list/record" value is "Employee". Also, under "Sourcing and Filtering" for that field I selected my "essp_tech_rep" field as a Filter with "Is Checked" = Yes and "Compare Type" = "equal".
The problem is when I try to view the record of my 'ESSP Tech List', there are no records.
What am I doing wrong?
Thanks in advance