How do I send an immediate update request followed by recurring update requests until completed?

My current attempt:
1) When rows are added, update 'Status' to 'Pending Update'
2) When rows are added or changed AND when 'Status' changes to 'Pending Update', request an update (this is the immediate/initial update request)
3) When rows are added or changed AND when 'Status' changes to 'Pending Update', record a date in 'Update Request Sent'
4) When a date is reached (every week on MWF), where 'Status' is 'Pending Update', and where 'Update field' is blank, and where 'Update Request Sent' is not today, request an update (this is the recurring update request)
I feel like there must be a simpler way to do this with fewer workflows? Thank you!
Best Answer
-
Hi @kebern
This looks good to me!
You potentially don't need the third workflow, to record the date, since you have the "update field" being blank as a criteria in your recurring workflow. However I would keep it just so you can track when the update was completed. (There is of course the Update Request Log on the right panel that tracks this, but it's not in the grid of the sheet.)
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Answers
-
Hi @kebern
This looks good to me!
You potentially don't need the third workflow, to record the date, since you have the "update field" being blank as a criteria in your recurring workflow. However I would keep it just so you can track when the update was completed. (There is of course the Update Request Log on the right panel that tracks this, but it's not in the grid of the sheet.)
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives