Creating custom views with multiple objects

Hi Twenty Team, I would like to create a custom view merging two or more objects. Eg. I have a table of people, companies and company office locations. I would like to see, sort and filter employees of companies by their office locations. If I were to create a new FE component to do this, how should I go about?
3 Replies
thomast
thomast3w ago
Hi @arnavsaxena, this is not possible today. By early Q3, we should enable filtering on the field of a relation. So you could go to the people view, filter on company > location. We also plan on adding custom layouts at some point, so you could mix objects within a view. But not sure when it will happen
arnavsaxena
arnavsaxenaOP3w ago
@thomast I need to build this, would you be able to share a one paragraph architectural description of how I can go about to build this using the current FE components?
thomast
thomast2w ago
Filtering logic lives in packages/twenty-front/src/modules/object-record/object-filter-dropdown. You can have a look an try to build a custom one. But honestly I think this will be complicated. It may be easier to: - create a new field location on people - maintain this field sync with company location. Maybe you could use a workflow for that - filter directly on that field in your view

Did you find this page helpful?