160
I want to get the total entity record count when a form is submitted and add that value to a field. I see how to get the record count for a report, but this is for a form.
I'm using D365 online version 9.x.
Thanks
*This post is locked for comments
For version 9.0
Thanks Mike, pls accept the answer & close the thread to help future solution seekers.
Unfortunately, I can't use the auto number function as I need to query the total amount of records per day and not the total records. I didn't mention that in my description. Sorry for that.
Stefan,
Sorry that I didn't respond sooner. Your solution will work, but I need the calculation of the record count to be executed after the record is created, so I don't think this will work for me.
Hi
You could do this in couple of different ways, but I am going to mention one that involves less work and performance wise a bit better approach
Assuming the created record has parent entity, you could add a roll up field to the parent entity to do the count and then you can have a quick view form on the child entity to display the total record count. It will update on an hourly basis just to make sure the system performance is not affected. But if you want the update instantly, you can manually or programatically force calculate a rollup field to get the number updated but this may affect the performance a bit.
Let me know if you need more info on this
Why not use the standard auto number function of Dynamics 365 CE that can be based on a sequential number,
You can enable a existing or new field as auto number field.
Use to XrmToolBox plugin to set the field and its seed (begin number) for this
www.xrmtoolbox.com/.../Rappen.XrmToolBox.AutoNumManager
More info about the configuration: http://anm.xrmtoolbox.com/
Hi ,
Plugin is the best options for increment the value to avoid redundancy. Let say if you write logic in client side and get total record count and at the same moment another user create record in the same entity you may get wrong value at client side. So write a create message , post operation plugin and in the plugin code get total record using FetHXML and set the value to the field to update.
You can also do this using workflow but in that case you need to maintain another entity to track the last number. Have a look my article , you may get some idea-
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (