Forms logic - Contact list
I am struggling with forms logic. I need to add a checkbox column to sheets and have that box display in the form when a certain person is selected in the Employee/Contractor (Contact List selection) entry. Looking at the logic, it seems this can be done, except for the fact that when I attempt to set the logic and pick the desired person, that person and many others, are not available as selections.
Yes, all these people have existing entries in the sheets.
Why do all of the Contact List people not show up as available in the form design? It cannot be an issue with the Contact List itself since one sheet will display only 3 people, another sheet 5, another sheet 9, another 7, another 12, etc. We have 17 people on the contact list.