Display Maximum Value Between 2 Fields

[riaz_mansuri]

Hi,

I am trying to create a script where the field displays the maximum value of 2 fields. So for example in Excel we would put in something like =MAX(D3:E3).

So in the below example Impact (Monetary) and Impact (Reputation) are both drop downs with a value of 1 - 5.

Impact max should display the maximum value (in the below case 5)

Any help would be much appreciated.

Thanks

[Ken83]

I think you can accomplish this in an onChange script utilizing the Javascript Math.max() method. Just pass in or comma separate the numbers you need to compare and that method will return the highest number among them.

Example: var highest = Math.max(5,3,21,8); // The highest variable is going to equal 21

[riaz_mansuri]

Thanks Kenneth,

But where do I add the 2 fields I want to base this on?

Thanks

Riaz

[Ken83]

Using the script that Pradeep Sharma provided...

var a =   g_form.getValue('u_impact_monetary');

var b = g_form.getValue('u_impact_reputation');

var c = Math.max(a, b);

g_form.setValue('u_impact_max',c);

The text "g_form.getValue()" is what you use to actually get the value of a field on your form. In between the parenthesis, you need to put in the name of the field as the first value. You can find that on the page where you edit the form, in the list of variables. The second value that goes in the parenthesis is the value that you want to set in that field. So the text he provided will look something like this(once you put the correct field names in). g_form.setValue('u_impact_max', c);

The first 2 lines are actually getting the values from the other 2 fields on the form...hope that makes sense. The 2 fields that you want to base this on, you need to create variables on the form for those unless you already have fields on the form that you want to use.

[Pradeep Sharma]

Hi Riaz,

You can create a client script.Here you go.

var a =   g_form.getValue('fiedl1');

var b = g_form.getValue('field2');

var c = Math.max(a, b);

g_form.setValue('field3',c);

Replace the variable naming conventions and make sure you replace the fields with the exact column name