I am creating a timesheet database where employees can input time they spend on each project everyday. I use a portal and each row is actually data from another table called timesheet element.

proj. Mon. Tue. Wed. Thur. Fri. Proj. Total

A 20 30 20 200 20 350

B 100 100 10

C 200

Day Total

Proj. Total is a calculation field in timesheet element. It recalculate every time I click away from a cell so it always shows the updated number of time spent on a specific project, which is what I want.

Day total is a summary field from timesheet element and it does not work as I wanted. My questions are;

1. If I type a number and then click away from the portal, the summary field will show but I want it to update the number if I click another cell in the portal. How can I make it work?

2. If I type a number, then click another cell in the portal (nothing happened to the summary field) and then click outside the portal, the summary field seems like confused and it becomes blank. Why is this happening?

I thought it is very common to have summary field so people can find the total of something from a portal but I couldn’t find anything from the forum. Your help is greatly appreciated.

It can only update after the record is committed.

Also unless you modify a field on which the summary is based off of you will require a refresh as it needs something to make it recalc.

Edited December 2, 200817 yr by Guest
added more

Another option for you is create an unstored calc in the parent table that references the child records.

Sum ( Child::Amount )

Thank you for your quick help. Is there anyway I can run a script based on mouse click away from the cell? I assume I have to make a script to recalculate the total?

Thanks.

Currently Not without a plugin.