Monthly Request an Update WorkFlow
Hello All,
First time poster - I am needing help regarding a Workflow Request an Update where I would like the Workflow to send out the particular contacts monthly, but have the Workflow change the month of data I am trying to capture.
Example, data-set is broken out into month by plant. I want the WorkFlow to request monthly updates for each Plant / contact (previous month, on the 1st of the new month. Ex: On Dec 1st, update request would go out for NOV 2021 rows).
Is this possible without having to create a Request an Update WorkFlow for every month - Can I add in a formula to the condition portion of a WorkFlow? See screenshot attached.
Thank you,
John
Answers
-
Hi Mate,
Would something like this help. Its not perfect. In your example it might show some fields from 31 Oct... is that close enough?
-
If not, a work around could be helper columns
You could have:
Helper column 1 = Record date
Helper column 2 = if(month([record date]-1)=month(reference),"yes","")
Then you could use the condition helper column = yes in your automation.
Yep, that'll work. Not sure about syntax.
-
Hi BullandKhmer,
Thanks for your help here - You are on the right track, ideally I would for this automation to work with minimal manual intervention. I'm trying to get the helper column to work, but no luck.
The contacts that will be inputting data will be responsible for multiple rows on a monthly basis.
Appreciate your help!
-John
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives