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
āļø 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.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Swarup
Please sir help me out
Vinish Kapoor
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.
Swarup
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
Vinish Kapoor
I think you should use Interactive Grid instead of the form.
Swarup
In interactive grid can we use data picker, popup lov etc...
Vinish Kapoor
Yes, sure, you can use it. Just click on the column and change its typeāthe rest settings re the same as the form.
Swarup
K sir thnx so much
Swarup
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
Vinish Kapoor
Then do not use the date field and date picker. Use only a varchar2 field. But save the date field in the table.
Swarup
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 ...
Vinish Kapoor
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.
Swarup
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
Vinish Kapoor
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.
Swarup
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
Swarup
Can u plz guide me sir
Swarup
Plz guide me sir
Vinish Kapoor
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.
Swarup
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
Vinish Kapoor
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.
Swarup
Hi sir, can we design this form in oracle apex
Vinish Kapoor
Yes, of course.
Swarup
Sir if u dont mind can u guide me sir plz...
Vinish Kapoor
If I will write a tutorial on it, I will let you know.
Swarup
K sir sure thnx I will wait for it
Swarup
Hi sir if possible cn u plz guide me I stucked in mid of work
Swarup
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
Vinish Kapoor
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.
Swarup
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
Vinish Kapoor
I am sharing this question on Twitter if someone else can help you with this.
Swarup
k sir sure thnks for kind support,please help me out
Sri
Hi,
I have designed total application time sheet if you want anything contact me [email protected]