Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
JBudler

Member
Registered:
Posts: 17
Reply with quote  #1 
Hey Folks,

I am pretty much a new guy on this block and find life still a little confusing when working with data in grids.

Does anyone have advice on how I can calculate values in grid rows?

Say we have a grid with items, costs and quantities and we then want to know the line total for that row, obviously it is dependent on the values in costs and quantities. I see on cell entry and exit options and would imagine placing a script in the exit of the itemprice cell would enable me to calculate the value but am unsure as to how to grab and set the data for the relevant row.

Thank you for your advice and lending me your experience :)

Jacques

__________________
Regards,
Jacques
0
BMellert

Guru
Registered:
Posts: 688
Reply with quote  #2 
You would need to do on the cell exit as you mention.  Then you'd have to create a client script which reads the applicable cells (getCell) in the grid, do your calculation, and push (setCell) results into a new cell in your grid (you will also need to use getCurrentRow ... and maybe getCurrentCol functions as well if you want to fire only on certain cells).  These functions are available in the help under Grid Functions.
0
JBudler

Member
Registered:
Posts: 17
Reply with quote  #3 
Thank you, I will look into that help section now, thanks for the feedback.
__________________
Regards,
Jacques
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!