Assigning conditional values to dropdown selections

Hello @romanovwp,

The process is simple, but you need to create an array of javascript objects.

I’ll try to illustrate the process with an example:

Your form includes two dropdown field (fieldname1, and fieldname2) with the languages: A, B, and C respectively, and a number field (fieldname3) for entering the number of words. I will assume too that the translation cost by word is as follows:

From A to B = 0.75
From A to C = 0.85
From B to C = 0.60

I will assume that the translation cost is the same in the other direction, however, it is very simple to extend the example to use a different cost for new pairs of languages.

I will define as part of the equation an array of objects similar to:

var data = [
  {
     'from' : 'A',
     'to' : 'B',
     'cost' : 0.75
  },
  {
     'from' : 'A',
     'to' : 'C',
     'cost' : 0.85
  },
  {
     'from' : 'B',
     'to' : 'C',
     'cost' : 0.60
  }
];

now the equation would be:

(function(){
    var data = [
      {
         'from' : 'A',
         'to' : 'B',
         'cost' : 0.75
      },
      {
         'from' : 'A',
         'to' : 'C',
         'cost' : 0.85
      },
      {
         'from' : 'B',
         'to' : 'C',
         'cost' : 0.60
      }
    ];

    for(var i in data)
    {
        if((data[i]['from'] == fieldname1 && data[i]['to'] == fieldname2) || 
           (data[i]['from'] == fieldname2 && data[i]['to'] == fieldname1)
        )
        {
           return data[i]['cost']*fieldname3;
        }
    }
    return 'It is not required a translation';
})()

I’m sorry, but the support service does not cover the implementation of the users’ projects (forms or formulas). If you need additional support implementing your equations, I can offer you a custom coding service through my personal website:

https://cff.dwbooster.com/customization

Best regards.