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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives