Forum Discussion

AlexFreeman's avatar
AlexFreeman
Qrew Trainee
5 years ago

Calculate Future Date and Actions

I am looking to set up a form to calculate a future date based on a completed date field + 30 days and then show a box or possibly trigger a notification when it reaches that date.

The form I have is set up this way.

User completes the form and it's saved as [Resolution Completed Date]. I need to calculate 30 days past this date and then show a box or trigger the notification when it reaches that date. Is this possible?

------------------------------
Alex Freeman
------------------------------
  • np, create a formula date field called 
    30 day Reminder Date

    with a formula

    [Resolution Completed Date] + Days(30)

    Then you can make a report of where Today >= [30 day Reminder Date]

    You will also need to have a completed checkbox or status field to filter the report or else this report will grow infinitely.

    You can set up up a Subscription to that report to receive it on a scheduled daily or weekly frequency.






    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • AlexFreeman's avatar
      AlexFreeman
      Qrew Trainee
      Thanks! That helped!

      ------------------------------
      Alex Freeman
      ------------------------------