Announcements
I recently created a new field Today's Date that displays the current date on a record. I created it so that I can trigger a process when another date-type field (Check in with customer) on the same record is equal to the in the Today's Date field.
My plan was to check the Start when Record fields change box and then select my custom field (Today's Date) from the option set. In this way, when the date changes daily in the Today's Date field, the process checks to see if it's equal to the date in the Check in with customer field and if it is, the Process sends an email alert, but my custom field wasn't in the list when I click on Select:
How do I make my custom Today's Date field appear in this list?
Perhaps there's an easier way of getting this Process to trigger based on one date field date field being equal to the current date?
Fun Wei Jie,
I will be using a work-around that doesn't exactly meet my requirements, but will "do the trick." Instead of trying to compare the current date with a date set in another field on the record, I will be using an option value menu where the various options will end up effecting the delay in days before the alert is triggered.
If you know of a way to get a calculated field (like the today's date field I mentioned above) to work within a Process, I'd love to hear it - otherwise, I am not at liberty to spend much more time on this.
Nonetheless, thank you for your willingness to work with me! Perhaps we will meet again on the forums...
All the best to you,
Erik
Hi,
The reason why field is not show in workflow has explanined by Alok Singh.
Understand you need some idea on the workaround.
If you can share more detail about your requirement, perhaps we can give you an idea how to achieve it.
are you using crm online?
Thank you!
Hi,
Unfortunately I am not a technical person but I can see challenge of updating whole set of Account records everyday would be a very a tedious process and it can slow down your performance.
JavaScript and Business rule will not work, to trigger the process user has to open the form manually.
Even workflow would be challenge in getting trigger point.If you have a very small set of Account record then on demand workflow would work. user can create a view or do advanced find and run the on demand workflow everyday to update date field
I would suggest you can write a batch job which will execute during non business hours (may be in night after 12 AM) and it will get the whole set of record , may be active or some other criteria, and update the date field.
Ha! Why would it be easy - right?
Honestly, I'm shocked that the current date/time is not an out of the box option for creating arguments in Processes!
So what is this helpful plugin of which you speak?
Hi ,
'Calculated' field does not work in workflow.
Instead of that you can create a date & time custom field (Today's date) and set the current date with help of plugin or real time workflow
Here's a screenshot of the Process > Information > General Tab and the Field > Information > General tab.
Thanks for attempting to get to the bottom of this with me!
Hi,
Inside the workflow , make sure you selected a correct entity.
Would be good if you can share the screenshot of field +entity and whole workflow.
Thank you for getting back to me so rapidly!
Well, I just made sure all of my recent changes were saved and Published All Customizations, the I cleared my browser cache and lo, no change.
While I can see my custom field (Today's Date) here in Specify Condition:
I still can't see it here:
Any other ideas? Is there a way to directly edit the Select Fields list from within CRM?
Hi
I cant see any reason to not to show the custom field while configuring workflow. Just to double check after adding custom field , have you published the solution?
Try publishing All Customization & also clear browser cache and then try again.
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,807 Super User 2024 Season 2
Martin Dráb 229,135 Most Valuable Professional
nmaenpaa 101,156