Calculate A Field Value Based On An Other Field

Jun 2, 2011

I have designed an online registration system for a non profit in ASP/SQL. After the members register for classes they are automatically redirected to an invoice page with class fees. At the bottom of the page I have a Total Fees field of all the classes. The member is supposed to pay this amount to our organization.

Question: We decided to do an online payment this year and would like to calculate a 2% additional amount on the Total Fees. This amount is paid to the Payment Merchant site. We cannot afford to lose the 2% since we are a non profit.

1) Add a new field under the Total field
2) And calculate the 2% additional fees and do a Grand Total.

View 2 Replies


ADVERTISEMENT

Calculate Field Based On Another Field In Form

Jul 23, 2005

Is there a way I can calculate a field in a form based on another field in
the same form. When clicking submit, both values should be posted to the
next page. I want to be able to type in a value in one field, and
automatically in a second field the value*1,36 should appear.

View 6 Replies View Related

Calculate Age Based On Dob Field?

Nov 23, 2010

I am trying to calculate age based on the date of birth input into a text field.
the date field should allow users to enter a one or two digit month, one or two digit date and a two or four digit year. Users should be able to enter any of the following date formats: 11-2-10, 1-25-2010, or 01/25/2010. On some days it works and others it wont, like 11-1-91 returns that the user is under 18.

