Submitted by winter on 2010/09/05 14:41
Thanks in advance for any help.
 
What I would like to do is have the field TaskActEnd contain the current date and time when I exit the Item, whether this be by creating a new Item, switching grids, or whatever.
 
For TaskActStart it was simple to have the time entered automatically: TaskActStart=ItemCreated as an autoassign rule.
 
It's not clear to me what hoops I need to jump through to have any value, not necessarily just this one, be assigned or calculated automatically when I stop entering data in one Item and move on.
 
I have a lurking sensation that the answer is in front of my nose, but I don't see it. Any and all help greatly appreciated!
 
Regards,
Winter

Comments

 
well there's the ItemModified field.
I'm not too well up on this kind of stuff but it does seem the logical route.
I dont know how often that field is updated though, so it could be that it would be constantly updating the TaskActEnd field- anyone else know about that ?
 
EDIT:
You say:
> It's not clear to me what hoops I need to jump through to have any value, not necessarily
> just this one, be assigned or calculated automatically when I stop entering data in one Item
 
would you want something else apart from the date?
 

As Tom Said, I'd go the ItemModified route.
 
Something like :
AM:taskactend=IIF(isnull(TaskActStart),null,itemmodified)
 
... As an auto-assign rule it should work, but... I don't think it will. I haven't tested it though... I don't know if the itemmodified field is an actual "field" or an SQL request.
 
Note also that doing such a thing might slow down (a bit) all operations since any modified/created item will trigger autoassigns / row equations.
 
Maybe Pierre will have an idea.

Humm... may be you can explain to us why you want this ? Most IQ items are not tasks, so I fail to see why someone would want this... (is it solely to display it in the Gantt ?)
 

winter

2010/09/15 14:09

Permalink

I wanted to use it in time tracking. 
 
I don't use Gantt charts at this time.
 
My idea was to have a timer start running when I create or modify or visit an item, and stop when I leave it. Maybe there's another way to do it.
 
What I specifically wanted to avoid was having to click on anything to stop a timer. I almost ALWAYS forget to do it.
 

Armando

2010/09/15 14:59

Permalink

I guess someone could script something in VB in IQ to do that. But you could also use an independent timer to record what you're doing.
 
I used 2 un-intrusive little apps for that :
 
 

 Anuran
Versionv1.0.30
Short DescriptionA rotating, automatic-prompting personal text log.
Supported OSesAll Windows OS
Web PageAnuran
Download LinkZip file (portable)
System RequirementsWindows OS
Version HistoryChangelog
AuthorJody Holmes (Skwire)
Screencast (courtesy of mouser, thanks!)
 
Idon't use Anuran anymore as TitleLog is enough for me. It also does things that Anuran can't do (log all computer activities)
 
So my favorite : TitleLog
 
 
TitleLog is great if you spend a lot of time at your  computer and you want to track exactly what you did. Sometimes it's easy to get distracted, and titlelog will tell you what happened during that day when no work seemed to happen... :)
 
There's also ManicTime Tracker. It's a great app. But much more heavy. However, it's very polished and very well conceived.

winter

2010/09/16 11:14

Permalink

 Thank you Armando,
I will check all of them out.
Regards,
Winter