
Open
Posted
Paid on delivery
GOAL To create an Apple (Mac) App which has the ability to access a local LAN MS Access MDB residing on a QNAP server. Email or TXT notification of workflow or task completion will be required. The primary function is to transition from paper based forms to storing completed forms on a server. There will be multiple phases, involving different forms being converted. REQUIREMENTS All development tools and programs need to be purchased and stored on the local server. IP will remain property of company at all times. PHASE 1 App development on Apple APP download consisting of (1) Download activation process (once downloaded to an I-PAD, a challenge question based on date / time which requires a changing key to make the APP “active” (2) Database consisting of (a) Name, First and Last and Student # (b) Role (student, User, Instructor, Admin and PIN (c) Equipment (S/N, Make and Model) (d) Booking hours (Date and Time) (e) Form consisting of 4 Sections – each question has a numeric of 1 through 5 (buttons) a. Section 1 having 8 questions b. Section 2 having 5 questions c. Section 3 having 7 questions d. Section 4 having 5 questions (3) Once app is activated, student enters first, last name, student number and assigned PIN – PIN as to be changed (and uploaded to DB) (4) Student fills out form, and selects instructor and booking slot time. A numerical calculation is compiled, with three (3) possible outcomes. (5) Depending on the status of the user role, TXT and / or email workflow or notification will be required. (6) Data can be stored on the APP off-line if the booking is within 4 hours – once at site, the off-line data can be up-loaded and then processed.
Project ID: 40421387
45 proposals
Open for bidding
Remote project
Active 39 secs ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
45 freelancers are bidding on average $539 USD for this job

Hi, This is Elias from Miami. I checked your project description and understand you need a phased Apple/iPad app to replace paper forms, store completed records on your QNAP-hosted MS Access MDB, support offline form entry, and send email/TXT workflow notifications. I’ve worked on form-based business apps with offline storage, role-based access, database sync, and notification workflows. My approach would be to build Phase 1 as an iPad/macOS-compatible app with activation logic, secure PIN handling, local offline storage, MDB sync via a small LAN service/API, scoring outcomes, booking selection, and email/SMS notifications based on user roles. I’d be happy to go through the details and suggest the best technical approach. I have a few questions to get a better understanding: Q1 – Should the app run on iPad only, Mac only, or both? Q2 – Can we add a small local API service on the QNAP/server to safely connect to the MDB database? Q3 – Which SMS/email provider do you prefer for notifications? Looking forward to hearing from you.
$500 USD in 7 days
8.1
8.1

Hi there To move paper-based forms into a server-backed Apple app, the most critical part is designing the database and sync flow correctly before building the form screens. I’ll approach this by first confirming whether Phase 1 is macOS, iPadOS, or both, then mapping users, roles, PIN changes, equipment, booking slots, form sections, scoring outcomes, and notifications against the existing MDB structure. The offline workflow needs special care because data entered before arrival must be stored locally, uploaded safely within the booking window, and processed without duplicate submissions or missed notifications. This means I understand how to handle LAN database access, QNAP-hosted Access data, activation rules, role-based workflow, numeric scoring, email/TXT alerts, and phased form conversion. My process starts with database and platform review, then moves into app architecture, form workflow, offline storage, sync logic, notifications, testing, and deployment documentation. If it aligns with you, let’s discuss in detail via private chat.
$500 USD in 7 days
7.2
7.2

⭐⭐⭐⭐⭐ ✅Hi there, hope you are doing well! I recently developed a similar Mac and iOS app integrated with a local MS Access database on a network server, allowing secure offline data entry and seamless syncing, which worked easily by using effective local storage and network protocols. From my experience, the most critical part of this project is ensuring reliable and secure local database access and syncing, especially handling offline data storage and timed upload for uninterrupted workflow. ⭕Approach: - Develop Mac app with secure activation via dynamic challenge-response key. - Implement role-based user authentication with PIN management. - Design form UI with all sections and numeric inputs as specified. - Enable offline data capture and timed sync capabilities. - Configure email and SMS notifications triggered by user role and workflow status. - Store development tools and IP securely on local server as per requirements. ❓Could you please clarify which email and SMS service you prefer for notifications? I am confident in delivering a robust and user-friendly Mac app tailored to your phased rollout with reliable data processing. Kind regards, Nam
$550 USD in 5 days
5.2
5.2

Hi, This seems related to device activation, local MDB access, and reliable offline sync between the app and QNAP-hosted Access DB. You need role-based flows, PIN lifecycle, form scoring, and email/SMS triggers. I’d first verify the current MDB schema and QNAP network access, then build the app’s activation check, local storage + 4‑hour offline queue, and a secure sync/upload process that updates the central DB and sends notifications. I’ll also add PIN update handling and role-based notification logic to prevent duplicate or failed workflows. You’re looking for someone who can own this end-to-end and keep IP on your server—I’ll work that way. Ready to review the MDB and access details to scope phase 1. --Smith
$500 USD in 7 days
5.7
5.7

⭐⭐⭐⭐⭐ Create an Apple App for MS Access Data Management and Notifications ❇️ Hi My Friend, I hope you're doing well. I've gone through your project requirements and see you are looking for an Apple App that connects to a local LAN MS Access MDB on a QNAP server. You don't need to look any further; Zohaib is here to help you! My team has successfully completed over 50 similar projects for app development. I will create a user-friendly app that transitions from paper forms to digital storage while ensuring notifications for task completion. ➡️ Why Me? I can easily develop your Apple App as I have 5 years of experience in app development, focusing on database connectivity and user interface design. My expertise includes iOS development, database management, and user authentication. Additionally, I have a strong grip on other relevant technologies, ensuring a seamless and efficient solution. ➡️ Let's have a quick chat to discuss your project in detail and I can show you samples of my previous work. Looking forward to discussing this with you in chat. ➡️ Skills & Experience: ✅ iOS Development ✅ Database Management ✅ User Authentication ✅ App Design ✅ MS Access Integration ✅ Notification Systems ✅ Data Storage Solutions ✅ Offline Data Handling ✅ User Experience Design ✅ API Integration ✅ Scripting and Automation ✅ Debugging and Testing Waiting for your response! Best Regards, Zohaib
$350 USD in 2 days
5.1
5.1

Hi there, I understand you need a native macOS/iPad app (Objective‑C/Cocoa) that reads a local MS Access MDB on a QNAP over LAN, supports offline form entry with timed sync, and sends email/SMS workflow notifications, my background in macOS apps, Access integration and on‑prem NAS workflows fits this need. - Deliverable 1: macOS/iPad app with activation challenge-key tied to date/time, local encrypted PIN entry, user roles (Student/User/Instructor/Admin) and Student profile fields saved to the QNAP-hosted MDB. - Deliverable 2: 4-section numeric form UI (8/5/7/5 questions), booking slot selection, calculation logic producing 3 outcomes, local offline storage and automatic upload when on-site within 4 hours, plus email/TXT notifications per role. - Deliverable 3: Installer and server-side scripts to store required dev tools on local server, Access MDB schema and secure upload process. - Risk/quality-control: backup checkpoint + staged deployment with post-deploy validation and rollback plan. Skills: ✅ Objective-C/Cocoa ✅ Microsoft Access (MDB) on QNAP LAN ✅ Offline sync / data upload workflow ✅ Email/SMS notification integration ✅ macOS/iPad deployment + local hosting ✅ Security: encryption, PIN management Certificates: ✅ Microsoft® Certified: MCSA | MCSE | MCT ✅ cPanel® & WHM Certified CWSA-2 I am available now; Should I build this as a universal macOS and iPadOS app or focus first on iPad-only for Phase 1? Best regards,
$700 USD in 3 days
4.0
4.0

Hi, This should be handled as a phased internal workflow app, not just a form screen. For Phase 1, I’d structure it as: → macOS/iPad app for activation, login/PIN change, form completion, booking selection, and offline storage → secure LAN connection to the QNAP-hosted MDB through a lightweight service layer → scoring logic with the 3 outcome paths → email/TXT notifications based on role and workflow result → upload/sync process for offline forms submitted within the 4-hour window The key decision is how to safely connect to MS Access. I would avoid unstable direct MDB writes from the app and instead use a controlled backend/service that validates and writes data properly. That keeps the IP, tools, source, and deployment fully under company control while making future phases easier. I’ve built production apps and internal workflow systems where offline handling, permissions, and reliable data sync mattered, so I’d focus first on a clean Phase 1 foundation that can support the next forms without rework.
$500 USD in 5 days
3.0
3.0

Hello there, I will build the iPad app in SwiftUI with the activation challenge, role/PIN signup, equipment + booking + form data, the 4-section scoring (8+5+7+5 questions, three-outcome calculation), Core Data offline cache with the 4-hour booking window, and Twilio + SMTP notifications by role. Flag: iOS cannot connect directly to MS Access on QNAP. Access is Windows-only file-based; no iOS driver exists. Two paths: (1) keep Access and add REST middleware on a Windows machine (or QNAP x86 container) that proxies queries, or (2) migrate Access to PostgreSQL/MariaDB on QNAP, which most NAS units already host. Path 2 is cleaner long-term and removes the Windows dependency. Questions: 1) QNAP x86 model (can run Windows containers), or ARM? 2) Open to migrating Access to PostgreSQL, or is Access mandatory? Send me a message and we can go over the details. Best regards, Faizan
$440 USD in 7 days
2.9
2.9

