Skip to main content
Question

Counting Date/time field changes

  • January 10, 2020
  • 0 replies
  • 128 views

Is it possible to create a formula that will keep a running count of how often a date and time field changes?  I make daily uploads tracking hardware login information and I am attempting to track a fields times its updated.  I found an old formula that will supposedly track a text field change ( I will post bellow) but the text field may not change for some of my users.  In addition this formula does not seem to actually increase in values.

var text value = [Last Login User];

Count(
Part($value,1,"]"),
Part($value,2,"]"),
Part($value,3,"]"),
Part($value,4,"]"),
Part($value,5,"]"),
Part($value,6,"]"),
Part($value,7,"]"),
Part($value,8,"]"),
Part($value,9,"]"),
Part($value,10,"]"),
Part($value,11,"]"),
Part($value,12,"]"),
)



------------------------------
Chris Dobberfuhl
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Are you importing into a text field that has logging enabled?  What does your data look like in  [Last Login User]

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------