Forum Discussion

AndreonnaGarret's avatar
AndreonnaGarret
Qrew Assistant Captain
9 years ago

Can I create a multi-select text field in which the values pull from a lookup field?

Hello,  I have added a lookup field that contains employees names from another table. I would like to create a multi-select field that is populated based off of the lookup field.  1. Is this pos...
Tables and fields
MCFNeil's avatar
MCFNeil
Qrew Captain
9 years ago
Unfortunately there is not a native way to do it based on a lookup field.

However, you can make that list display values based on a value from a different table, which means your "Employee Name" list.  But, this list will not be filtered at all, and could grow large.

Take a look at this option and see if it solves your problem.

(pardon my scribbles)
AndreonnaGarret's avatar
AndreonnaGarret
Qrew Assistant Captain
9 years ago
This works ok. I just wish there was a way to base this off of a report so it pares the list down. This specifically points to a list of hundreds of contacts now, when I only need it to point to like 10 of them based off of a specific report that was created.