Forum Discussion

AndreonnaGarret's avatar
AndreonnaGarret
Qrew Assistant Captain
8 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 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.
Tables and fields

8 Replies

Sort By
  • JengWata's avatar
    JengWata
    Qrew Trainee
    7 years ago
    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.
    • ChelseaCarpente's avatar
      ChelseaCarpente
      Qrew Trainee
      5 years ago
      @Jeng Wata - I was just having the same issue! If you toggle "From another field" back to "From list", you'll see QB added all the values from the other field as a list. Delete the list values, then return the toggle to "From another field", and you'll be able to save changes to the field again.
      ​

      ------------------------------
      Chelsea Carpenter
      ------------------------------
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 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
      8 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
      8 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
      8 years ago
      You mean set up another table that would have similar fields, and only pull the records information if it meets specific criteria?