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

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
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 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.
Photo of Andreonna

Andreonna

  • 1,040 Points 1k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
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)
Photo of Andreonna

Andreonna

  • 1,040 Points 1k badge 2x thumb
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. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,736 Points 50k badge 2x thumb
You could create a QuickBase to QuickBase Sync table and just sync across records which are flagged as being eligible.
Photo of Andreonna

Andreonna

  • 1,040 Points 1k badge 2x thumb
You mean set up another table that would have similar fields, and only pull the records information if it meets specific criteria?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,736 Points 50k badge 2x thumb
Yes, another table that would sync every hour automatically with the selected choices from the real table.  Or skip that complexity and just make a regular separate table for your choices.
Photo of Andreonna

Andreonna

  • 1,040 Points 1k badge 2x thumb
Definitely, a thought to consider. Thank you for the suggestion. 
Photo of Jeng Wata

Jeng Wata

  • 90 Points 75 badge 2x thumb
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.