Sign Up

ā‡ļø OrclQA.Com is a question and answer forum for programmers.
ā‡ļø Here anyone can ask questions and anyone can answer to help others.
ā‡ļø It hardly takes a minute to sign up and it is 100% FREE.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Sorry, you do not have a permission to ask a question, You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo

OrclQA.Com Navigation

  • Ask Question
  • Write a Tutorial
  • Online Courses
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • Image to Base64
  • PL/SQL Beautifier
  • Ask Question
  • Write a Tutorial
  • Online Courses
Swarup
Swarup

Swarup

  • India
  • 31 Questions
  • 119 Answers
  • 0 Best Answers
  • 208 Points
View Profile
  • 1
SwarupProfessional
Asked: October 8, 20202020-10-08T18:33:30+05:30 2020-10-08T18:33:30+05:30

Adding row as required in the Form in APEX

  • 1

Hi Sir,

Good Evening i want to create ADD button in the form whenever i click on add button same to same all rows to come at last when i click on create button all data to insert into table

  • 31
  • 1k
  • 0
  • 0
  • Share
    • Share on Facebook
    • Share on Twitter
    • Share on LinkedIn
Answer
    Advertisement

    31 Answers

    1. Swarup

      Swarup

      • India
      • 31 Questions
      • 119 Answers
      • 0 Best Answers
      • 208 Points
      View Profile
      Swarup Professional
      2020-10-09T08:22:15+05:30Added an answer on October 9, 2020 at 8:22 am

      Please sir help me out

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
    2. Vinish

      Vinish

      • 1 Question
      • 855 Answers
      • 74 Best Answers
      • 4k Points
      View Profile
      Vinish Enlightened
      2020-10-09T08:34:45+05:30Added an answer on October 9, 2020 at 8:34 am

      You will have to explain it more.

      You have a form (horizontal row shows in image) now you want an add button to add this data to where?

      Are you thinking to add this data to the grid?

      Please explain in detail.

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
      • Swarup

        Swarup

        • India
        • 31 Questions
        • 119 Answers
        • 0 Best Answers
        • 208 Points
        View Profile
        Swarup Professional
        2020-10-09T08:56:48+05:30Replied to answer on October 9, 2020 at 8:56 am

        Yes sir as shown in image I want to add same rows down to this

        Eg: you can see that there is a task field as much task increase I want to add that much of row as required by pressing add button after filling all the task I will click on create button then all data should be inserted to db

        Actually this is a simple time sheet

        • 0
        • Share
          Share
          • Share on Facebook
          • Share on Twitter
        • Vinish

          Vinish

          • 1 Question
          • 855 Answers
          • 74 Best Answers
          • 4k Points
          View Profile
          Vinish Enlightened
          2020-10-09T09:24:39+05:30Replied to answer on October 9, 2020 at 9:24 am

          I think you should use Interactive Grid instead of the form.

          • 0
          • Share
            Share
            • Share on Facebook
            • Share on Twitter
          • Swarup

            Swarup

            • India
            • 31 Questions
            • 119 Answers
            • 0 Best Answers
            • 208 Points
            View Profile
            Swarup Professional
            2020-10-09T09:36:58+05:30Replied to answer on October 9, 2020 at 9:36 am

            In interactive grid can we use data picker, popup lov etc...

            • 0
            • Share
              Share
              • Share on Facebook
              • Share on Twitter
            • Vinish

              Vinish

              • 1 Question
              • 855 Answers
              • 74 Best Answers
              • 4k Points
              View Profile
              Vinish Enlightened
              2020-10-09T10:01:51+05:30Replied to answer on October 9, 2020 at 10:01 am

              Yes, sure, you can use it. Just click on the column and change its type—the rest settings re the same as the form.

              • 0
              • Share
                Share
                • Share on Facebook
                • Share on Twitter
    3. Advertisement
    4. Swarup

      Swarup

      • India
      • 31 Questions
      • 119 Answers
      • 0 Best Answers
      • 208 Points
      View Profile
      Swarup Professional
      2020-10-09T10:13:01+05:30Added an answer on October 9, 2020 at 10:13 am

      K sir thnx so much

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
    5. Swarup

      Swarup

      • India
      • 31 Questions
      • 119 Answers
      • 0 Best Answers
      • 208 Points
      View Profile
      Swarup Professional
      2020-10-09T11:05:25+05:30Added an answer on October 9, 2020 at 11:05 am

      Hi Sir,

      in place of time picker i want to enter no.of hours

      Eg: meeting i have attended for 2hrs then i want to enter as 2:00

      like 1:00 or 1:30 pop up lov

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
      • Vinish

        Vinish

        • 1 Question
        • 855 Answers
        • 74 Best Answers
        • 4k Points
        View Profile
        Vinish Enlightened
        2020-10-09T11:55:31+05:30Replied to answer on October 9, 2020 at 11:55 am

        Then do not use the date field and date picker. Use only a varchar2 field. But save the date field in the table.

        • 0
        • Share
          Share
          • Share on Facebook
          • Share on Twitter
        • Swarup

          Swarup

          • India
          • 31 Questions
          • 119 Answers
          • 0 Best Answers
          • 208 Points
          View Profile
          Swarup Professional
          2020-10-09T12:01:03+05:30Replied to answer on October 9, 2020 at 12:01 pm

          i want date as well as time like i said before ,can we select date from datepicker and time as said like 2:00hrs

          plz explain me sir ...

          • 0
          • Share
            Share
            • Share on Facebook
            • Share on Twitter
          • Vinish

            Vinish

            • 1 Question
            • 855 Answers
            • 74 Best Answers
            • 4k Points
            View Profile
            Vinish Enlightened
            2020-10-09T14:57:37+05:30Replied to answer on October 9, 2020 at 2:57 pm

            Yes, that is what I meant to say. Create two separate fields for date and time. For date, provide the date picker, and for the time you can provide an open field or a dropdown containing the static time values.

            • 0
            • Share
              Share
              • Share on Facebook
              • Share on Twitter
            • Swarup

              Swarup

              • India
              • 31 Questions
              • 119 Answers
              • 0 Best Answers
              • 208 Points
              View Profile
              Swarup Professional
              2020-10-09T16:02:36+05:30Replied to answer on October 9, 2020 at 4:02 pm

              Thnx Sir as per you suggestion i have done but the form is looking clumsy can we put the text box below the datepicker section or can we merger datepicker and the log section as highlighted in image

              • 0
              • Share
                Share
                • Share on Facebook
                • Share on Twitter
    6. Advertisement
    7. Vinish

      Vinish

      • 1 Question
      • 855 Answers
      • 74 Best Answers
      • 4k Points
      View Profile
      Vinish Enlightened
      2020-10-09T16:52:36+05:30Added an answer on October 9, 2020 at 4:52 pm

      Your timesheet shows the weekdays as the heading; you should not give the option to edit the date. For example, if for Monday, the user selects the date for Tuesday day, which is wrong, right?

      You should process dates in the background, just show the time field for each day.

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
      • Advertisement
      • Swarup

        Swarup

        • India
        • 31 Questions
        • 119 Answers
        • 0 Best Answers
        • 208 Points
        View Profile
        Swarup Professional
        2020-10-09T16:59:14+05:30Replied to answer on October 9, 2020 at 4:59 pm
        This answer was edited.

        Yes sir that can we fix date according to weekdays as per calender can we u guide me as your sugesstion

        can u get only 7 days of that week rest all are graded and can flexible to chose any date of that week based on days

        • 0
        • Share
          Share
          • Share on Facebook
          • Share on Twitter
        • Advertisement
        • Swarup

          Swarup

          • India
          • 31 Questions
          • 119 Answers
          • 0 Best Answers
          • 208 Points
          View Profile
          Swarup Professional
          2020-10-09T21:45:42+05:30Replied to answer on October 9, 2020 at 9:45 pm

          Can u plz guide me sir

          • 0
          • Share
            Share
            • Share on Facebook
            • Share on Twitter
          • Advertisement
          • Swarup

            Swarup

            • India
            • 31 Questions
            • 119 Answers
            • 0 Best Answers
            • 208 Points
            View Profile
            Swarup Professional
            2020-10-10T09:47:21+05:30Replied to answer on October 10, 2020 at 9:47 am

            Plz guide me sir

            • 0
            • Share
              Share
              • Share on Facebook
              • Share on Twitter
    8. Vinish

      Vinish

      • 1 Question
      • 855 Answers
      • 74 Best Answers
      • 4k Points
      View Profile
      Vinish Enlightened
      2020-10-11T08:39:28+05:30Added an answer on October 11, 2020 at 8:39 am

      It is difficult for me to assume what your table structure is. But I can give you a little idea.

      For example, you are showing the timesheet for the current week. Then it would help if you populate the date fields as sysdate, sysdate + 1, sysdate +2, and so on.

      Then you just need to take the input for the time value.

      See, I can help with you the issues but can not build or teach a whole application.

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
      • Swarup

        Swarup

        • India
        • 31 Questions
        • 119 Answers
        • 0 Best Answers
        • 208 Points
        View Profile
        Swarup Professional
        2020-10-11T08:51:37+05:30Replied to answer on October 11, 2020 at 8:51 am

        Thnx so much sir I got ur point I will work on time

        Can we calculate total log hours that we are giving input as 2:00 in every log field

        It should be calculated once we press the save button in IG

        • 0
        • Share
          Share
          • Share on Facebook
          • Share on Twitter
    9. Advertisement
    10. Vinish

      Vinish

      • 1 Question
      • 855 Answers
      • 74 Best Answers
      • 4k Points
      View Profile
      Vinish Enlightened
      2020-10-11T09:08:03+05:30Added an answer on October 11, 2020 at 9:08 am

      I think you should have 2 fields for a time, for log-in and log-out, you would be able to calculate the hours.

      And suppose you have a field calculated_hours in the table, which you can populate using the before or after insert trigger by using the date arithmetic.

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
      • Advertisement
      • Swarup

        Swarup

        • India
        • 31 Questions
        • 119 Answers
        • 0 Best Answers
        • 208 Points
        View Profile
        Swarup Professional
        2020-10-11T11:26:21+05:30Replied to answer on October 11, 2020 at 11:26 am
        This answer was edited.

        Hi sir, can we design this form in oracle apex

        • 0
        • Share
          Share
          • Share on Facebook
          • Share on Twitter
        • Advertisement
        • Vinish

          Vinish

          • 1 Question
          • 855 Answers
          • 74 Best Answers
          • 4k Points
          View Profile
          Vinish Enlightened
          2020-10-11T14:18:39+05:30Replied to answer on October 11, 2020 at 2:18 pm

          Yes, of course.

          • 0
          • Share
            Share
            • Share on Facebook
            • Share on Twitter
          • Advertisement
          • Swarup

            Swarup

            • India
            • 31 Questions
            • 119 Answers
            • 0 Best Answers
            • 208 Points
            View Profile
            Swarup Professional
            2020-10-11T14:30:59+05:30Replied to answer on October 11, 2020 at 2:30 pm

            Sir if u dont mind can u guide me sir plz...

            • 0
            • Share
              Share
              • Share on Facebook
              • Share on Twitter
            • Advertisement
            • Vinish

              Vinish

              • 1 Question
              • 855 Answers
              • 74 Best Answers
              • 4k Points
              View Profile
              Vinish Enlightened
              2020-10-11T14:46:20+05:30Replied to answer on October 11, 2020 at 2:46 pm

              If I will write a tutorial on it, I will let you know.

              • 2
              • Share
                Share
                • Share on Facebook
                • Share on Twitter
    11. Swarup

      Swarup

      • India
      • 31 Questions
      • 119 Answers
      • 0 Best Answers
      • 208 Points
      View Profile
      Swarup Professional
      2020-10-11T14:55:54+05:30Added an answer on October 11, 2020 at 2:55 pm

      K sir sure thnx I will wait for it

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
      • Swarup

        Swarup

        • India
        • 31 Questions
        • 119 Answers
        • 0 Best Answers
        • 208 Points
        View Profile
        Swarup Professional
        2020-10-14T16:01:25+05:30Replied to answer on October 14, 2020 at 4:01 pm

        Hi sir if possible cn u plz guide me I stucked in mid of work

        • 0
        • Share
          Share
          • Share on Facebook
          • Share on Twitter
    12. Advertisement
    13. Swarup

      Swarup

      • India
      • 31 Questions
      • 119 Answers
      • 0 Best Answers
      • 208 Points
      View Profile
      Swarup Professional
      2020-10-15T09:10:09+05:30Added an answer on October 15, 2020 at 9:10 am

      Hi Sir,

      Good Morning, as you have said i have done the date work based on weekdays,now i want to add a comment section on each log section that mean whenever i will enter log comment section should appear as shown in previous screenshot

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
      • Advertisement
      • Vinish

        Vinish

        • 1 Question
        • 855 Answers
        • 74 Best Answers
        • 4k Points
        View Profile
        Vinish Enlightened
        2020-10-15T09:33:10+05:30Replied to answer on October 15, 2020 at 9:33 am

        Meaning you want to enter comments for each row or for all rows at once?

        If once, then maybe you should store comments in the header table.

        • 0
        • Share
          Share
          • Share on Facebook
          • Share on Twitter
        • Advertisement
        • Swarup

          Swarup

          • India
          • 31 Questions
          • 119 Answers
          • 0 Best Answers
          • 208 Points
          View Profile
          Swarup Professional
          2020-10-15T09:39:37+05:30Replied to answer on October 15, 2020 at 9:39 am
          This answer was edited.

          Meaning you want to enter comments for each row ?

          yes sirĀ  i want to enter for each row when log is entered like the screenshot as shown below

          • 0
          • Share
            Share
            • Share on Facebook
            • Share on Twitter
          • Advertisement
          • Vinish

            Vinish

            • 1 Question
            • 855 Answers
            • 74 Best Answers
            • 4k Points
            View Profile
            Vinish Enlightened
            2020-10-15T09:47:44+05:30Replied to answer on October 15, 2020 at 9:47 am

            I am sharing this question on Twitter if someone else can help you with this.

            • 0
            • Share
              Share
              • Share on Facebook
              • Share on Twitter
            • Advertisement
            • Swarup

              Swarup

              • India
              • 31 Questions
              • 119 Answers
              • 0 Best Answers
              • 208 Points
              View Profile
              Swarup Professional
              2020-10-15T09:51:36+05:30Replied to answer on October 15, 2020 at 9:51 am

              k sir sure thnks for kind support,please help me out

              • 0
              • Share
                Share
                • Share on Facebook
                • Share on Twitter
    14. Sri

      Sri

      • 0 Questions
      • 1 Answer
      • 0 Best Answers
      • 25 Points
      View Profile
      Sri Contributor
      2020-11-08T08:36:06+05:30Added an answer on November 8, 2020 at 8:36 am

      Hi,

      I have designed total application time sheet if you want anything contact me ksrinivasaraoevam@gmail.com

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter

    You must login to add an answer.

    Forgot Password?

    Advertisement

    Sidebar

    Ask Question
    Write a Tutorial
    Advertisement

    Recent Blog Posts

    • Vinish

      Oracle Concat

    • Vinish

      Oracle CHR Function

    • Vinish

      Oracle ASCII Function

    • Vinish

      A Guide To Writing Technical Specs | How to Write a Technical ...

    • Vinish

      Can Oracle Database Run on MAC?

    Advertisement
    Advertisement

    Explore

    • Home
    • Blog
    • New Questions
    • Tutorials
      • Oracle
      • Oracle Apex
      • Python
    • Tags
    • Users
    • Badges & Points
    • Image to Base64
    • PL/SQL Beautifier

    Creative Commons License
    This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
    © 2021 OrclQA.Com. All Rights Reserved.
    Privacy Policy - About Us