Discussions

 View Only
  • 1.  Can I create a multi-select text field in which the values pull from a lookup field?

    Posted 03-27-2017 14:30
    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.


  • 2.  RE: Can I create a multi-select text field in which the values pull from a lookup field?

    Posted 03-27-2017 15:17
    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)


  • 3.  RE: Can I create a multi-select text field in which the values pull from a lookup field?

    Posted 03-27-2017 18:48
    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. 


  • 4.  RE: Can I create a multi-select text field in which the values pull from a lookup field?

    Posted 03-27-2017 18:50
    You could create a QuickBase to QuickBase Sync table and just sync across records which are flagged as being eligible.


  • 5.  RE: Can I create a multi-select text field in which the values pull from a lookup field?

    Posted 03-27-2017 18:52
    You mean set up another table that would have similar fields, and only pull the records information if it meets specific criteria?


  • 6.  RE: Can I create a multi-select text field in which the values pull from a lookup field?

    Posted 03-27-2017 18:54
    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.


  • 7.  RE: Can I create a multi-select text field in which the values pull from a lookup field?

    Posted 03-27-2017 18:58
    Definitely, a thought to consider. Thank you for the suggestion. 


  • 8.  RE: Can I create a multi-select text field in which the values pull from a lookup field?

    Posted 05-14-2018 15:04
    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.


  • 9.  RE: Can I create a multi-select text field in which the values pull from a lookup field?

    Posted 05-04-2020 19:51
    @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
    ------------------------------