Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

look up from a specific view

Solved
Jump to Solution
119 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi, I don't know if it is possible and I don't how to do it, or if it is a feature that is still not available in airtable.

I have 2 tables: Reports and Users.

I divided the reports by categories (1,2,3 etc), and I created different views for each category.

I would like to lookup or rollup the category in the user table based on the different views that I created in the report table. In this way, I will filter the users by the categories, and I can apply some automation. Without this feature, I have, for example a person that has this: 

35.PNG

I would like, for example, that this person has only the code "5" and filter all the other data based on that.

Is there any way that I can do this? 

Thank you 🙏

1 Solution

Accepted Solutions

Hi @Sara 

 

Technically no there is not way to do that. BUT you can definitely use the FILTERS in the Lookup field to match the filters in the views. Meaning, the Lookup field will look like the view, but if you change the filter in the view it will not change the Lookup field. 

See Solution in Thread

2 Replies 2

Hi @Sara 

 

Technically no there is not way to do that. BUT you can definitely use the FILTERS in the Lookup field to match the filters in the views. Meaning, the Lookup field will look like the view, but if you change the filter in the view it will not change the Lookup field. 

Thank you very much! I will definitely suggest it as an idea, because it would be easier; the lookup filter just filters for that column not for everything.