With my years of experience as a freelance web and software developer, focused on building smart digital solutions, I am confident in creating the Apple (Mac) App you need. Expertise in iOS development and Mobile App Development have allowed me to specialize in transforming complex requirements, similar to those presented in your phase1 goals, into reliable and high-impact systems that deliver real business value. Your project description highlights the need for not just a built piece of software but a "clean, reliable, and high-impact digital system". This is a core focus of my work -- building technology that grows with your business. Whether it's developing an app that stores forms on a server or a process for activating downloads, I will ensure your data is secured properly to maintain IP ownership. Furthermore, you can rest assured knowing that your project is being handled by someone who understands the importance of scalability and strategy. I don't just develop; I innovate practically with modern tech stacks and smart architectures. As teammates for this project, we will work together with clarity and efficiency without compromising quality. Let's get started!
$350 USD in 5 days
2.4
2.4

With my extensive experience in database and mobile app development, I am confident that I can create a powerful, user-friendly Mac App for form processing that precisely caters to your needs. My proficiency in languages like C/C++, Java, and Swift combined with my expertise in working with hardware-sensory systems make me the perfect fit for your project. I have successfully developed apps with similar features before, including robust activation processes and intricate databases. I understand the importance of data security and will ensure that your IP remains protected at all times. Additionally, my knowledge and mastery of various platforms will help create an efficient system for transitioning from paper-based forms to storing them on a local server.
$250 USD in 2 days
2.0
2.0

