Skip to main content
O
Olivia_Crazy_Horse
Known Participant
October 15, 2008
Question

Dynamic input fields base on a value

  • October 15, 2008
  • 1 reply
  • 355 views
I have a form that auto generates a document number. The user then enters one or more part numbers and quantities. When they submit, I insert all the document number, all the part nubmers and quantites into a table. I then use cflocation to pass the document nubmer to another page and query the table again using #url.docuemnt_number#.

What I want to do is to generate input fields based on the quantity of each part number. So if I retrieve pn1 for the docuemtn number and the qty is 5, it will generate 5 input fields. Then it gets the next part number, pn2, and if the qty is 2, it will generarte 2 input fields, etc. all on the same page. When they submit, I will insert all the input fields into another table along with the docuemtn number and part number.

Is is possible to do this in cf, and if yes, how do I do it.?
    This topic has been closed for replies.

    1 reply

    W
    WestSide
    Inspiring
    October 15, 2008
    Hi,

    Well, yes it is possible. But I think I would change things a bit in your logic. It seems odd to store the document number, part number and quantity in the database after the user has hit submit. Why do you need to insert those values into the database at this point? You shouldn't have to query the table again using #url.document_number#.

    Page 1: Have a form where the user enters one or more part numbers and quantities. When the user submits the form pass the data to page 2

    Page 2: Receives the data from the user and ColdFusion makes it available in the Form Scope on the calling page (page 2). I would then just loop the number of times for each given part number's quantity. At each iteration of the loop a new <input type="text" /> field gets created

    There are also other ways to do this so maybe someone else can chime in.

    Hope that at least get you started, but the key is to loop. If you have a qty of 5 for a given part number and you want 5 input fields, you should loop.

    -Westside
    O
    Olivia_Crazy_HorseAuthor
    Known Participant
    October 15, 2008
    Thanks for the response.

    I thought about passing instead of inserting in the first screen, but how do you pass all those values, multiple part numbers and quantities ? Thats why I inserted first.

    Also for the loop, it would be cfloop from=1 to =#qty# ? How or when does the qty change based on each part number ?
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices