Announcements
Hello everyone,
I have two tables in dataverse that has the below custom columns:
Table 1: (Form Template)
Form Template Result (Fields that should be created from the form template table)
What I want to achieve is the below:
1. I want to populate some custom table names in a lookup column inside the form. (In our example the custom "Form Template Result" table mentioned)
If it's not possible to populate the table name in the lookup column we can use a choice column with hardcoded-name for the tables to avoid using a Text field because the users may write the wrong table name.
Scenarios:
On Add:
2. When the user fills out the form in the form template table I want to create that dynamic field in the table selected.(In our example the custom "Form Template Result" table mentioned)
On Update:
3. If the user added to the "Form template result" table a text column, then he decided to change and modify that column data type to be DateOnly, the form should be affected and the data type will be changed on update.
The same goes if he also decides to rename the attribute or assign it as required.
The purpose of the above is to allow non-it users to create any fields needed to the table they select from the lookup/choice column.
What is the best and efficient way to achieve the above?
Can please someone provide an example with the steps needed?
I read the documentation about Create columns using web API. But I want to see an example of how to call this API onsave event of the form and the other requirements mentioned.
Would highly appreciate if you can assist and any help is highly appreciated.
Thank you!
Hi ,
Thank you for your reply.
I didn't notice that we already have this tool in XRMToolBox, also it has good features.
I will give it a try.
Best regards,
EBMRay
Hi EBMRay,
If you want to achieve it by yourself, it could take you lots of time. There is a tool named Attribute Manager in the XrmToolBox which does the similar things.
Here is a video about this tool, you could have a look:
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156