Thank you for outlining your requirements for the Mac app to streamline form processing and database integration. At DemiVision, LLC, we have extensive experience developing cross-platform applications for Mac and iOS, with a strong background in integrating legacy systems such as MS Access databases over LAN environments. We understand the need for a secure activation mechanism, role-based access, offline data handling, and robust notification workflows via email or TXT. Our approach will ensure the app offers a smooth activation process with dynamic challenge-response keys, intuitive form entry, and secure PIN management. We will architect the database to capture all required fields, and implement efficient syncing that allows offline form completion and automatic upload once connectivity is restored. Notifications will be tailored by user role, optimizing workflow and communication. We are committed to using only company-owned tools and ensuring all intellectual property remains with you throughout development. Our team’s expertise with Cocoa, Objective-C, and database connectivity on macOS/iOS platforms ensures a high-quality, maintainable solution. We look forward to collaborating on each project phase to deliver a seamless transition from paper-based forms to a digital workflow that enhances productivity and data integrity.
$500 USD in 10 days
0.0
0.0

Hi there, I’ve built similar responsive websites and mobile apps, and I am very interested in your Mac/iPad form-processing project. I can help develop the app workflow for activation, PIN updates, offline form storage, LAN MDB access on your QNAP server, booking slots, role-based notifications, and phased form conversion while keeping your IP and tools on your company server. Best regards, John
$750 USD in 30 days
0.0
0.0

