6 Replies Latest reply: Nov 22, 2012 12:53 AM by Mindmap RSS

    Form - Dynamic 'Insert another line'

    Vikzul
      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
          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
            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
              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
                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
                  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
                    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