Update different Fields based on Virtual field value

[DesiLogi]

In a Single Record Update form I'm trying to update different fields based on the value of a Virtual field. The Virtual field is loading with and External Parameter (number value).

Depending on what value that Parameter is I need a specific field to update/change on when the 'Update' button is clicked. I don't want all fields to update, just a single specific field based on the value of the Virtual field. 

For example:

If Virtual1= 3 then update myField1="mytext"

If Virtual1=4 then update myField2="mytext"

If Virtual1=5 then update myField3="mytext"

Here's some code I'm working with but can't seem to get it right. It's in the footer of the Single Record Update form. 

<script>
function changeVal() {

var v_product = document.getElementByID("EditRecordcbParamVirtual1").value;

if(v_product=="3")
{
document.getElementById('EditRecordmyField1').value = "Not Activated"
}
else if (v_product=="4"){
document.getElementById('EditRecordmyField2').value = "Not Activated"
}
else if (v_product=="5"){
document.getElementById('EditRecordmyField3').value = "Not Activated"
}
document.getElementById('caspioform').onsubmit = changeVal;
</script>

I tried this without the 'else if' part (for just the first If=3) but still couldn't get it to work. It's probably just some syntax- any help would be greatly appreciated. 

[TWIRED]

Heres a great post on passing fields from virtual fields to regular fields. Hope this helps.

 

 

 

<SCRIPT LANGUAGE="JavaScript">
function concatenate()
{
var x = document.getElementById("cbParamVirtual5").value;
document.getElementById("InsertRecordSchoolName").value = x;
}
document.getElementById("caspioform").onsubmit=concatenate;
</SCRIPT>

[DesiLogi]

Thanks- I'd found that post but I need the 'if/then' part of the issue working first. 

[DesiLogi]

I ended up using the above and some other code for if/then to get it to work. Here's the solution in case anyone else needs it:

 

<SCRIPT LANGUAGE="JavaScript">
function concatenate()
{

var productid = document.getElementById("cbParamVirtual1").value;

if (productid == 3){
var x = document.getElementById("cbParamVirtual2").value;
document.getElementById("EditRecordmyTextfield1").value = x;
}

else
if (productid == 1){
var x = document.getElementById("cbParamVirtual2").value;
document.getElementById("EditRecordmyTextfield2").value = x;
}

else
if (productid == 2){
var x = document.getElementById("cbParamVirtual2").value;
document.getElementById("EditRecordmyTextfield3").value = x;
}

else
if (productid == 4){
var x = document.getElementById("cbParamVirtual2").value;
document.getElementById("EditRecordmyTextfield4").value = x;
}

else
if (productid == 5){
var x = document.getElementById("cbParamVirtual2").value;
document.getElementById("EditRecordmyTextfield5").value = x;
}

else
if (productid == 6){
var x = document.getElementById("cbParamVirtual2").value;
document.getElementById("EditRecordmyTextfield6").value = x;
}

}

document.getElementById("caspioform").onsubmit=concatenate;
</SCRIPT>

 

[Kurumi]

You can now do this in Single Record Update Form using Calculated Value. As of February, Caspio released their new enhancements which you can find here:
https://howto.caspio.com/release-notes/caspio-bridge-17-0/

On your Calculated Value, you can use CASE WHEN for the Virtual Field itself. 

I hope this helps!