The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Employees and Departments App opens after entering the Username and Password. The Employee Information is based on the SQL statement used to join the other tables together like Employees, Departments, and Jobs.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
I designed and developed a web-based Conflict Early Warning and Management Control Room that helps organizations collect, manage and analyze conflict-related information. The system includes an administrative dashboard, incident reporting, interactive geographic mapping, report management, officer/user management, authentication and role-based access, document handling, fact-checking workflows and data visualization. Built with React, TypeScript and Supabase.
I designed and developed a full-stack organizational and awards platform for ELDoF and the Pan African Crown of Humanity Awards (PACHA 2027). The platform includes a professional public website, event information, registration and application workflows, administrative dashboard, database management, authentication, communication features, interactive sections and payment-related functionality. The system was built to transform organizational and event processes into a practical digital platform.
Accounts Payable (AP) Invoice Automation:
The project automates the Accounts Payable process by consolidating separate financial data files.
Using Excel’s VLOOKUP function, it links a central summary sheet (AP_Summary.xlsx) with two source workbooks to automatically fill in missing information. It reads the Vendor ID to pull the matching company name from Vendor_Master.xlsx. It reads the Invoice Number to pull the correct billing total from Invoice_Register.xlsx. This process eliminates manual cross-referencing, cuts down on data entry errors, and instantly creates a unified financial dashboard for efficient invoice tracking and accurate bookkeeping.
