How do I use today's date in a calculated field?
I have two fields: "Next Follow Up Date" and "Days to Next Follow Up". I want the "Days to Next Follow Up" to be the formula "Today" - "Next Follow Up Date". How do I do this?
I am able to do this using JS but it only executes when I edit the record. I need the "Days to Next Follow Up" to be real time so my graph is always up to date and shows how many tasks are due in X # of days.
Hello @DebraMalkus
Since your records won't update automatically, you would need to use a third-party service like Zapier that can trigger scripts on schedule. You'd create a script to update all your records externally and set up Zapier to periodically trigger this script. Zapier offers a "Schedule by Zapier" trigger where you can specify when to trigger actions such as running JavaScript—options include daily, hourly, monthly, and weekly schedules. Plus, Zapier offers free plans with limited functionality, making it a good option to explore.
Thanks Chris. What I was really asking: is there any way to include "today's date" in the formula of a calculated field? For example: with Visual Basic, I can use the function Date() in formulas where Date() equals the current date. To get "Days to Next Follow Up Date", the formula would be Date() - [Next Follow Up Date].
Hello @DebraMalkus
Kintone doesn't natively support displaying today's date, but you can achieve this with JavaScript to input today's date into a formula (I believe you've already done this, right? If not, here's a guide page). However, even with a today's function, the date and calculations won't update in real-time unless you manually re-save the records daily. Thus, you'll need a trigger from outside to automatically update or re-save records every day.
Thanks @Chris That's what I was thinking your answer would be. I'll look into your suggestion to use Schedule by Zapier.