Hi, I could not find any docs satisfying my requirement .Can anyone help me in designing a grid as below.
User will enter values in rows for textbox1, textbox2 and textbox3. Last row should display the total of the values entered in above rows.
Discussion posts and replies are publicly visible
Following the patterns here
https://docs.appian.com/suite/help/21.3/Editable_Grid_Component.html#examples
You simply add a last row showing the required components and values.
My requirement is i have to do sum of values returned when user applies filter in non -editable grid. For example, grid has mileage column, when user applies filter then if rows are returned then i have to display sum of mileage returned from three rows.
This should be doable. Generally speaking this is a use case where you should be querying the data in advance into a local variable, then using that to populate the grid.
What have you tried already? Are you having any specific difficulties?
So the requirement is i have an interface where there are multiple filters, when user applies filters lets suppose it applies on two fields, then what ever rows are returned in non -editable grid, then i have to show the sum of one column values in some field
I was thinking of storing the value returned from a!gridField into some var (means whatever value is being returned when user applies xyz filter would be displaying in that grid and the data stored in grid can help me acheive the same, but i didnt find any parameter in a!gridField through which i can do this.
Niharika said: i have an interface where there are multiple filters, when user applies filters lets suppose it applies on two fields, then what ever rows are returned in non -editable grid, then i have to show the sum of one column
Yes, I understand, since that's pretty much what you already said before.
My same 2 questions still apply: what have you tried already, and what specific difficulties are you having (if any)?
I am thinking to use that data populated in grid and then doing that calculation but what you are saying is opposite
No, that won't be possible. You will need to use the "classic" pattern wherein you first query the data for the current page of the grid into a local variable (as a datasubset), then populate the grid using that. In this way you'd be able to manipulate the result of your query to always append a "final" row of data that contains the calculation based on the sum of the queried (filtered/etc) rows.
You mean whatever filter user applies, that i have to store into some local variable. If yes, then how to acheive that.
Thanks, i am able to acheive the output.