Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / can fields be added on...
Finance | Project Operations, Human Resources, ...
Suggested answer

can fields be added on form dynamically on basis of records present in lookup field?

(0) ShareShare
ReportReport
Posted on by JJDunaid 206
////
Hi everyone,
i have a scenario, this is  an inquiry form which is working on basis of parameter values, first parameter is working fine but i have to develop a functionality on second parameter on basis of /blank or given / value in parameter (Warehouse). 
for example if my warehouse parameter is showing values in lookup (as it is showing six warehouses) if i pass blank value in parameter the number of warehouses should be added in grid (as per present scenario six fields should be added to grid dynamically) and only one field should be added into grid when a specific warehouse is selected.
 
is it possible? Experts i need your guidance. 
  • Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 1,399 Super User 2024 Season 2 on at
    can fields be added on form dynamically on basis of records present in lookup field?
    Hi,
    The above mentioned scenario is possible based on the parameters mentioned in the Lookup, however, adding multiple lookup parameters isn't a recommended approach as it will also impact the performance on the system. The suggestion is to add a display method for the fields to be visible based on the warehouses being selected in the lookup. This would be a recommended approach.
    For example, when you pass blank value in parameters, the number of warehouses to be added should be a display field and you can add this code to the modified event handler of the lookup. 
  • Martin Dráb Profile Picture
    Martin Dráb 230,540 Most Valuable Professional on at
    can fields be added on form dynamically on basis of records present in lookup field?
    Sure, a matrix control is a good way to visualize the data, if doing it in the form is not required.
  • JJDunaid Profile Picture
    JJDunaid 206 on at
    can fields be added on form dynamically on basis of records present in lookup field?
    Yes Martin,
    I got your point , I found another option to  do it with the "the Matrix control in a report".
    it is way more easier.
  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 230,540 Most Valuable Professional on at
    can fields be added on form dynamically on basis of records present in lookup field?
    Well, many of things are possible with enough effort, but it doesn't sounds like a good idea to me. It would be difficult, it would conflict with F&O UX guidelines and it could have negative impact on performance. If you want to display a value for each warehouse, why don't you create a separate grid with warehouses related to the selected record? It'll be easy ti to do, it'll support any number of warehouses, it'll allow filtering and sorting, it's the design users are used to from the rest of F&O...

    (Moved from Dynamics AX forum.)

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,540 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans