look up from a specific view

[Sara]

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: 

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 🙏

[Mohamed_Swella1 · Accepted solution]

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. 

[Sara]

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. 

[epinteriors]

I am trying this and it isn't working. I want to look up a specific view but it didn't work so I tried the filters and that isn't working either.