Change field value based on other fields

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, 12 months ago by 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, 12 months ago by Brendan.