Discussions

Expand all | Collapse all

Formula user list that receives info from another table

  • 1.  Formula user list that receives info from another table

    Posted 08-25-2020 14:26
    Is it possible to have a formula user list in one table, and have it look at another (unrelated) table and say, show me the list of users who's  Title contains xxxx?  (I have an employee table that has a user and a title. I want a different table to return a list of users from that table, based on a formula I set)

    ------------------------------
    Mike Tamoush
    ------------------------------


  • 2.  RE: Formula user list that receives info from another table

    Posted 08-28-2020 14:50
    At present, no. Formulas cannot access data from un-related tables.  How are you wanting to use this list of users? Is this just for display to the current user or is there something more that you want to accomplish?

    ------------------------------
    Blake Harrison - DataBlender.io
    Quick Base Solution Provider
    ------------------------------



  • 3.  RE: Formula user list that receives info from another table

    Posted 08-28-2020 15:00
    Edited by Mark Shnier (YQC) 08-28-2020 15:00
    Mike,
    Can you use a Report Link field to embed a report in a form.  That way you do not need to have a relationship.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 4.  RE: Formula user list that receives info from another table

    Posted 26 days ago
    Edited by Mike Tamoush 26 days ago
    I'm just looking to have a dropdown list for a selection (in this case it is a selection of users, but I have this same case scenario for a simply multiple choice drop down) where the list is populated from another field, but also filtered. As far as I know you have two choices:

    1. Multiple Choice Field (or other similar field) and choose to get values from another table. However, this does not allow for filtering.
    2. Relate the field, and use a filtered report. This works, but I was trying to avoid creating relationships for no other reason than to get a filtered list.
    3. Just thought of this - I could create another field in my source table with a formula that essentially returns the items I want, and is blank for items I dont want. I can use that as the field to get values from...

    ------------------------------
    Mike Tamoush
    ------------------------------



  • 5.  RE: Formula user list that receives info from another table

    Posted 20 days ago
    I would encourage you to go with Option 2. While you may only find limited use for it in the beginning, you may find other ways that a 'Resources' table may be useful in the long run.

    ------------------------------
    Blake Harrison - DataBlender.io
    Quick Base Solution Provider
    ------------------------------