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

Oracle APEX Tutorials & Forum

Oracle APEX Tutorials & Forum Logo Oracle APEX Tutorials & Forum Logo

Oracle APEX Tutorials & Forum Navigation

  • Home
  • Oracle Apex
  • PL/SQL
  • SQL
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Ask Question
  • Write a Tutorial
  • Tools
    • Oracle Table Script Generator
    • PL/SQL Package Generator
  • Users
  • Tags
  • FAQs
  • Badges
  • Home
  • Oracle Apex
  • PL/SQL
  • SQL
Swarup
Swarup

Swarup

  • India
  • 30 Questions
  • 119 Answers
  • 0 Best Answers
  • 207 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

31 Answers

  1. Swarup

    Swarup

    • India
    • 30 Questions
    • 119 Answers
    • 0 Best Answers
    • 207 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 Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 62 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
      • 30 Questions
      • 119 Answers
      • 0 Best Answers
      • 207 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 Kapoor

        Vinish Kapoor

        • 1 Question
        • 727 Answers
        • 62 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
          • 30 Questions
          • 119 Answers
          • 0 Best Answers
          • 207 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 Kapoor

            Vinish Kapoor

            • 1 Question
            • 727 Answers
            • 62 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. Swarup

    Swarup

    • India
    • 30 Questions
    • 119 Answers
    • 0 Best Answers
    • 207 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
  4. Swarup

    Swarup

    • India
    • 30 Questions
    • 119 Answers
    • 0 Best Answers
    • 207 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 Kapoor

      Vinish Kapoor

      • 1 Question
      • 727 Answers
      • 62 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
        • 30 Questions
        • 119 Answers
        • 0 Best Answers
        • 207 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 Kapoor

          Vinish Kapoor

          • 1 Question
          • 727 Answers
          • 62 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
            • 30 Questions
            • 119 Answers
            • 0 Best Answers
            • 207 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
  5. Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 62 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
    • Swarup

      Swarup

      • India
      • 30 Questions
      • 119 Answers
      • 0 Best Answers
      • 207 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
      • Swarup

        Swarup

        • India
        • 30 Questions
        • 119 Answers
        • 0 Best Answers
        • 207 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
        • Swarup

          Swarup

          • India
          • 30 Questions
          • 119 Answers
          • 0 Best Answers
          • 207 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
  6. Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 62 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
      • 30 Questions
      • 119 Answers
      • 0 Best Answers
      • 207 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
  7. Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 62 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
    • Swarup

      Swarup

      • India
      • 30 Questions
      • 119 Answers
      • 0 Best Answers
      • 207 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
      • Vinish Kapoor

        Vinish Kapoor

        • 1 Question
        • 727 Answers
        • 62 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
        • Swarup

          Swarup

          • India
          • 30 Questions
          • 119 Answers
          • 0 Best Answers
          • 207 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
          • Vinish Kapoor

            Vinish Kapoor

            • 1 Question
            • 727 Answers
            • 62 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
  8. Swarup

    Swarup

    • India
    • 30 Questions
    • 119 Answers
    • 0 Best Answers
    • 207 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
      • 30 Questions
      • 119 Answers
      • 0 Best Answers
      • 207 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
  9. Swarup

    Swarup

    • India
    • 30 Questions
    • 119 Answers
    • 0 Best Answers
    • 207 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
    • Vinish Kapoor

      Vinish Kapoor

      • 1 Question
      • 727 Answers
      • 62 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
      • Swarup

        Swarup

        • India
        • 30 Questions
        • 119 Answers
        • 0 Best Answers
        • 207 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
        • Vinish Kapoor

          Vinish Kapoor

          • 1 Question
          • 727 Answers
          • 62 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
          • Swarup

            Swarup

            • India
            • 30 Questions
            • 119 Answers
            • 0 Best Answers
            • 207 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
  10. 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 [email protected]

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

You must login to can add an answer.


Forgot Password?

Sidebar

Explore

  • Ask Question
  • Write a Tutorial
  • Tools
    • Oracle Table Script Generator
    • PL/SQL Package Generator
  • Users
  • Tags
  • FAQs
  • Badges

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