Was Form Updated Today?
hi... i have a form where everyday I need a status update on a multiple facility names. Is there a formula to determine which facility name did not receive an update today, based on modified date?
Answers
-
Hey @Joan B
Many changes, sometime inadvertent, will affect the modified date which makes the mod date a tricky field to use reliably. A more robust approach would be to add a helper date column and use the Record Date automation to record the date automatically when the status column changes (or whatever column is being updated daily). You could then have a second automation that runs once a day after the updates should come in, and looks for dates that do not equal TODAY to send you the notification.
I'm happy to help you build the automated workflows if the above is of interest. They are both very straight-forward to add if you haven't used them before.
Kelly
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives