JS If/Then to Dynamically Copy Value

[kpcollier]

I have 10 text field dropdowns (Material1 - Material10) that correspond with 20 other text field dropdowns (Labor1 - Labor20). 

For each Material, there will need to be 2 corresponding Labor fields. In example, if I choose Aluminum for Material 1, I need to have Labor 1 and Labor 2 be set to Aluminum as well. If Material 2 was glass, I would need Labor 3 and Labor 4 to be set to Glass.

If this can be done without JS, I'm open for it. I can't seem to find a way to set a Value through Rules. I'm not quite skilled enough to get an if/then function going myself. If anyone could get me going in the right direction, I would appreciate it!

[kpcollier]

To add to it - I would use Cascading Dropdowns or Text Field for this, however this limits me to just the single value that matches. I need to be able to have the ability to change it still, even if there is a match.

[rguardiola1]

I'm in the same situation. I need the ability for an If/Then/Else for a calculated field. For example: If a field value if greater than or equal to 0, add these two fields, ELSE don't do a calculation.

Any ideas are welcome.

Thx,

Ruben

[DefinitelyNot31337]

Hello kpcollier,

 

I'm not sure if I'm missing something but if you want to be able to change the value of a Cascaded Text Field, you can leave the "Make field non-editable..." unchecked.

 

Hope this helps,

DN31337

[MayMusic]

On 7/5/2019 at 5:45 AM, rguardiola1 said:

I'm in the same situation. I need the ability for an If/Then/Else for a calculated field. For example: If a field value if greater than or equal to 0, add these two fields, ELSE don't do a calculation.

Any ideas are welcome.

Thx,

Ruben

You need to use SQL syntax for instance

 

CASE

WHEN ....

THEN ...

WHEN ...

THEN ...

ELSE ...

END

 

[kpcollier]

I got it figured out with JavaScript. I appreciate your guys' help, it was a hard question to understand.

var mat1= document.getElementsByName('InsertRecordMat_1')[0];
var mat2= document.getElementsByName('InsertRecordMat_2')[0];

var lab1= document.getElementById('InsertRecordLabor1');
var lab2= document.getElementById('InsertRecordLabor2');

var phase1= document.getElementById('InsertRecordLabor1_Phase');
var phase2= document.getElementById('InsertRecordLabor2_Phase');

mat1.onchange = function (){

lab1.options[lab1.selectedIndex].value = mat1.value;
lab1.options[lab1.selectedIndex].text= mat1.value;
lab2.options[lab2.selectedIndex].value = mat1.value;
lab2.options[lab2.selectedIndex].text = mat1.value;
  
phase1.options[phase1.selectedIndex].value = 'Fab';
phase1.options[phase1.selectedIndex].text = 'Fab';
phase2.options[phase2.selectedIndex].value = 'Install';
phase2.options[phase2.selectedIndex].text = 'Install';

};

 

[kpcollier]

On 7/5/2019 at 5:45 AM, rguardiola1 said:

I'm in the same situation. I need the ability for an If/Then/Else for a calculated field. For example: If a field value if greater than or equal to 0, add these two fields, ELSE don't do a calculation.

Any ideas are welcome.

Thx,

Ruben

I'm working on switching my functions to if/thens as well. Trying to hide elements if the one previous is blank. If I figure it out, I'll update this post.