Trigger financial calculation on select change

17 New Member

I am trying to get the financial calculation on this to trigger whenever there is a change to select1. Right now, the user has to click on select2 to trigger the changes.

Ideally, a change of select1

1. trigger the population of select2 (and set it initially to 0)
2. make the text fields disappear
3. trigger the financial calculation to reflect the select1 choice.

Any help would be greatly appeciated !

Greg

Expand|Select|Wrap|Line Numbers

  
<SCRIPT language="JavaScript"> 

    var Opt2;

     var Opt1;
 
    function addfields() {

         var category = parseInt(document.getElementById("category").value);

         var family = parseInt(document.getElementById("family").value);

         document.getElementById("textfield").value=category+family;

         document.getElementById("textfield2").value=category+family;
 
         var value = category + family; 

         document.form1.textfield.value = isNaN(value) ? '' : value;

         document.form1.textfield2.value = isNaN(value) ? '' : value;

     }
 
 function PopulateSelect2(){

     Opt1=document.form1.category;

    Opt2=document.form1.family;

    Opt2.options.length=0;

    Opt2.options[Opt2.options.length]=new Option("0", 0);
 
    switch(Opt1.selectedIndex)

    {

        case 1:

              Opt2.options[Opt2.options.length]=new Option("1", 40);

            Opt2.options[Opt2.options.length]=new Option("2", 80);

            Opt2.options[Opt2.options.length]=new Option("3", 120);

            break;   

        case 2:

            Opt2.options[Opt2.options.length]=new Option("1", 40); break; 

        case 3:

            break;

        case 4:

            Opt2.options[Opt2.options.length]=new Option("1", 40);

            Opt2.options[Opt2.options.length]=new Option("2", 80);

            Opt2.options[Opt2.options.length]=new Option("3", 120);

            break;

        }

    }
 
    function React2Select2()

    {

        var value;
 
        Opt2=document.form1.family;

        document.getElementById('F1').style.display="none";

        document.getElementById('F2').style.display="none";

        document.getElementById('F3').style.display="none";

        document.getElementById('Ft1').style.display="none";

        document.getElementById('Ft2').style.display="none";

        document.getElementById('Ft3').style.display="none";

        switch(Opt2.selectedIndex)

        {

            case 1:

                document.getElementById('F1').style.display="block";

                document.getElementById('Ft1').style.display="block";

                break;   

            case 2:

                document.getElementById('F1').style.display="block";

                document.getElementById('F2').style.display="block";

                document.getElementById('Ft1').style.display="block";

                document.getElementById('Ft2').style.display="block";

                break;

            case 3:

                document.getElementById('F1').style.display="block";

                document.getElementById('F2').style.display="block";

                document.getElementById('F3').style.display="block";

                document.getElementById('Ft1').style.display="block";

                document.getElementById('Ft2').style.display="block";

                document.getElementById('Ft3').style.display="block";

                break;

        }
 
        value=parseFloat(document.form1.family.value) + parseFloat(document.form1.category.value);

        document.form1.textfield.value = isNaN(value) ? '' : value;

         document.form1.textfield2.value = isNaN(value) ? '' : value;

    }    
 
</SCRIPT>

Expand|Select|Wrap|Line Numbers

 
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

<title>Untitled Document</title>

<style type="text/css">

<!--

