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. 
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    9 years ago
    You could create a QuickBase to QuickBase Sync table and just sync across records which are flagged as being eligible.
  • AndreonnaGarret's avatar
    AndreonnaGarret
    Qrew Assistant Captain
    9 years ago
    You mean set up another table that would have similar fields, and only pull the records information if it meets specific criteria?
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    9 years ago
    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.
  • AndreonnaGarret's avatar
    AndreonnaGarret
    Qrew Assistant Captain
    9 years ago
    Definitely, a thought to consider. Thank you for the suggestion.