Source: https://oguzerol.com/en/custom-web-apps-for-your-team/ [ View full size](https://oguzerol.com/gorseller/hizmet-kapaklari/ekibiniz-icin-ozel-web-uygulamalari-seri-v1-en.webp) # Custom Web Applications Your Team Can Use Together [Oğuz Erol](https://oguzerol.com/en/about-me/) | 7 min read I turn work you run in Excel or Google Sheets into a custom web application your team uses together. The app runs on a server and the records live in one database. Everyone logs in with their own account, sees and edits the fields that belong to their job, and every change is logged with who made it. It works in a browser on a phone or a laptop. Below are the screens I can build this way, grouped by topic. Each one focuses on a single need; a real project usually combines several of them. I describe the overall process, the server setup and pricing on the [Excel to web app](https://oguzerol.com/en/turn-your-excel-into-a-web-app/) page. [](https://oguzerol.com/gorseller/web-uygulama/spreadsheet-file-vs-server-web-app.webp) While the file travels from person to person, and once the same records live in one place on a server. Your team works on the same records while each user sees the screens and permissions their role requires. ## How we start your custom application We first review your current spreadsheet and the task that needs the most attention. I identify who enters each piece of information, how calculations work and which steps require approval. The first version focuses on that core workflow, followed by feedback from the people who will use it. This gives us a practical starting point and a clear order for further features. Mobile and desktop use, data migration, access permissions and update frequency are defined for your project. I can develop applications running on a VPS and connect them to other tools where data access is available. Hosting, maintenance and source-system access are considered at the start. ## Could Excel or Google Sheets already meet the need? Both tools support collaboration, calculations and validation. A custom application becomes worth considering when you need different record access for each user, a multi-step approval process or screens designed for particular roles. Improving the existing spreadsheet may also be the right solution. Four guides that may help before you decide: - [How to share an Excel file with multiple users](https://oguzerol.com/en/share-excel-file-with-multiple-users/): when co-authoring is enough, and why the “file is locked” message appears. - [How to lock cells in Excel](https://oguzerol.com/en/how-to-lock-cells-in-excel/): the steps for protecting formulas, and where a lock stops being enough. - [AppSheet vs a custom web app](https://oguzerol.com/en/appsheet-vs-custom-web-app/): what building a no-code app on Google Sheets solves and what it doesn’t. - [Can you use Google Sheets or Excel as a database?](https://oguzerol.com/en/google-sheets-as-a-database/): the difference, the limits and how to move. [](https://oguzerol.com/gorseller/web-uygulama/sample-order-tracking-web-app-screen.webp) Several of the screens below in one place: role-based permissions, a form with rules, people working at the same time and a change log. The companies, people and orders are made up. ## Find the workflow you need ### User permissions and teamwork - [Excel Cell-Level Permissions Panel](https://oguzerol.com/en/excel-cell-permissions-panel/) - [Assigned Records Tracking Portal](https://oguzerol.com/en/assigned-records-tracking-portal/) - [Role-Based Screens for Sales and Operations](https://oguzerol.com/en/role-based-sales-operations-screens/) - [Cost-Protected Quoting Portal](https://oguzerol.com/en/cost-protected-quoting-portal/) - [Branch-Based Data Entry System](https://oguzerol.com/en/branch-based-data-entry-system/) - [Client Project Status Portal](https://oguzerol.com/en/client-project-status-portal/) - [Supplier Delivery Date Portal](https://oguzerol.com/en/supplier-delivery-date-portal/) - [Approved Record Change Control](https://oguzerol.com/en/approved-record-change-control/) - [Record Change History](https://oguzerol.com/en/record-change-history/) - [Time-Limited External Team Access](https://oguzerol.com/en/time-limited-external-team-access/) ### Excel and Google Sheets forms - [Dependent Dropdown Custom Forms](https://oguzerol.com/en/dependent-dropdown-custom-forms/) - [Product and Customer Autofill Form](https://oguzerol.com/en/product-customer-autofill-form/) - [Price and Cost Calculation Screen](https://oguzerol.com/en/price-cost-calculation-screen/) - [Searchable Product Selection Screen](https://oguzerol.com/en/searchable-product-selection-screen/) - [Rules-Based Data Entry Form](https://oguzerol.com/en/rules-based-data-entry-form/) - [Searchable Form Records System](https://oguzerol.com/en/searchable-form-records-system/) - [Concurrent Data Entry App](https://oguzerol.com/en/concurrent-data-entry-app/) - [Controlled Excel Import Screen](https://oguzerol.com/en/controlled-excel-import-screen/) - [Mobile Alternative to an Excel Form](https://oguzerol.com/en/mobile-excel-form-alternative/) - [PDF Documents from Form Records](https://oguzerol.com/en/pdf-documents-from-form-records/) ### Expenses, budgets and payments - [Mobile Employee Expense Entry](https://oguzerol.com/en/mobile-employee-expense-entry/) - [Expense Permissions and Reporting Screen](https://oguzerol.com/en/expense-permissions-reporting-screen/) - [Employee Expense Approval Workflow](https://oguzerol.com/en/employee-expense-approval-workflow/) - [Budget vs Actual Expense Dashboard](https://oguzerol.com/en/budget-vs-actual-expense-dashboard/) - [Expense Receipt and Document Tracking](https://oguzerol.com/en/expense-receipt-document-tracking/) - [Track Staff Advances and Reported Expenses Together](https://oguzerol.com/en/staff-advance-expense-tracking-panel/) - [See Each Project’s Costs Separately](https://oguzerol.com/en/project-cost-tracking-app/) - [Remind the Right Person About Upcoming Payments](https://oguzerol.com/en/payment-due-date-reminder-app/) - [Track Recurring Costs and Subscription Renewals](https://oguzerol.com/en/subscription-renewal-expense-tracking-app/) - [Collect Daily Income and Expense Entries in One Place](https://oguzerol.com/en/daily-income-expense-tracking-app/) ### Inventory, orders and quotes - [Move Stock In and Out to a Shared Team Screen](https://oguzerol.com/en/inventory-tracking-system-setup/) - [Track Stock by Colour and Size Variant](https://oguzerol.com/en/variant-stock-tracking-app/) - [See Stock by Warehouse on One Screen](https://oguzerol.com/en/multi-warehouse-stock-tracking-app/) - [Separate Reserved Stock from Available Quantity](https://oguzerol.com/en/reserved-stock-tracking-app/) - [Make Low-Stock Purchasing Needs Visible](https://oguzerol.com/en/minimum-stock-purchasing-tracking-app/) - [Track Orders from Preparation to Delivery](https://oguzerol.com/en/order-preparation-delivery-tracking-app/) - [Let Dealers Submit Orders Through Their Own Portal](https://oguzerol.com/en/dealer-order-entry-portal/) - [Quote Screens That Calculate by Measurement and Option](https://oguzerol.com/en/measurement-based-quote-calculator-app/) - [Track Quote Revisions and Customer Follow-Ups](https://oguzerol.com/en/quote-revision-followup-tracking-app/) - [Compare Supplier Quotes on the Same Criteria](https://oguzerol.com/en/supplier-quote-comparison-report/) ### Operations and reporting - [Assign Work and See Pending Steps Together](https://oguzerol.com/en/team-task-assignment-tracking-app/) - [Track Service Requests from Opening to Completion](https://oguzerol.com/en/technical-service-work-order-tracking-app/) - [Track Periodic Maintenance by Date, Asset and Owner](https://oguzerol.com/en/periodic-maintenance-tracking-app/) - [Check Conflicts in Appointment and Resource Planning](https://oguzerol.com/en/appointment-resource-planning-app/) - [Bring Business Data from Different Files into One Dashboard](https://oguzerol.com/en/excel-dashboard-setup/) - [Compare Branch Results Using the Same Definitions](https://oguzerol.com/en/branch-daily-report-comparison-app/) - [Custom Reporting Screens for Hotel Reservation Records](https://oguzerol.com/en/hotel-reservation-records-reporting-screens/) - [From Excel to a Web App: Room Occupancy Page](https://oguzerol.com/en/hotel-room-occupancy-tracking/) - [See How Ad Leads Progress to Quotes and Sales](https://oguzerol.com/en/ad-lead-quote-sales-tracking-app/) - [Build a Repeatable Monthly Reporting Workflow](https://oguzerol.com/en/put-your-monthly-report-on-autopilot/) - [Connect Website Forms to Your Team’s Work Tracking Screen](https://oguzerol.com/en/web-form-to-crm-automation/) ## Custom screens for forms, spreadsheets and integrations These examples cover approval, missing documents, import errors and access rules as well as data entry. Each service page includes an illustrative screen; the actual features are developed within your agreed project scope. ### From Google Forms to a custom app - [Custom Google Forms Alternative for Your Workflow](https://oguzerol.com/en/custom-google-forms-alternative/) - [Conditional Web Forms with Answer-Based Fields](https://oguzerol.com/en/conditional-logic-web-forms/) - [Order Forms with Repeatable Line Items](https://oguzerol.com/en/repeating-line-item-order-form/) - [Guest File Upload Forms for Customer Documents](https://oguzerol.com/en/guest-file-upload-form/) - [Save and Resume Application Forms](https://oguzerol.com/en/save-and-resume-application-form/) - [Application Status Tracking Portal](https://oguzerol.com/en/application-status-tracking-portal/) - [Capacity-Limited Event Registration Forms](https://oguzerol.com/en/capacity-limited-event-registration/) - [Conditional Email Notifications from Forms](https://oguzerol.com/en/conditional-form-email-notifications/) ### Apps connected to Google Sheets - [A Central Data Portal Beyond IMPORTRANGE](https://oguzerol.com/en/importrange-alternative-data-portal/) - [Filter-Based Reports for Google Sheets QUERY Users](https://oguzerol.com/en/google-sheets-query-reporting-app/) - [Multi-Select Forms with Related Records](https://oguzerol.com/en/multi-select-related-record-form/) - [Google Sheets and Calendar Synchronisation](https://oguzerol.com/en/google-sheets-calendar-sync-app/) - [Two-Way Data Sync with Google Sheets](https://oguzerol.com/en/google-sheets-two-way-sync-app/) - [Threshold Alerts for Google Sheets Data](https://oguzerol.com/en/google-sheets-threshold-alerts/) ### File imports and scheduled data - [Automatically Combine Excel Files into One App](https://oguzerol.com/en/automatically-combine-excel-files/) - [Scheduled API Data Imports with a Monitoring Screen](https://oguzerol.com/en/scheduled-api-data-import-app/) - [Import Excel Attachments from Email](https://oguzerol.com/en/email-excel-attachment-import/) - [Bank Transaction Matching and Reconciliation App](https://oguzerol.com/en/bank-transaction-reconciliation-app/) - [Controlled Excel to SQL Database Migration](https://oguzerol.com/en/excel-to-sql-database-migration/) - [Supplier XML Product and Stock Integration](https://oguzerol.com/en/supplier-xml-product-feed-integration/) - [Power Query Refresh Status and Error Monitoring](https://oguzerol.com/en/power-query-refresh-monitoring/) ### Workflows connected to WhatsApp - [WhatsApp and Google Sheets Integration](https://oguzerol.com/en/whatsapp-google-sheets-integration/) - [WhatsApp Multi-Agent Inbox and Assignment Panel](https://oguzerol.com/en/whatsapp-multi-agent-team-inbox/) - [WhatsApp Order Status Notifications](https://oguzerol.com/en/whatsapp-order-status-notifications/) - [Quote Request Forms Opened from WhatsApp](https://oguzerol.com/en/whatsapp-quote-request-form/) - [Turn WhatsApp Messages into Assigned Tasks](https://oguzerol.com/en/whatsapp-message-to-task-workflow/) - [WhatsApp Opt-In and Preference Management](https://oguzerol.com/en/whatsapp-opt-in-management-panel/) ### People and operations apps - [Employee Leave Tracking and Approval App](https://oguzerol.com/en/employee-leave-tracking-app/) - [Shift Scheduling and Conflict Checks](https://oguzerol.com/en/shift-scheduling-web-app/) - [Project Timesheet and Work Hours Tracking](https://oguzerol.com/en/project-timesheet-tracking-app/) - [Asset Checkout and Custody Tracking App](https://oguzerol.com/en/asset-checkout-tracking-app/) - [Production Work Orders and Stage Tracking](https://oguzerol.com/en/production-order-tracking-app/) - [Purchase Requisition and Budget Approval App](https://oguzerol.com/en/purchase-requisition-approval-app/) - [Recruitment Applicant and Interview Tracking](https://oguzerol.com/en/recruitment-applicant-tracking-app/) - [Customer Complaint and Resolution Tracking](https://oguzerol.com/en/customer-complaint-tracking-app/) - [Field Inspection Forms with Photo Evidence](https://oguzerol.com/en/photo-based-field-inspection-app/) - [Quality Inspection Measurements and Exceptions](https://oguzerol.com/en/quality-inspection-records-app/) - [Lot and Serial Number Traceability App](https://oguzerol.com/en/lot-serial-number-traceability-app/) - [Contract Renewal and Owner Tracking App](https://oguzerol.com/en/contract-renewal-tracking-app/) - [Barcode Inventory Counts and Variance Review](https://oguzerol.com/en/barcode-inventory-count-app/) ## Frequently Asked Questions ### How quickly can you build a custom application? I begin with the priority workflow and the screens it needs so I can aim for an initial working version quickly. User roles, calculations, migration and integrations affect the schedule. I share scope and timing after reviewing your current setup. ### Do I have to move to an off-the-shelf product? No. This service is custom application development. Where appropriate, the application can exchange data with your Excel or Google Sheets files. We can also consider an existing product if it already meets your needs. ### Where does the app run, and who holds our data? The app runs on a server (a VPS) and the records live in its database. The server can be opened in your company’s name. The data is yours, and you can export all of it to Excel or CSV at any time. ### How many users can we add? Is there a per-user fee? There is no per-user licence. The running cost is the server’s monthly fee plus upkeep; for a small or mid-sized team, adding users doesn’t change it. ### How is the work priced? I work remotely and bill hourly. I send the scope and an estimate in writing after I’ve seen your spreadsheet. ## Let’s review your workflow [Tell me what you need and we can plan the first version of your custom application.](https://oguzerol.com/en/contact/) [Back to top ↑](https://oguzerol.com/en/custom-web-apps-for-your-team/#icerik) ## You may also find these useful [Expense Permissions and Reporting ScreenA tailored panel that separates expense entry, team visibility and company-total access by user role. Built for Excel and Google Sheets workflows.](https://oguzerol.com/en/expense-permissions-reporting-screen/)[Connect Website Forms to Your Team’s Work Tracking ScreenRoute website enquiries into your CRM, Google Sheets or a custom tracking panel, with ownership, duplicate-enquiry handling and field checks.](https://oguzerol.com/en/web-form-to-crm-automation/)[Role-Based Screens for Sales and OperationsA bespoke web app that gives sales, operations and management purpose-built views of the same records. Built for Excel and Google Sheets workflows.](https://oguzerol.com/en/role-based-sales-operations-screens/) [Browse all articles →](https://oguzerol.com/en/articles/) WHAT YOU CAN ASK FOR ## How do I work? Work-hour packages Tell me about your business and what you need on WhatsApp or by phone; we agree on **a work block of somewhere between 5 and 40 hours** and I start doing what is needed. What you get is not a calendar window — it is net working hours spent directly on your business. I can use 40 hours working three days straight, or deliberately spread it out and finish it over a year — whatever the work calls for. I do not spend my time estimating how long something will take, I spend it doing the work; every hour I spend leaves a lasting result in your business. We keep going for as long as you find it useful. WORK BLOCKS ## Why not monthly? Is 40 hours a week? On a fixed monthly fee both sides are watching the wrong thing: you watch a fixed cost, the other side watches how many more contracts like this they can line up. Working by the hour puts us both in front of the same thing — the real value of the work that got done. I know not having an upfront answer to "how much will this cost in total?" is the natural cost of this model. But instead of paying a fixed fee for months to a setup that is not producing results, you only pay for the qualified time spent on your work — and you see exactly where that time went, start to finish. That is why my clients keep coming back. 5hours300€ + VAT60€ per hour[Choose this block](https://wa.me/905496546489?text=Hi%2C%20I%27d%20like%20info%20about%20the%205-hour%20work%20block.) 10hours500€ + VAT50€ per hour[Choose this block](https://wa.me/905496546489?text=Hi%2C%20I%27d%20like%20info%20about%20the%2010-hour%20work%20block.) 20hours800€ + VAT40€ per hour[Choose this block](https://wa.me/905496546489?text=Hi%2C%20I%27d%20like%20info%20about%20the%2020-hour%20work%20block.) 40hours1,400€ + VAT35€ per hour[Choose this block](https://wa.me/905496546489?text=Hi%2C%20I%27d%20like%20info%20about%20the%2040-hour%20work%20block.)