Hi - I have a table, applications and another table, custodians, I have it all working fine in the form, I can add one or more users to an applications etc. On the view though, I want to add the column showing who is the custodian, how do I do this?
How about creating a report and do grouping based on the parent entity. You can do this using out of the box report wizard or can create custom report.
Is it not possible to create a dashboard or page or something else that shows this though?
Hi,
You can only add current entity and parent entity (lookup entity) field in your entity view.
OK, that makes sense - suppose i can do something like a PowerBI to display what I want
Hi @Craigja ,
If you are viewing the Applications table view you will not be able to add the custodians to the view because it is a "One to Many" so it does not have a single value to choose. You would be able to add the Application to the Custodian view (using Related when adding fields to the form) since the Custodian has a lookup field to the Application you can add any application field to the Custodian view.
If i look in relationships I see a one to many between the apps table and the custodians table
What is the current relationship between the two tables?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Tom Macfarlan as our Community Spotlight for October…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 752 Most Valuable Professional
developerAJ 472
Michael E. Gernaey 358 Super User 2025 Season 2