function checkAge(){
var stDate = document.getElementById("birth").value;
var dayPartToDate = parseInt(stDate.substring(0,2),10);
var monPartToDate = parseInt(stDate.substring(3,5),10);

[Code]....

View 1 Replies View Related

Dynamically Showing Field Based On Text Value From Another Field?

Nov 18, 2009

I have a text field, call it income, that when the input is > 0 I need to dynamically show the next text box, and if it is blank hide the next text box. I would like to use onBlur but can't seem to get it to work.

View 5 Replies View Related

Autopopulate A Field Based On Value In Another Field

Jun 27, 2011

I have two drop down fields. When I select any value in the first drop down i want the second dropdown to automatically populate the value related to the first one. For e.g i have the first field as name and the second field as measured in. If I select 'Potato' in the first dropdown then the second drop down should populate 'kg'.

View 4 Replies View Related

Calculate Field Values Using Javascript

Feb 26, 2006

Can someone explain how I can use javascript (I am assuming this is the best
way to do it) to add two field values together. I.e. field 1 plus field 2
equals field 3 (this is in a php form)

Also how can I set a field to be a value depending on what the user selects,
i.e. they may have eight items to select from and each one has a different
value.

The above javascript will then use that value to add to another field value
to give a me a total value....

View 5 Replies View Related

JQuery :: (.) Period In Value Field - Show/hide A Div Based Based On The Selection Made Via A Dropdown

Apr 9, 2010

Im using a jQuery script to show/hide a div based based on the selection made via a dropdown.

<script type="text/javascript" src="jquery-1.3.2.min.js"></script>

The problem im having is that the value used in the dropdown lists are price values eg 10.00

Consequently jQuery seems to interprit these as css notations, meaning the code doesnt work.

View 4 Replies View Related

Pre Populate Text Field Based On Another Text Field

Jan 23, 2010

I'm developing a web page. It includes 2 text boxes. One text box for city and another text box for std code. I wrote the code for auto suggestion to city. Now i want to pre populate the STD code when ever a known city is selected (when city is selected from the recommendations displayed for city field).

View 8 Replies View Related

Sum Of Array Elements - Add And Delete Dynamic Rows And Auto Calculate The Amount Field By Multiplying Qty And Rate

Mar 21, 2011

This is my code to add and delete dynamic rows and auto calculate the amount field by multiplying qty and rate.

[Code]...

View 3 Replies View Related

Dynamically Set A Field Based Upon A Parameter

Jul 23, 2005

Is something like this possible?

A form with x fields named
field1, field2, ... fieldx

I'd like to set the field specified in the parameter

function SetUnknownField(FieldID)
{
document.myform.field+FieldID+.value="Something calculated";
}

View 5 Replies View Related

Show A Field Based On Another Fields Value?

Mar 9, 2011

I am trying to show a field based on another field's value and hide it it initially... like when you want students to select their schools if they have gone for education ortherwise the school field remains inactive...I have the folowing scipt but it is not being fired on page load...

<script type="text/javascript">
function OnPageLoadAdd(pageid)
{
var tName = 'dbo.Register';

[code]....

View 9 Replies View Related

Update Field Based On What Is Selected

Oct 7, 2009

I am trying to create this form to update a field when a certain item is selected from a dropdown menu. I would like to have it to where when heat pump is selected from heating type, the AFUE field that originally has a value of 80 needs to be updated to 7.7. I would also like for the wording to be changed... Instead of having it say Current AFUE or HSPF, have it to where when a Single Speed Furnace or Variable Speed Furnace then it says AFUE below it, when Heat Pump is selected then it says HSPF, and if Electric Heat is selected do not have anything or even delete the whole field.

[Code]....

View 7 Replies View Related

Fill Value Of Text Field Based On Dropdown?

Sep 25, 2010

What im trying to do is for each item selected from the drop down, display its value in a text box (GAC). I have attached a picture of the image to clarify.

The drop down items are populated from a database, and each item has an associated GAC value. The remaining inputs are user supplied and all the inputs including the drop down item and its value are is stored in a different table in the database.

View 1 Replies View Related

Autocomplete Field For 'city' Based On 'state'?

Dec 29, 2010

Here is what I'm envisioning: The user selects a state, then in the 'Cities' box, he starts typing the name of his city. However, it autocompletes the name for him based on the state he chose. So if he chose California and started typing in "Los Angeles", it would autocomplete "Los Angeles" for him. Does that make sense? Is there a script out there that can do this?

View 1 Replies View Related

Populate Form Field Based On Select Option?

Jan 14, 2009

Is there some example js that shows how to populate a text field on a form, based upon what option is chosen in a select form field? The options can be hardcoded and it would be great to also have a default if js is off on the client side.code...

View 4 Replies View Related

Changing Hidden Field Value Based On Selected Option

Aug 25, 2009

how to Change a Hidden Fields Name based on selected option. The hidden fields name is sent off and I need to change the name depending on what option they select. For if they select MyList the hidden field name needs to be SelectLists[40] or if they select testlist the hidden field name needs to be SelectLists[41]. This is probably way, way off but I've done this and it doesn't work.

[Code]....

View 9 Replies View Related

Dynamic Drop Down List Based On Text Field Value

Nov 25, 2009

I have a form that has a pretty complicated combo box - a user starts typing text, it queries a database for matches, and displays the results to the user. The user can then select the match they desire and it has a value id, which I am currently sending to a hidden field in the form. So, for example: user starts typing in a movie name, Seven - it returns Seven and user selects it. The form submits the id of the movie seven (say 12) to a hidden field.

Where I am stumped: Once a user selects a movie title, I have another drop down select box that is to display the available formats of the movie by querying my database based on the product id (12) and returning the available formats in the list:

DVD
BLUERAY
VHS

I am pretty good at programming, but I cannot figure this out - how to make the select box fire and return results once the value for the textbox has been captured.

View 1 Replies View Related

Change The Status Field Based On Date Difference?

May 28, 2010

I have a form that captures member registration details. In the admin section .. I would like to change the Status field of a record/s from NEW to PAYMENT DUE after 14 days from the data of submission. The status change should automatically trigger on the 15th day. So when the admin checks the list page he/she should be able to view the updated status field.

View 2 Replies View Related

Menu Populates Based On Select Field Entry?

Aug 10, 2011

I am looking to build as basic as possible, a form that has 3 select dropdowns that have predetermined options. The user will select the first option and based on that option the second will populate and based on that, the third one will give the last option. Now, when the last one is selected, i need a div or a paragraph displaying information to be displayed.So here's the framework.

Option 1 = fruit or vegitables of which fruit is selected is selected by the user
Option 2 = Apples, Grapes, and pears of which apples is then selected
Option 3 = Red, Green and Yellow of which Green is selected.

Once green is selected, I need a description about the green aple to be displayed.

View 7 Replies View Related

Make A Button Visibile Based On Form Field Value?

Nov 19, 2009

Buttons visibility is set to hidden to start. Suggestions?

<script Language="JavaScript">
Function CKPMT1()
Var PMT1;
PMT1 = document.Form1.BalPmtPayee.value;
IF PMT1 = "" then ;

[Code]...

View 7 Replies View Related

Autofilling A Text Field Based On Prior Input?

Sep 2, 2010

The specific piece I'm stuck on at the moment is this:I have a form with a lot of fields, two of which are subnet (a drop box populated from a database, via PHP) and IP address (a text input box). When the user selects a subnet, the value is sent to a PHP script that queries the DB and returns the next unused IP address. If all I wanted was to display that in a div next to the IP input box, I'd be set -- that works fine.Unfortunately, I can't for the life of me figure out how to get the returned data into a text input box, which is what I actually want.I know that ocument.getElementById("div_id").innerHTML=request.responseText; will display the text in a div in my sample code. I found a post somewhere that implied that frm.getElementById("input_id").value = request.responseText; would do the job for a text input, but it doesn't, at least in any of the browsers I've tested.

View 1 Replies View Related

Auto Text Field Populate Based On Dropdown

Feb 22, 2011

I've looked around and from what I can tell, the code seems right. Basically crating a JS array and passing PHP values to it to use in an onChange to fill a text field. The dropdown gets populated fine but the text field does not autopopulate onChange. I'm not too fluent with JS but have a good analytical mind and from what I can see, the logic seems right.

<?php
include('connectdb.php');
$CENTRE = $_SESSION['centreAFB'];
$qryFormList = mysql_query("SELECT * FROM tblLogin WHERE ACCT_TYPE = '2' AND loginCENTRE = '$CENTRE' ORDER BY loginNOM");
echo "<script type='text/javascript'> var formCourriel = new Array()";
while($resFormList = mysql_fetch_assoc($qryFormList))
[Code]....

View 7 Replies View Related

Image Swap Based On Text Field Value Change?

Aug 17, 2011

i'm quite new to javascript and have an issue with an image swap script. I have three images that should change based on the value of a text field (total), however, there is only one image that is swapping. Please see the code below:

Code:
<html>
<head>
<script type="text/javascript">
//This is where we decare our function to validate the HTML form
function validateform()

[Code]...

View 4 Replies View Related

Show / Hide Based On Database Field Value - NOT Onclick

Oct 30, 2009

I have created a user form in which visitors can fill in sections, some of which are hidden or displayed using the onclick to trigger a DIV to display or hide then submit the results to a database using ASP. All works fine with that, however... I have created another page which retrieves the results for an individual's form submission, and I want to hide the sections that were not completed (hidden when submitted). How can I get my page to hide or show DIVs, depending on the value retrieved from a particular field within the database? i.e. if Question1Response="A", show Div ID="A Section" If Question1Response="B", show Div ID="B Section" etc.

View 4 Replies View Related

Disable Text Field Based On Dropdown Menu Selection

Feb 18, 2009

I have a simple form - I want to disable the text field if Choice 2 from the dropdown menu is selected. I have this working with the code below, but for some reason if I go back and select choice 1 after selecting choice 2 the text field remains disabled. I only want it to be disabled if choice 2 is selected.

View 5 Replies View Related

Show/Hide Text And Form Field Based On Drop Down Selection

Jul 20, 2005

I'm trying to show/hide a simple piece of text and a text field on a
form based on what choice is made from a drop down box.

<select name="dropdown" size="1">
<option selected value="">Please make a selection</option>
<option value="1">Choice 1</option>
<option value="2">Choice 2</option>
<option value="3">Choice 3</option>
<option value="4">Other</option>
</select>

i.e. if Choice 2 is selected I'd like to display a new <tr> with the
following:

<tr>
<td>New text field:</td>
<td><input name="newField" type="text size="20"></td>
</tr>

if any other choices are made, I don't want to display anything.
I've tried several onchange() functions but can't achieve what I'm
looking for.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved