Dexterity Calculated Field In Scrolling Window

(0) Share

Report

Posted on by Community Member

I'm trying to create a window using Dexterity to more conveniently pull together garnishment data. I created a simple window with a scrolling window to pull all garnishments for a given employee. It works great however the table that shows garnishment data only keeps the original amount and the amount paid not the remaining balance. I'm trying to create a field in the scrolling window that will calculate remaining balance. I wrote the script to fill the window and it compiles, but the remaining balance field won't calculate. Currently I have tried putting the script in both the Pre and Post window script section with no luck. Any thoughts? Is this even possible?

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Tim W 2,925 on at

Like (0)

Report

You have to put it in the fill script of the scrolling window and though you are setting the value of a field in the scrolling window you need to use the table values as the source for the calculation.

** Scrolling window fill script**

set 'Remaining Balance' of window <your scrolling window> of form <your form holding the window> to 'Original Amount Field' of table <your table> - 'Amount Paid Field' of table <your table>;

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you very much. I was missing the set part. It worked with that.

Was this reply helpful? Yes No
Suggested answer

David Musgrave MVP ... 14,095 Most Valuable Professional on at

Like (0)

Report

Hi

Tim is correct.

You can use the set x to y syntax or x = y syntax. It does not make a difference.

The issue is that the Fill script runs before the window fields are populated so you must work with the table fields.

David

Was this reply helpful? Yes No