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