Hello, I understand you need a macOS app to convert paper forms to a server-stored digital workflow, with LAN access to a QNAP-hosted MS Access MDB, offline capacity, and phase-based form migrations. I’ll tailor a robust, on-prem solution aligned with your security and IP ownership requirements, delivered as a native macOS app with offline-first capabilities and configurable notifications. Solution highlights: - Native macOS app (Cocoa/Objective-C) with activation via date/time challenge and a changing activation key. - Local database schema: Name, First, Last, Student #; Role; PIN; Equipment; Booking hours; Form with 4 sections (8/5/7/5 questions, each 1-5). - Offline-first data capture: store forms locally (within 4-hour window) and auto-upload when on-site to process. - MS Access integration over LAN on QNAP: secure connection, with a protocol for data sync and conflict handling. - Role-based notifications: TXT and/or email upon task/workflow completion. - Phase 1 deliverables with a clear migration path for subsequent forms. Deliverables: - Mac app ready for download with activation flow and offline mode - Data model, forms, and user roles schema - Sync/upload module, error handling, and audit logs - Notification subsystem (TXT/Email) configuration - Basic admin panel for user/PIN management and form templates - Documentation and test plan Budget + timeline: - Budget: 750 USD - Timeline: 28 days from project start I’m a Full-Stack Digital Expert (Design, Web Developm
$550 USD in 7 days
0.0
0.0

Hi there, Moving your paper-based forms into a secure Apple app that can sync with an MS Access MDB on a QNAP LAN server needs careful handling of offline storage, activation, PIN changes, role-based workflow, and notifications. I have spent the last 4 years solving exactly this type of form-processing and database-sync problem for iOS/macOS environments. For Phase 1, I will build the app flow for activation using a date/time-based challenge key, student login with PIN update, role/equipment/booking data, the 4-section numeric form, score calculation with 3 outcomes, and instructor/booking selection. I will also implement local offline storage for bookings within 4 hours, LAN upload to the MDB database once onsite, and email/TXT notifications based on user role and workflow status. Development assets, source code, and project files can be organized so the company retains full IP ownership on your local server. Best regards,
$450 USD in 1 day
0.0
0.0

Hello, I’ve carefully reviewed your full requirement, and this is a strong fit for a structured, offline-capable enterprise iOS system rather than a simple app build. I understand the key challenges here are secure local LAN access to an MS Access (MDB) database on QNAP, role-based workflows, offline-first form handling, and reliable sync + notification logic. My approach would be to build a modular iOS (iPad-first) app using Swift with a clean architecture layer so the database, authentication/activation system, and form engine are fully separated. For the MDB on QNAP, I would implement a secure middleware/API bridge (recommended for stability on Apple platforms), ensuring reliable read/write operations without compromising data integrity. Offline storage (CoreData/local persistence) will handle the 4-hour offline workflow and sync queue. The activation system, role-based access (student/instructor/admin), form scoring engine, booking logic, and email/SMS workflow will all be built as independent services so Phase 2+ expansion is seamless. I also ensure IP protection, structured documentation, and full source delivery as requested. Portfolio: https://www.freelancer.pk/u/salahuddin1973 Before we proceed, will your QNAP environment allow a lightweight API service layer (recommended), or must we connect directly to the MDB file at all times? Best regards, Naufal
$300 USD in 26 days
0.0
0.0

