when i create a column in an entity and that column should be automatically add in multiple another entities.
when i create a column in an entity and that column should be automatically add in multiple another entities.
Hi,
Instead of replicating the data to multiple entities ,. What you can do is to create column at parent Entity and use quick view form to show this field data in child entities.
Hi Ravan,
The only way to automatically create columns would be to write custom code in order to utilize the CreateAttributeRequest in the SDK (docs.microsoft.com/.../microsoft.xrm.sdk.messages.createattributerequest
Unfortunately, there's no trigger in a plugin or workflow for "When a new field is added to a table", and so you may have to get creative in how you want to build this.
If I were to try to accomplish this, I would:
1. Create a table called "New Attribute Request" that would have columns in line with the data you need to create a new attribute using the SDK message above (ie. Table Name, Field Name, Field Type, etc.)
2. Create a plugin that runs on the Create message of the "New Attribute Request" table, retrieves the field information, and calls the "CreateAttributeRequest" message from the SDK, using the fields as the input parameters for the message. In here you would also call the "CreateAttributeRequest" for any other table you want that field to automatically be created on.
3. If you wanted it to be a little more dynamic, I would have a field on the "New Attribute Request" that can be used to identify what table(s) you would like the new field to automatically be created on. For example, a multi-select option set that could have Contact and Account selected, which would then tell the process to automatically create the field on those 2 tables.
Essentially what this process would be doing is allowing the user to create a record in the New Attribute Request table that would automatically create the column on the identified table, as well as create the same column on any other identified tables on that record.
I hope this sort of makes sense and gives you a starting point.
Thanks!
Matt Bayes
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,570 Super User 2024 Season 2
Martin Dráb 228,683 Most Valuable Professional
nmaenpaa 101,148