Calculate Future Date and Actions

Question

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
------------------------------

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community