I know the now() function updates to the current time, not the time the checkbox was selected/changed in the record. Thanks!
If([Ready for Upload?] = not null, ToDate([Date Modified]))
This will parse out the date and time for use in a date/time formula field.
var text DateAndTime = Left(Right([append only with date /time],"["),18);
var date TheDate = ToDate(Left($DateAndTime," "));
var timeofday TheTime = ToTimeOfDay(NotLeft($DateAndTime,9));
ToTimestamp ($TheDate, $TheTime)
This formula will parse out the actual update, such as changing a status to "Approved"
Trim(Right([my update field]),"]"))
This formula will parse out who did the approval
Trim(NotLeft(Left(Right([my update field],"["),"]"),18)
You will need to be sure that the Log Changes field is set to log the time as well as the date and that the new entries are at the bottom.
Just so I understand, I would have a field that I want to track ("my update field") with logging enabled, and then per your recommendation I would have 3 formula fields to summarize information on the [my update field]: Date & Time, What the update was (e.g., "approved") and Who did it. Is this correct?
And would log changes be active for each of these 3 formula fields too?
var text URLONE = URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_17="Approved";
var text URLTWO = URLRoot() & "db/" & Dbid () & "?a=dr&rid=" & [Record ID#];
& "&rdr=" & URLEncode($URLTWO)
Hi, I think this is the sollutin I'm looking for in my project. Though being relative new and unexperrenced I don't get it working.
Would there by any change be as example databse project where this is used so I can analyse that example, learn it and than copy it into my own project?
I'm getting an error on this piece of code in the first VAR declaratin "[append only with date /time]". Not sure with what to replace this section