Client side conditional calculation in a grid

[jcarrallo]

Hi,

Can anyone help me with the following:

This is a grid with 4 fields - based on a SQL table.

Posible field values are:
field1= 'A' or 'B'
field2 = from 1 to 1000
field3= from 1 to 1000
field4 = conditional result

My question is how to calculate field4. The results required are:
if field1='A' then field4=field2*field3
if field1='B' then field4 = allow the user to enter the content of the field manually

Can I do this?

Thanks,
Javier

[Michael1954]

Re: Client side conditional calculation in a grid

If there are only 2 possible values you can check for A. There is a calculated field control.

Calc Field.png

In my example I say if field1 is "A"
then Field2xfield3 else 0

I hope this helps

Michael

[jcarrallo]

Re: Client side conditional calculation in a grid

Thanks Michael.
Sorry but perhaps it was not clear what I�m looking for.
What I would like to get is either the calculation or the possibility for the user to manually enter a value in field 4. If I use your suggestion the result is either the calculation or 0.
Any ideas?
Cheers,
Javier

[Michael1954]

Re: Client side conditional calculation in a grid

Hi Javier

Can you explain the process. I think you need to "trap" this at point of data entry. How is the person updating the record?
Can it be done via a UX component.

Michael

[Michael1954]

Re: Client side conditional calculation in a grid

In field On Change event of field1

var d = {grid.Object}.getValue('G','FIELD1',-1);

if (d == "B")

{

alert(" Please fill in field4");

}

Michael

[jcarrallo]

Re: Client side conditional calculation in a grid

Hi,
The image below shows the grid layout. The "tipo" column dictates the type of transaction to be included.
When you buy a stock, then the total trade is = "Cantidad" * "Precio" and this info goes under the column "PTRLOCALAMT"
But when the "tipo" is a dividend or "DV+", then the user should leave "Cantidad" and "Precio" at 0, and include a value in "PTRLOCALAMT" which is = to the dividend received. In this case, the calculation "Cantidad" * "Precio" in the "PTRLOCALAMT" column should not be active to allow the user entering the dividend.

I will try your sugestion from the previous post and comment on it. Thanks!

Captura.JPG

[Michael1954]

Re: Client side conditional calculation in a grid

Remember you can enable and disable controls.

The javascript I returned if the easiest way to fill in "A" or remind on "B".

For more complex logic flows you could call a dialog as the data entry form and then show hide sections.

Michael

[GGandhi]

Re: Client side conditional calculation in a grid

you should be able to do this with inline Javascript via onChange event than the calculated expression, I am sure.
on top my head, not testing, this is what should be on the javascript.

var rowNum = {grid.rowNumber};
var tipo = {grid.object}.getValue('G','TIPO',rowNum);
var cantidad = {grid.object}.getValue('G','CANTIDAD',rowNum);
var precio = {grid.object}.getValue('G','PRECIO',rowNum);
if (tipo == "BUY") {
var pirLocalAmt = cantidad * precio;
{grid.object}.setValue('G','PIRLOCALAMT',rowNum,pirLocalAmt);
}

I can test it and show if you are not able to check this.

edit:
tested and is good
take a look at this:
http://screencast.com/t/MJ2Q94MvX

[Michael1954]

Re: Client side conditional calculation in a grid

Gandhi/Javier

I think the field needs to be set to a label; update it automatically as Gandhi suggests, but pop up a UX with help for other options. That way Gandhi's calculation cannot be overwritten. The user has to have access in the other 2 situations.

Michael

[Michael1954]

Re: Client side conditional calculation in a grid

Looking at it again you are better to popup a ux on change of tipo
That way you can show hide the fields you want to use.

One option is to show "Cantidad" and "Precio" when Tipo = Buy
option 2 is not to show "Cantidad" and "Precio" but rather to get the user to input "PTRLOCALAMT"

This way the user always expect a dialog but the fields "Change" based upon the drop down.

Michael

[Michael1954]

Re: Client side conditional calculation in a grid

Sorry but if you prefer you can enable disable the fields in your grid based upon tipo.

[drgarytraub]

Re: Client side conditional calculation in a grid

You can have 2 field4", call them field4_a and field4_b.

1. Show/hide these based on the value from field1.
2. click the hide column or hide row checkbox for field4_b
3. use the free form layout of field4_a - put both field4_a and field_b in there side by side
4. now defijbe the 2 field4's the way you described, the first will be calculated, teh second will be user editable
oila!

[Michael1954]

Re: Client side conditional calculation in a grid

Gary that works great but he also needs to do the same to field 5,2,3.

The logic dictates buy or sell value I think.

Michael

[GGandhi]

Re: Client side conditional calculation in a grid

my view is the grid should not used to enter data, only to view the data
the data should be entered via a dialog or ux whatever the current name is. then the read only grid is updated.
the calculations need not be shown to the user at all so they won't be able to change play with that.
any adjustment should again take place via another entry.
in an accounting world the time marches on, never can go back and erase the past. keep the audit trail easy.
(incidentally this is what I said in the screencast, I showed the example to answer the question he posted)

[jcarrallo]

Re: Client side conditional calculation in a grid

Hi Guys,
Many thanks for your contributions. Unfortuntely I have to wait until the weekend to test all these ideas. But I really appreciate your help.
Thanks gain.
All the best,
Javier