This discussion is archived
6 Replies Latest reply: Nov 21, 2012 10:53 PM by Mindmap RSS

Form - Dynamic 'Insert another line'

Vikzul Newbie
Currently Being Moderated
I have a form which users can populate with a LOV.
I'm wondering how hard it is to have a dynamic 'Add another line' function so I don't have to hard extra fields that may not be used.
I'll be using a lookup table which will contain the following values.

ID to request, Individual ID, Manufacturer, Model Number
(example data)
1 1 Cisco 2650
1 2 Cisco 2700
2 1 Cisco 2650

Any ideas or pointers?
  • 1. Re: Form - Dynamic 'Insert another line'
    Vikzul Newbie
    Currently Being Moderated
    Maybe somehow even hardcode let's say 10 fields, and only show the next one if the previous one is not null?
    Any help?
  • 2. Re: Form - Dynamic 'Insert another line'
    Mindmap Pro
    Currently Being Moderated
    Hello,
    In Apex, we have Tabular form which 100% meets your requirements and more ...

    Here you can watch video:
    http://www.youtube.com/watch?v=SEXlQd_kBko

    And here, you can find the docs:
    http://docs.oracle.com/cd/E37097_01/doc/doc.42/e35125/bldapp_frm.htm#BCEECEFA

    Best Regards,
    Fateh
    ---------
    If you believe that my answer was helpful to you or correct, then please mark the answer as helpful or correct.

    By the way, it looks like you want to show a specific number of rows as the page loads, if so, then please create DA (Dynamic Action):
    Event : page load.
    Action: Execute Java Script
    Code:
    addRow();
    Regards,
    Fateh

    Edited by: Fateh on Nov 18, 2012 8:33 PM
  • 3. Re: Form - Dynamic 'Insert another line'
    Vikzul Newbie
    Currently Being Moderated
    I'm trying to implement this into a current 'form on a table', is this possible to do?
  • 4. Re: Form - Dynamic 'Insert another line'
    Mindmap Pro
    Currently Being Moderated
    Hello,
    Sure, please just read and watch the tutorial ....
    More resources:

    http://apex.oracle.com/pls/apex/f?p=44785:24:0:::24:P24_CONTENT_ID,P24_PREV_PAGE:5077,1


    Demo:
    http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-sample-tabular-form-1669896.zip

    ------
    If you believe that my answer was helpful to you or correct, then please mark the answer as helpful or correct..
  • 5. Re: Form - Dynamic 'Insert another line'
    Vikzul Newbie
    Currently Being Moderated
    That wont work in my current situation.

    A very simple look here.

    http://apex.oracle.com/pls/apex/f?p=65888:1:13976768692357:::::
    u:guest
    p:apextest

    I have a form which needs to be filled out with contact info.
    Then below I need multiple areas for devices.
    The tabular form is not unique to the request id. It is static.

    Can you understand what I'm trying to do or do I need to explain better? :D
  • 6. Re: Form - Dynamic 'Insert another line'
    Mindmap Pro
    Currently Being Moderated
    Hello,
    If neither me ,nor other people in the forum answered your question, nor my answers were even helpful, then I doubt that you need to explain more ...
    Then below I need multiple areas for devices.
    What do you mean by area ?

    Do you want to use master details form and create new records on the two tables at once ?

    Regards,
    Fateh

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points