Update Field Based On Dropdown

[Compu]

Trying to get a script to work on a single record update forum to update a field based on a dropdown value and can't figure out what I'm doing wrong.

 

Status = Dropdown that is either 'Active' or 'In-Active'

HHs_Allocated = Hidden |  A number value that I need to update with HHs_Avaiable if 'Active".

HHs_Avaiable = Hidden | A set number in the database. 

 

Any help would be greatly appreciated! 

<script type="text/javascript">
function myFunction()
{
var status = document.getElementsById("EditRecordStatus")[0].value;

if (status == 'Active')
{document.getElementById("EditRecordHHs_Allocated").value = document.getElementById("EditRecordHHs_Available").value;}
else
{document.getElementById("EditRecordHHs_Allocated").value = "0";}
}
document.getElementById("caspioform").onsubmit=myFunction;
</script>

Thanks!

Compu

[Jan]

Hello Compu,

 

the line

var status = document.getElementsById("EditRecordStatus")[0].value;

contains "-s" - should be getElementById not ElementS.

And the line returns the value of the first item in the dropdown, not the value of the selected item.

You can use the following code instead of this line:

var tempvar = document.getElementById("EditRecordStatus");
var status = tempvar.options[tempvar.selectedIndex].value;

I hope it helps.

[Compu]

Hey Jan,

 

Thank you very much for your help. I used the following code but not getting anything:

<script type="text/javascript">
function myFunction()
{
var tempvar = document.getElementById("EditRecordStatus");
var status = tempvar.options[tempvar.selectedIndex].value;

if (status == 'Active')
{document.getElementById("EditRecordHHs_Allocated").value = document.getElementById("EditRecordHHs_Available").value;}
else
{document.getElementById("EditRecordHHs_Allocated").value = "0";}
}
document.getElementById("caspioform").onsubmit=myFunction;
</script>

[Compu]

Update: I have been able to get the code to work in the preview window but it does not work once deployed. I am working on a page with multiple datapages, could that have something to do with it?

 

Thanks!

[Compu]

Just a heads up to anyone else that may run into this issue. You can use a div tag in the header with an ID, close the ID in the footer, and call the div tag in the function:

document.getElementById('div_id').onsubmit=function() 

Found the answer here: http://forums.caspio.com/index.php/topic/3379-multiple-submission-form-in-a-single-web-page/?hl=%2Bmultiple+%2Bdatapage#entry10610%C2'>

 

Thanks again Jan for the help!