Formula user list that receives info from another table

Question

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
------------------------------

blakeharrison · Answer

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
------------------------------

markshnier__you · Answer

Mike,Can you use a Report Link field to embed a report in a form. &nbsp;That way you do not need to have a relationship.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

michaeltamoush · Answer

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
------------------------------

blakeharrison · Answer

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
------------------------------

Forum Discussion

Formula user list that receives info from another table

Related Content

Moving Fields from One Table to Another

Delete Formula Button Error

Formula Assistance

Date Field Formula

Formula Url Buttons