if i use math in grid how do i save it?

Suite and Optimus Suite 5
#1

Hello,

Im using grid pro with php dataprocessor.
And i really like it.

But how do i automaticaly save a value of a cell that was filled through math type => ro[=c3*c4]??

Is there a example anywhere?

#2

When DataProcessor send Ajax request to the server side it takes getValue() method of the cell. getValue() method of the “math” cell returns formula, not actual value.
If may change getValue() method of the “math” cell or create custom eXcell type.

#3

How do i change the getValue() method of the “math” cell?

#4

Which code you are using on server side?

Normally, if you are using math limited to the values in the same row ( as in ro[=c3*c4] ) , the dataprocessor will send data to the server side, which will include updated math value, which can be saved to DB as any normal value ( you are using ro, not math directly , so you need not change anything in getValue )

Server side code need await value in related column and process it for saving

You can try to include dhtmlxdataprocessor_debug.js and check which data was sent to server side.

Beware that data saving will occur only for rows which was recalculated on client side after some data in that row was changed by user. ( default calculated values will not be saved )

#5

i got another way to do it. Thanks!