Update Field Using Conditions

[ccocker]

Hi guys,

 

I am new to Caspio looking to migrate an application I built in MS Access.  So I am used to writing VBA procedures and functions.

 

I am trying to work out how to update one field based on multiple criteria based on user input.

 

For example I have an Issues form with three fields Probability, Severity and Rating.  Rating I would like to be updated automatically based on the input of the Probability and Severity Field.  i.e. Low Probability and Medium Severity would result in a Rating of Low, where as High Probability and High Severity would result in a Rating of Critical.

 

I would like the field Rating to be physically updated in the table so whenever I write reports or extract the data I have the Rating field.

 

I cannot see anyway to do it on a Form and I have tried looking at reports with calculated fields etc. But alas I am lost.

 

Is there an easy way to do this or is this something I need to look at customising with Java Script.

[MayMusic]

It is not a standard feature but should be possible by JS. What is the DataPage type? Submission or update? Are Probability and Severity Field text fields? Or they are dropdown?

 

You need to have something like:

<script>
function rate(){

if (document.getElementById('Probability ID').value == 'Low' && document.getElementById('SeverityID').value == 'Medium'){
document.getElementById('RATE').value = 'Low';
} else if (document.getElementById('Probability ID').value == 'High' && document.getElementById('SeverityID').value == 'High'){}
document.getElementById('RATE').value = 'Critical';
}
document.getElementById('caspioform').onsubmit=rate;
</script>

You need to replace IDs with actual IDs and also add more condition as required.