Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

How to prefill customer in Quick create form

Posted on by

In Appointment entity I have a relation ship with Customer Application "One Customer application TO many appointments". When a user add cusotmer application from appointment via Quick Create form I want to pre-populate Customer lookup field from appointment yo Customer. 

I dont want to use local storage for that and I think its not possible via relationship mappings either.

  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: How to prefill customer in Quick create form

    Hi Furqan,

    Both are available. 

    If you want to keep it simple, workflow is a good choice.

    Create one workflow on Appointment entity, start when record is created or record field(customer application lookup) change.

    Add conditions to check if the customer application query and customer query fields have values.

    Update customer application record with value from appointment.

  • RE: How to prefill customer in Quick create form

    can we achieve it with Javascript ? or a workflow on load ?

  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: How to prefill customer in Quick create form

    Hi Furqan,

    One Customer application to many appointments, so Appointment and Customer Application have N:1 relationship, you want to get value from child records to populate parent record.

    Relationship mapping is really not feasible, and you mentioned that you don't want to use local storage.

    From your screenshot, Customer lookup is not required on the quick create form, so you can create Customer Application without populating customer lookup firstly.

    Then you can use workflow/flow to populate it automatically after saving the customer application record

    Because that customer application lookup on appointment will be populated after saving the customer application record, then you can update the record.

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

Product updates

Dynamics 365 release plans