You’re offline. This is a read only version of the page.
5
Hi All,
so we have a requirement where the custom entity has multiple lookup fields pointing to contact and we want all lookup to the contact record to be displayed in a single sub-grid but including the roles.
from contact lookup fields on the custom entity form
custom entity records with roles would be on the contact subgrid
Is this something that can be done out-of-the-box? am I missing anything?
Thanks,
Mark
Hi Mike,
Thank you for your response. I fail to understand how a single field would be able to cover different roles for possibly different users.
Also if it is a single field for a single user role, I can use the default many-to-one relationship as sub-grid to display only that specific role. But I want to display all roles in a single sub-grid.
But the optionset approach is really solid, I just don't understand how to implement an optionset to a single field like what you are saying.
Would you mind providing another example or snippets of your approach or an article?
Thank you so much!
Hi bud,
The way you've structured the custom entity isn't correct.
Why can't you have a single lookup on the custom entity going to contact and then have Role set as a separate field on the custom entity maybe have it as a optionset if you don't want users to type anything in? By default a lookup on the custom entity creates a many to 1 relationship between the entity and the contact record..
That way you can just create a subgrid based on 1 lookup field. It's also more scalable as when you need to add more roles you don't have to create multiple new lookup fields on the custom entity... You can just add a role on the optionset.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