.style1 {color: #FF0000}

.style3 {color: #FF0000; font-size: small; }

.style4 {font-size: 12px}

.style5 {font-size: 18px}

-->

</style>

</head>
 
<body>

<form id="form1" name="form1" method="post" action="">

  <table width="700" border="1">

    <tr>

      <td><div align="right">Category</div></td>

      <td><select name="category" id="category"  onchange="PopulateSelect2()" >

        <option>Select a Category</option>

        <option value="85">OMEA Member</option>

        <option value="25">OCMEA Member</option>

        <option value="45">Saturday Only</option>

        <option value="200">Non Member</option>

      </select></td>

      <td>&nbsp;</td>

    </tr>

    <tr>

      <td><div align="right">Family Attending</div></td>

      <td>

      <select name="family" id="family" onchange="React2Select2();" onclick="React2Select2();">

    </select>

      </td>

      <td>&nbsp;</td>

    </tr>

    <tr>

      <td><div align="right">Total Fees</div></td>

      <td bgcolor="#FFFFFF"><span class="style3"> $</span>

        <input name="textfield" type="text" disabled="disabled" class="style1" id="textfield" /></td>

      <td>&nbsp;</td>

    </tr>

    <tr>

      <td valign="top">

          <div align="right" id="F1" style="display:none;" >Family Member1</span></div>
 
            <div align="right" id="F2" style="display:none;">Family Member2</span></div>
 
          <div align="right" id="F3" style="display:none;">Family Member3</span></div>

&nbsp;     </td>

      <td bgcolor="#FFFFFF">

          <div id="Ft1" style="display:none;"><input name="Family1" type="text" id="Family1" /></div>
 
            <div id="Ft2" style="display:none;"><input name="Family2" type="text" id="Family2" /></div>
 
          <div id="Ft3" style="display:none;"><input name="Family3" type="text" id="Family3" /></div>

          &nbsp;

      </td>

      <td>&nbsp;</td>

    </tr>

    <tr>

      <td>&nbsp;</td>

      <td bgcolor="#FFFFFF"><input type="text" name="textfield2" id="textfield2" DISABLED /></td>

      <td>&nbsp;</td>

    </tr>

  </table>

  <p>&nbsp;</p>

</form>

</body>

</html>

Sep 8 '07 #1

Subscribe Reply

2408

gregincolumbus

New Member

Anyone able to help me on this? Please?

Thanks

Greg

Sep 8 '07 #2

pbmods

5,821

Recognized Expert Expert

Heya, Greg.

First off:

[CODE=javascript]
JavaScript code goes here.
[/CODE]

and

[CODE=html]
HTML code goes here.
[/CODE]

and so on.

To answer your question, can you add the function call to the onchange attribute for your select element?

Sep 8 '07 #3

gregincolumbus

New Member

Hi

Thanks for the response..sorry about the code tags...thought I was doing it right....will do better next time :)

I am a newbie to javascript. The code I sent was written by somebody else who I paid a small deposit to write it but he never finished it completely. I was supposed to pay the balance when the work was completed.

I have tried contacting him but have gotten no response...so I am trying to get this thing finished and out the door..I am on a tight timeline for a project I volunteered to do.

How do I add the function call to the onchange attribute?

Sorry for all the newbie questions.

Thanks

Greg

Sep 8 '07 #4

pbmods

5,821

Recognized Expert Expert

Heya, Greg.

Oh goodie.

Alrightey. On this line here:

Expand|Select|Wrap|Line Numbers

<td><select name="category" id="category" onchange="PopulateSelect2()" >

you're setting the onchange handler to 'PopulateSelect2()'. In other words, when the selected value changes, the browser will automatically call PopulateSelect2().

All you need to do from here is create the function that does all the stuff you need it to and add it to the event handler, e.g.:

Expand|Select|Wrap|Line Numbers

 
<td><select name="category" id="category"  onchange="PopulateSelect2(); RunFinancialCalculations();" >

That should get you started; we'll go from there :)

Sep 8 '07 #5

Similar topics

3432

Trigger failing after table structure change

by: Dave C. | last post by:

Hello, I have created the following trigger: CREATE TRIGGER tr_UDFTest ON UserDefinedFields FOR INSERT, UPDATE AS DECLARE @foobar varchar(100) SELECT @foobar= foobar FROM inserted IF (...

Microsoft SQL Server

8583

Trigger and Row Update Help

by: Jason | last post by:

I have a table that matches up Securities and Exchanges. Individual securities can belong on multiple exchanges. One of the columns, named PrimaryExchangeFlag, indicates if a particular exchange is...

Microsoft SQL Server

21457

Using a trigger on a view

by: Mike | last post by:

I have never written a trigger before, but I have a couple of uses for them now so I am trying. I have a view that I created and I want to have this trigger, run anytime the view is run. I don't...

Microsoft SQL Server

8254

Standard for financial applications specifying maximum number of decimal places?

by: John Bentley | last post by:

John Bentley writes at this level: If we think about our savings accounts then division never comes in (as far as I can see). We deposit and withdraw exact amounts most of the time. Occasionaly...

.NET Framework

15384

Insert and Update Trigger on same Table

by: shottarum | last post by:

I currently have 2 tables as follows: CREATE TABLE . ( mhan8 int, mhac02 varchar(5), mhmot varchar(5), mhupmj int )

Microsoft SQL Server

1755

Tough little trigger

by: rkrueger | last post by:

Given the following 3 Tables: CREATE TABLE ( NOT NULL , NOT NULL CONSTRAINT DEFAULT (getdate()), NULL , CONSTRAINT PRIMARY KEY CLUSTERED (

Microsoft SQL Server

7366

Financial/YIELD Calculations

by: IntraRELY | last post by:

I know this isnt really a VB question per say, but is what I am developing in VB.NET and Excel is the only place that has provided direction. I wanted to ask the public if perhaps you could lend me...

Visual Basic .NET

2375

Trigger problem DB2LUW

by: dean.cochrane | last post by:

I have inherited a large application. I have a table which contains a hierarchy, like this CREATE TABLE sample_table( sample_id int NOT NULL parent_sample_id int NOT NULL ....lots of other...

DB2 Database

7253

how-to - trigger function with argument / parameter

by: djdevx | last post by:

Dear all PostgreSQL xperts! Hi, I am newbie in PostgreSQL. I am currently developing an app that use PostgreSQL as a BackEnd Database. Now I am having problem with the function trigger since last...

PostgreSQL Database

6964

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7175

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

6842

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5430

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4864

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

3070

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1378

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

598

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

262

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General