0

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.

Thanks.


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.

Thoughts?

2
  • do you want to automate the changes in every hour without user interaction? – Santanu Boral Jul 5 '17 at 18:27
  • Technically there is (no need) for a change, per se. I just need to touch the record. Stamping a field no one cares about seems like the simplest method to be SURE it REALLY IS touching the record (per the added comment at the end of the Question). I think it's a no-brainer when you look at it that way. Just TOUCH A RECORD... set an unneeded datetime field to NOW()............. (haven't put this into practice yet for the cache-problem it's going to help solve)... – AMM Jul 7 '17 at 19:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.