Platform
Learn
Community
Support
Partner Center
Sign up
or
Log in
logout
Account Settings
Profile
messages
Messages
logout
Logout
Platform
Home
Downloads
IPP
Licensing
Project Sizing
Learn
Training
Documentation
Evaluation Guide
What's New
Community
Home
Forums
Forge
Ideas
Members
Support
Partner Guide
Resources Library
Opportunities
Account Management
Sign up
or
Log in
Home
Forums
Forge
Ideas
Members
Dear ,
What would improve your OutSystems Community experience? Let us know by taking this 2-minute survey.
Pick up the survey
Community
›
Forums
›
Technology & Integration
Summing an editable table column and updating the value as they change
Community
›
Forums
›
Technology & Integration
Summing an editable table column and updating the value as they change
New Post
New Post
Michael Swan
Posted on 2015-01-19
Michael Swan
Rank: #3312
Posted on 2015-01-19
Hi,
How would you sum a column and put it in the "total project cost" as shown in the example below?
Also, as users change the data in the edit table, it'd be great to update the total.
The project costs are "grouped by" projectId.
I would create an aggregate, but the aggreate probably would need updating inside the "on row update" and " on delete" and would also need to be in the preparation of this web form. Note sure how to do that. Is there a generic "OnTableupdate", to recalculate the total?
André Vieira
Posted on 2015-01-21
André Vieira
Rank: #1
Posted on 2015-01-21
Solution
Hi Michael,
There's no OnTableUpdate but you can use the on row update and on row delete to update the total.
I think that you are on the right track. Having an aggregate that you refresh once you update or delete and showing that value (and refreshing it on screen).
So you would have the aggregate on the preparation and use Refresh Data on the actions of On Row Update and On Row Delete.
Cheers
Solution
Quick Reply
attachment
Choose File
No file chosen
Submit
Login to reply
New Post
Available Forums
Technology & Integration
News and Announcements
Forge Discussions
Meta
Community Quick Guides
Usability
Installation Troubleshooting
Personal Environment Troubleshooting
Forum Notifications
Email Digest Settings
Loading...