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
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
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
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 142 Industry Talk
- 473 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives