Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Unanswered

Relationship between Entity Fields based on Product Entity Databases

Posted on by 5

Hello,
in the "Products" entity, for each product I have the "Name" and "Product_ID" fields filled in. Example
Name: Paint White, Product_ID: Paint_001
Name: Paint Black, Product_ID: Paint_002
In the "Cases" entities, I want to create 2 fields there - "Complaint Product Name"(mapred to "Name" in "Products" Entity) and "Complaint Product ID"( mapred to "Product_ID" in "Products" Entity)
How to do if someone selects "Complaint Product Name" the system will automatically fill in "Complaint Product ID". And vice versa - if someone chooses "Complaint Product ID", it will automatically fill in "Name of the complained product"
Example:
If I select "Paint White" in the "Complainted Product Name" field, the "Complaint Product ID" automatically becomes "Paint_001"
and vice versa
If I select "Paint_002" in the "Complaint Product ID" field, the "Complaint Product Name" field will automatically become "Paint Black"

If you like, you can send me a post about this topic or a video that shows exactly this. thank you in advance

  • MikeC282 Profile Picture
    MikeC282 2,095 on at
    RE: Relationship between Entity Fields based on Product Entity Databases

    You'll need to write a Javascript web resource and have a function trigger onchange for either of the fields.

    Can you show me a screenshot of what the fields look like on the case? I need to know as the method of setting a field is different between a text or a lookup field.

    Kind regards,

    Mike

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans