It is currently 21 April 2025, 18:22 Advanced search

Refresh Column Total in static field

Questions and answers on how to best use Instant Developer

Refresh Column Total in static field

Postby Gaby_h » 20 August 2013, 21:27

I have a simple parent child form: Invoice and Invdetails in the lower panel. I created a column total using a static field to total Extension field in child panel. I put the script in the onChangeRow in the parent panel. The amount in the static field is not in sync with the row selected in parent, it is always 1 row late. I have to click twice in the parent row to get the associated total to appear in the control. What's the best event to use for this type of calculation?
Gaby_h
 
Posts: 888
Joined: 17 July 2013, 18:22
Location: Vancouver, Canada

Re: Refresh Column Total in static field

Postby lucabaldini » 21 August 2013, 6:54

The OnChangeRow in the parent panel is fired before the child panel updates... I would try to use the AfterFind event of the child panel... In this way you update your total after the child panel updated its content.
User avatar
lucabaldini
Pro Gamma
Pro Gamma
 
Posts: 4990
Joined: 1 October 2010, 17:03
Location: Bologna

Re: Refresh Column Total in static field

Postby Gaby_h » 21 August 2013, 15:22

Fantastic, works great. Thank you Luca
Gaby_h
 
Posts: 888
Joined: 17 July 2013, 18:22
Location: Vancouver, Canada

Re: Refresh Column Total in static field

Postby lucabaldini » 22 August 2013, 8:33

You are welcome. I'm glad it helped! :-)
User avatar
lucabaldini
Pro Gamma
Pro Gamma
 
Posts: 4990
Joined: 1 October 2010, 17:03
Location: Bologna


Return to Tips & Tricks

Who is online

Users browsing this forum: No registered users and 12 guests

cron