580
I have a auto number field which will reset based on Frequency - Daily, Monthly and yearly. if Daily selected the value of NEXT number has to set to 1 .How to check if the value of field was changed today then don't update otherwise update the value.
Hi
I assume you are doing the auto number in a plugin, you could do the following
With the Frequency (Daily/Monthly/Yearly) field, you could also have another field that is datetime - lets call it Next Number Last Modified On
In your auto number logic, if the Frequency is set to Daily, check the Next Number Last Modified On datetime field value.
If its null or if last modified date is before today, you can reset the Next value.
If the value was changed today, you do not need to reset, you increment it by one.
Hi partner,
1.If we want to know if a field has been updated or changed(value or properties), you should enable the audit of this field and then you will be able to see all logs in Audit History.
https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/auditing-overview
If you want to enable the field audit, you could go to field property form and select "Enable" beside "Auditing" label.
2.By the way, if you want the system check it automatically, you should add a workflow and set the trigger condition as "when autonumber field changed and not equal '1'" and then update the field value to '1'.
Hope it helps.
Best Regards,
Leo
Just wondering, why use ootb auto number for this? You could have a background workflow/plugin perform this a little more cleanly.
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,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (