How to create a view/ table of multiple objectMetaDataItems?
Hi,
I have a one to many mapping with multiple objects from people. Eg. people to jobs and jobs to whatsapp messages.
I want to view all the people with their corresponding jobs and whatsapp messages in one table.
How can I create a table/view with multiple objects (merged/ joined) in one?
Please help me understand the broad structure around - should we create a new view/ is there a different/ better way?
—any update, guys?
Best, Arnav
6 Replies
Hi, not sure to fully understand the usecase. Could you detail a bit more. You have
- people <=> Many messages;
- people <=> Many jobs
- jobs <=> many messages
And what would you want to see?
Yes, I want to see a table with people and each Message(job_name) as column name and messages as row values
You cannot do this using relations today. You can see your table of your peoples with the associated jobs. And then click on your job so you will see the associated messages
If you really want it in one view you could use a JSON field on people that contains jobs and messages. But I doubt you want to do something like this
We have forked the repo, so are trying to put this in a single view.
Any guidelines on how to rewrite the recordTable?
I do not really understand the final design you want to achieve but this looks like a big challenge. Do not hesitate to share your final version once you get through this 💪
And there are no guidelines since this component is still updated often. It would be hard to keep a doc about it
Kk