Change field value based on other fields

[Guillermo q]

Hello, Merry christmas to everyone,
I tried to write an script to change the field value based on other fields. I created an script in the form but I cant find which is the problem. Can you help me?

function Script_Precio_Y_Grupo(){

var company = record.getFieldValue(‘fld-e1c28abdd3b8451fa38b875818503bc6’);
var grupo = record.getFieldValue(‘fld-6c980123a15646a085389ac4426e07de’);
var precio

if (company==”TEST”) {

//Grupo 1

if (grupo=1) {
precio=62
}
//Grupo 2

if (grupo=2) {
precio=90
}
//Grupo 3

if (grupo=3) {O
precio=125
}

//Grupo 4

if (grupo=4) {
precio=157
}

//Grupo 5

if (grupo=5) {
precio=250
}

}

record.setFieldValue(‘fld-5b32e56f61f34bfb8e9c522f9eb9414a’, precio);

form.saveAllChanges();

}

Script_Precio_Y_Grupo();

[Daniel Leu]

As you did in the first condition check, the comparison operator is == and not =. So the code should be

if (grupo==1) {
   precio=62
}

Side note, I think you should initialize your precio variable: eg, var precio = 0.

Merry Christmas!

[Guillermo q]

Thanks for your answer.

I get an error: reference error cant find variable: record, line (null)

Any suggestions?

[Sam Moffatt]

Make sure you have a record selected before running the form script. On iOS this means you have to navigate into the record before running the script (you can’t run form scripts from the record list view, only record detail). On the other platforms, simply making sure a record is selected and displayed should be sufficient. It’s a little harder on the Mac to not have a record select but still possible.

[Guillermo q]

Thank you very much!. Im not getting the error now, but I cant get it to work, I modify the var group and price is not modified. Any suggestions?

[Guillermo q]

Ok I did it. Thank you very much.

function Script_Precio() {

var grupo = record.getFieldValue(‘fld-6c980123a15646a085389ac4426e07de’);

var precio

var company = record.getFieldValue(‘fld-e1c28abdd3b8451fa38b875818503bc6’);

if (company==”TEST”) {

//Grupo 1

if (grupo==1) {
precio=62
}

//Grupo 2

if (grupo==2) {
precio=90
}

//Grupo 3

if (grupo==3) {
precio=125
}

//Grupo 4

if (grupo==4) {
precio=157
}

//Grupo 5

if (grupo==5) {
precio=250
}

}

record.setFieldValue(‘fld-5b32e56f61f34bfb8e9c522f9eb9414a’, precio);

document.saveAllChanges();

}

Script_Precio();

[Brendan]

Hi Guillermo,

FYI, if you surround your code with the back tick character, then your code will be formatted more nicely and will be easier to read, like in Daniel’s example.

function Script_Precio() {

   var grupo = record.getFieldValue(‘fld-6c980123a15646a085389ac4426e07de’);

   var precio

   var company = record.getFieldValue(‘fld-e1c28abdd3b8451fa38b875818503bc6’);

   if (company==”TEST”) {

      // Grupo 1

      if (grupo==1) {
         precio=62
      }

      //Grupo 2

      if (grupo==2) {
         precio=90
      }

      // Grupo 3

      if (grupo==3) {
         precio=125
      }

      // Grupo 4

      if (grupo==4) {
         precio=157
      }

      // Grupo 5

      if (grupo==5) {
         precio=250
      }

   }

   record.setFieldValue(‘fld-5b32e56f61f34bfb8e9c522f9eb9414a’, precio);

   document.saveAllChanges();

}

Script_Precio();

Also, a Switch statement might be a little nicer:

function Script_Precio() {

   var grupo = record.getFieldValue('fld-6c980123a15646a085389ac4426e07de');

   var precio;

   var company = record.getFieldValue('fld-e1c28abdd3b8451fa38b875818503bc6');

   if (company == "TEST") {

      switch(grupo) {
      case 1:
         precio = 62;
         break;
      case 2:
         precio = 90;
         break;
      case 3:
         precio = 125;
         break;
      case 4:
         precio = 157;
         break;
      default:
         precio = 250;
         break;
   }

   record.setFieldValue('fld-5b32e56f61f34bfb8e9c522f9eb9414a', precio);

   document.saveAllChanges();

}

Script_Precio();

• This reply was modified 2 years, 10 months ago by Brendan.

[Guillermo q]

Thank you very much for your guidance. That switch solution is lot more elegant. In sorry i have not idea of programming.

Thanks for your time

[Brendan]

Another idea since it’s a simple lookup table would be to use an array and just use the grupo value to index into the array.

function Script_Precio() {
   var precio_lookup = [62, 90, 125, 157, 250];
   // array indexes start at 0, so subtract 1 from grupo 
   var grupo = record.getFieldValue('fld-6c980123a15646a085389ac4426e07de') - 1;
   var company = record.getFieldValue('fld-e1c28abdd3b8451fa38b875818503bc6');

   if (company == "TEST") {
      if (grupo < precio_lookup.length) {
         var precio = precio_lookup[grupo];
         record.setFieldValue('fld-5b32e56f61f34bfb8e9c522f9eb9414a', precio);
         document.saveAllChanges();
      }
   }
   return;
}

Script_Precio();

But I don’t know exactly what your data looks like. Maybe this would work for you, maybe the switch statement is better. Not sure.

• This reply was modified 2 years, 10 months ago by Brendan.

[Author]

Posts