I'd like some input from someone other than my own testing and experience.
I need to touch "a record" in an object "every hour" (doesn't matter which record, first or last is fine).
In the GUI, I'm talking about doing an EDIT, then a SAVE - no field changes.
The "every hour" is easy. The query to find a record is easy. I'm just thinking maybe all I need to do is essentially three steps in the Flow:
- Query for a record
- Assign "1" to an unused Variable (X = 1)
- Write the record
To be clear, "X" is never actually used, and should cause no issues as it's a variable that gets a value and that's it.
How would you accomplish this "better" or "differently" in Flow, so that you are SURE it is COMMITTING the record even with "no changes"? I'd also be open to changing a field to "what it already equals". I believe my "testing" would simply be... does the Modify Date change after this flow runs? Agreed?
This seems insanely simple, but I don't want to be fooled into thinking I touched a record, and find out later I never was. Or, that I'm doing something inappropriate.
This has to do with a year long caching issue.
ADDED NOTE: Funny how typing out the idea to the general public makes you think more clearly.
Perhaps the solution is that I add a custom field called "Last Touched" date/time, and I stamp that every time - that guarantees it happens when I Write.