Was Form Updated Today?

Options

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

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    edited 05/16/23
    Options

    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