WILL IT START RIGHT NOW: As a seasoned freelance developer, I've gained significant experience in diverse domains like App Development, iPadOS and Mac OS. Your project, which aims to create a Mac app for form processing with database integration aligns perfectly with my expertise. I prioritized your requirement for all tools and programs to be stored locally, ensuring the IP remains with your company for maximum security. What sets me apart is my ability to seamlessly blend artistic design with technical development. I make sure that aesthetics not only enhance usability but also deliver on-target brand messaging since you need your app to be usable on both iPad and Mac , retrofitting it according device screen sizes will not be an issue at all , Plus, my eye for design ensures a clean and user-friendly UI/UX. I'm confident that my unique combination of skills along with my reliability and client-centered approach towards projects makes me the ideal fit for this task. Let's collaborate to take your forms online in a way that enhances user experience while streamlining your workflow!
$250 USD in 1 day
0.0
0.0

✋ Hi - I'm Larry from Atlanta. Seeing key here is offline forms, I am going to implement the app using React Native, with secure activation, role-based PIN access, local offline storage, LAN database sync, and email/TXT notifications. React Native is better if you want faster development and easier future Android support, while Swift is stronger for fully native Apple performance and deeper iOS-level control. What do you prefer - React Native for faster cross-platform development and future Android support, or Swift for stronger native Apple performance and deeper iOS control? ✅ Confirm what I do on this project: 1. React Native Apple app for Phase 1 workflow 2. Download activation process with changing key 3. Student login with first name, last name, student number, and PIN 4. PIN change and database upload 5. Role-based users: student, User, Instructor, Admin 6. Equipment records with S/N, make, and model 7. Booking hours with date and time 8. Four-section form with 25 numeric questions 9. Score calculation with 3 possible outcomes 10. Email and/or TXT notifications by workflow status 11. Offline storage when booking is within 4 hours 12. Upload and processing once connected on site 13. Company ownership of tools, code, and IP Let's discuss more through chatting. I can start immediately and build this Phase 1 app with a clean, phased structure for future form conversions. Thank you, Larry
$500 USD in 14 days
0.0
0.0

Hi there, this feels very aligned with a phased field-workflow app, but I want to be careful about one architectural point from the start: an iPad app can work offline and later sync to a server, but direct live interaction with an MS Access MDB on a QNAP share is not a strong long-term foundation for an Apple app. Access is not natively supported on macOS or iPadOS, and offline-first mobile apps are generally much safer when they sync through a controlled service layer rather than writing directly to a shared MDB file on the network. So if I were taking this on, my first step would be to stabilize the architecture before coding Phase 1 screens. I’d keep the iPad experience exactly as you described — activation, student login and PIN change, offline form completion, scoring logic, booking selection, notifications, and later upload — but I’d strongly recommend placing a small sync/API layer between the app and the MDB or, better, gradually moving the data store to something more robust while preserving your current workflows. That approach reduces risk around file locking, offline conflicts, and future phases, while still delivering the app you need now. The project itself is very feasible, especially as a multi-phase form conversion system, but I’d want to align on the data layer first so the build does not become fragile the moment multiple users start syncing real records.
$500 USD in 7 days
0.0
0.0

Ocala, United States
Payment method verified
Member since May 5, 2026
₹600-1500 INR
$30-250 USD
$3000-5000 USD
$250-750 USD
$10-30 USD
₹1500-12500 INR
₹1500-6500 INR
$10-30 USD
$250-750 USD
$250-750 USD
₹12500-37500 INR
₹1500-12500 INR
€3000-5000 EUR
$15-25 CAD / hour
$3000-5000 USD
$3000-5000 USD
₹600-1500 INR
₹1500-12500 INR
$30-250 AUD
$10-30 USD