Rapidly building a time card app using Oracle APEX
Вставка
- Опубліковано 8 лют 2025
- This video walks you through the process of building a timesheet approval application from scratch using only a web browser and the free apex.oracle.com service.
#orclapex #orclapex_challenge
This is great, should be added to Sample Apps and also would be lovely if you could post the SQL script which generated the sample data. I feel like you present many useful demos but you rarely include any material in description, would be useful for me as a pre sale.
Hello! Sorry, unfortunately, we do not have this specific application available for download. However, you can find other Sample and Starter apps on the APEX GitHub repository (oracle.github.io/apex/) or directly from the Gallery Tab in the APEX App Builder.
Very Nicely explained ..... The content of the document is very much relevant..... any can build the application with their own datamodel ..... after watching this video.
Awesome!!!
Though would have liked a more detailed video about the steps taken in the background.
Yes there's a part where another developer adds a bunch of features that aren't properly explained. I'd love more detail on those portions since the rest of the tutorial hinges on those changes.
Nicely done. Super HowTo demo. Thanks for sharing
11:33 Validation
16:07 Auth Scheme / Exists SQL Query ("Manager")
16:50 Applying Auth Scheme constraint to Page and Navigation
-- other --
19:05 Timecard Records / display only where :app_user in (employee, approver)
19:33 Security Check / Advisor
18:36, 28:02 Login Page (backgound image and custom logo)
Is there any other demo like this to follow up? This was done on 18.2 and there is already 19.1. I will also adhere to the idea of adding the SQL needed to generate the data and the scripts behind the scenes that are required to recreate the entire app. Really awesome.
Awesome
If anyone wants to know how to build an app with ease, accuracy and professionalism, watch this video
look all of the apex creators are very nicely showing there example and you are exceptional among them.
Wonderful demo and tool
Thank you very much for this information.It will be highly appreciated if you create a video on application flow like from page pre-rendering to end. using blank page
Can future APEX (19.2 +) including this application as packaged sample application gallery? Thanks!
Excellent demo 👍
how were you able to log in as an employee. How have you created credentials for an employee? How we can create employee login/SignUp page and forget password?
You can use a third party oAuth service like Auth Zero
its not clear how and where you linked the Employees Page and the TimeCards page using the employee name field. Was this done automatically by the Application Creation Wizard or it was done by the Developer in the Background?
Kindly provide some information about APEX RESTful web services. creating a web service and consuming it. it would be really great to demonstrate it by creating a REST web service, web module and use it on a page. i really need to learn more about it.
Simply superb...
we need sample app or row data and we create it with you thanks
where can I download this sample application? thanks!
how are the two of you able to work concurrently on the application. how did you do it
Awesome demo ...
How to hide the black tool bar in the bottom if i am not a developer??
This is Great!. I have requirement to develop time card but structure would be more granular like For Monday itself we should have multiple entries based upon work done like 8 hours per day divided into 1,1,4,2 or all 1s or some entries for 30 mins etc. and similar pattern we need to follow for all 7 days. How do I implement this with your logic?
Your help is much appreciated.
Thanks in advance.
Hello, Mohini! Thanks for your comment. We invite you to explore the APEX Community Technical Discussion Forum. You can search for and also post your questions: apex.oracle.com/forum.
@@OracleAPEX I check timesheet related Data on Forum but it isn't available there. Can you help me with source code of this app for reference? or Share any documentation anything will work
great demo, loved it. Is there a place to download sql scripts and pl/sql codes? as well as Apex application.
Hello! We are happy to know that you liked the video. Could you, please, add your technical question to the Oracle APEX Community Forums? apex.oracle.com/forum
Can you please complete code for installation
from the video at which point was the table Employee_timecards created ?
this was created as a view
I wanna get oracle apex app instead of the browser
Can anyone explain more about the RESTful web service in this tutorial? I was tried to implement the post method but I didn't succeed to return a Json response. Can anyone help. Eliran
in 13:33 how the total hours is counted? is it based on pl/sql? or anything else is used?
Thanks for your message! We use a Dynamic Action to update the Total Hours item whenever the user enters hours for the days of the week. We also created a validation that is fired when the page is submitted to check if the total hours item exceeds 40, and if the comments are blank. If these conditions are met, then the validation message will be fired. We invite you to explore and share your questions on the Oracle APEX Discussion Forums apex.oracle.com/forum
@@OracleAPEX yes i saw that. My concern is the dynamic action that is calculating the total hours. Is it done by plsql or js? What dynamic action type like set value or set focus. It would be a great help to know it. And the link you comment is not working and provides a 404 error.
@@imtiazshoykat Hello. Thanks for your comment. Please try again accessing the Technical Forum: apex.oracle.com/forum
I have the same issue with this Query:
select ID,
ROW_VERSION,
NAME,
EMAIL,
COUNTRY,
EMPLOYEE_TYPE,
APPROVER,
(select avg(total_hours) from employee_timecards t where t.employee_id = e.id) avg_hours
from EMPLOYEES e
######### table or view does not exist #######
the issue is that he did not find a TOTAL_HOUR column in an script
My all queries are working fine because i also defined total_hours column in script. Now the problem which i am facing that my validation is not working and also display field(on page 6). Please help to find the issue.
can you post the pl/sql code for update the total of hours when i try to create a timecard please? thanks
I get the same problem...
you need to alter EMPLOYEE_TIMECARDS view structure, these are the steps
SQL Workshop - > Object Browser - > Code -> Add at last ( timecards.sunday + timecards.monday + timecards.tuesday + timecards.wednesday + timecards.thrusday + timecards.friday + timecards.saturday) total_hours
👏🏻👏🏻👏🏻
How I can find Mac address of client in Apex 19.1
not able to send email from process, anyone any update
Good case
Hi Bro pls help me on below error;
ORA-01658: unable to create INITIAL extent for segment in tablespace APEX_1238445791068517
All fell apart at 7:28 when you introduced total_hours. At least test your own demo.
Hi, I miss also the part with total_hours. I really don't know how to proceed at this step. Any help from the author? I would appreciate it very much.
@@pafdaddy07 you have to add the total_hours on the employee_timecards view by recreating the view
This isnt related to the main topic but i have an issue with installation of OracleApex, when i try to enter password to setup the apex instance (@apxchpwd.sql) I get an 'ora-01756: quoted string not properly terminated'. I have researched and sort for help from soo many developers but no one seems to be able to help. I also want to be able to install the latest version of apex locally so i cant stop using the cloud version. I will be grateful if you can help me thanks