Thread: Update on Fly and/or Prompt

Hi All,

Ok, when editing it will be for multiple records...the form looks like below but again for multiple records down...

Code:

1Qqty  - 2Qqty  - 3Qqty  - 4Qqty  - TotalQty - Input $ - Master $
[qty]      [qty]      [qty]   [qty]  [sumqty][input(if master0)][master$-no edit]

Issue: I have a statement if Master$ <> 0 then they can't enter an input$. else they can enter input$. The only thing is...I can't force a user to always have input$, they may or may not. So....right now, I'd like to have a check if TotalQty >0 and Master$ = 0 then check input$, if input$ is 0 then prompt enter amt.

but in order to look at TotalQty I need javascript to sum on the fly as numbers are entered in 1Q, 2Q, 3Q, 4Q...how should I go about this?

right now if i edit and enter qty's and master$ is $0 and I don't enter an Input$...then all my calculations stay at $0.
....if they enter qty and master is $0 then must something in Input$.

This can be done. I had a javascript that basically did a sum across columns and down rows as numbers were entered. It's really fun (sorry, it was for a previous company, so I don't have it any more).

- Are your input fields in an HTML table; so it looks like a spreadsheet?
- If so, name your text boxes so you can locate them by name, such as ID="TB_01_04" would be Row 1 Column 4
- Create the javascript and execute it as the onblur event for every input text box.
- In the JS either sum across the row or down the column or both and then set the value of the approprate total text box.

Clear as mud?

Very Pretty;

After looking at your screen shot, I'm gong to revise how I would do this. Basically, you are wanting to validate the form on submit to ensure that all input$ text boxed have a value greater then 0, and if not, scold the user and not submit the form.

Create an onSubmit javascript event handler. If you name all your input$ text boxes with the same name, then you can do a document.getElementsByName("input$") to return a collection of the input$ text boxes. Loop through the collection and check the value and if you find an input$ text box without a valid value, take the approriate action and return false to cancel the submit.

The "appropriate action" could be just about anything. Consider putting a hidden text field right next to each input$ text box with a ! (or some other glyph) as its value. Then, when your loop finds an invalid input$, make the !-glyph unhidden again. The trick part here is finding the !-glyph for the text box in error. If the text box and the !-glyph are in the same <td> node, then you should be able to locate the <td> node using the .parentNode method on the text box. Its a bit of work, but would look slick (and is pretty much now ASP.NET does its validation).

A little bit less work would be to change the background color of the errant text box to red, or some other gosh offal color.