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
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
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
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.
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
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.
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
I think you should use Interactive Grid instead of the form.
In interactive grid can we use data picker, popup lov etc…
Yes, sure, you can use it. Just click on the column and change its type—the rest settings re the same as the form.
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
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.
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
I am sharing this question on Twitter if someone else can help you with this.
k sir sure thnks for kind support,please help me out
K sir sure thnx I will wait for it
Hi sir if possible cn u plz guide me I stucked in mid of work
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.
Hi sir, can we design this form in oracle apex
Yes, of course.
Sir if u dont mind can u guide me sir plz…
If I will write a tutorial on it, I will let you know.
Please sir help me out
Hi,
I have designed total application time sheet if you want anything contact me ksrinivasaraoevam@gmail.com
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.
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
Can u plz guide me sir
Plz guide me sir
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
Then do not use the date field and date picker. Use only a varchar2 field. But save the date field in the table.
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 …
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.
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
K sir thnx so much