Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Time difference formula and field update time

Topic Labels: Formulas
1204 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Herege
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello guys,

I have a field that use a simple formula to calculate the time passed (in minutes) between the created time of a record and Now that goes like this:

 

DATETIME_DIFF(
  {Created},
  NOW(),
  'minutes') * -1
 
The time displayed in minutes on the field does not update every minute.
If can go from 1 minute, to 5 and then to 8 or 9.
 
My question is:
How can I have this field value update by the minute of even in seconds if the formula shows the time in second?
 
Hope I explain my self correctly 🙂
 
Thanks in advanced
2 Replies 2

I don't believe it is possible. 

From the NOW() documentation in the "Formula Playground"

"While similar to the TODAY() function, NOW() returns the current date AND time. This function updates when the formula is recalculated, when a base is loaded, or otherwise roughly every 15 minutes when a base is open. If the base is closed, it will update approximately every hour only when the base has time-dependent automation triggers or actions, or sync dependencies."

Herege
5 - Automation Enthusiast
5 - Automation Enthusiast

Yes, probably you're right.

Anyeay, thanks for the reply 😊