satting field values based on value of another

[bobby123]

Hi Forum

I want to set the value of 3 fields based on the value of another i.e

If Field1.value =�bad�
Field2.value = 9
Field2.value = 10
Field2.value = 11

If Field1.value = �good�
Field2.value = 12
Field2.value = 13
Field2.value = 14

Can this be done in the cliet side grid object or does it need xbasic

Thanks for the help

Robert

[MarionT]

Re: satting field values based on value of another

are you using a grid or a dialog?

have you looked at the client side expression?
eg for Field2.value

if (Field1.value = "bad",9,12)

Oh - why do you have Field2 3 times? if Field1 = "Bad" do you want Field2 to be 9, 10 or 11???

[bobby123]

Re: satting field values based on value of another

Sorry Marion

it was a bit late when i entered the note and it, should have read

If Field1.value =”bad”
Field2.value = 9
Field3.value = 10
Field4.value = 11

If Field1.value = “good”
Field2.value = 12
Field3.value = 13
Field4.value = 14

and i am using a grid

Thanks
Robert

[kingcarol]

Re: satting field values based on value of another

I'm a javascript novice, and I'm in a hurry this morning, but I think this might help give you some pieces to work with... (untested... I THINK it's single quotes around 'bad'.. ). I'm assuming you might want to use OnChange event of FIELD1 and inline javascript. And I'm also assuming there are only 2 choices (bad or good)

var f1 = grid.Object.getValue('G','FIELD1',{grid.rowNumber});
if(f1 == 'bad') {
	grid.Object.setValue('G','FIELD2',{grid.rowNumber},9);
             grid.Object.setValue('G','FIELD3',{grid.rowNumber},10);
             grid.Object.setValue('G','FIELD4',{grid.rowNumber},11);
} else {
	grid.Object.setValue('G','FIELD2',{grid.rowNumber},12);
             grid.Object.setValue('G','FIELD3',{grid.rowNumber},13);
             grid.Object.setValue('G','FIELD4',{grid.rowNumber},14);

}

[bobby123]

Re: satting field values based on value of another

Thanks Carol

On the "And I'm also assuming there are only 2 choices (bad or good)" I take it if there are more than 2 choices this would require usome kind of elseif statement, either way you have given me the pointers i need to get working on it.

Thanks again
Robert

[kingcarol]

Re: satting field values based on value of another

Robert, you're right about the else if if more than 2 choices. Although, I'm so clunky at javascript, I might just make several separate if statements without the else stuff. Probably bad advice from a novice, though.

[WindForce]

Re: satting field values based on value of another

For multiple cases it would be more elegant to use switch like in

switch(n)
{
case 1:
  execute code block 1
  break;
case 2:
  execute code block 2
  break;
default:
  code to be executed if n is different from case 1 and 2
}

[Davidk]

Re: satting field values based on value of another

If you have a lot of choices to get through, have a look at the Javascript Switch statement, http://www.w3schools.com/js/js_switch.asp

Edit: Hit 'post' too late... Jaime hit it.

[bobby123]

Re: satting field values based on value of another

Thanks Carol

Your not as much a javascript novice as i am. but i am planning to read up in the next month or so when i have a bit more time.

Jamie, David, thank's all useful stuff which will get me going with this.

Thanks Again
Robert