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

Question

Hello,&nbsp;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.&nbsp;1. Is this possible to do?2. If so, can someone walk me through doing so?Please let me know if I need to provide more detail.Thank you in advance.

jengwata · Answer

Hi all, AT Multi-select Text field potions, when selecting "From another field", it prompted to 778 choices specified. Field may not have more then 100 choices. How to fix it since we have done this with the long list over 500 and it works before, but can't do it this time.

mcfneil · Answer

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 · Answer

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.&nbsp;

quickbasecoachd · Answer

You could create a QuickBase to QuickBase Sync table and just sync across records which are flagged as being eligible.

andreonnagarret · Answer

You mean set up another table that would have similar fields, and only pull the records information if it meets specific criteria?

Forum Discussion

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

Related Content

Multi-Select Fields with Commas in Pipelines

If Then Else formula with a multi select field.

Checkbox Fields Vs Multi-Select Fields for Tracking

Find and Replace Field Values

Using multi select field in pipelines