Find Jobs
Hire Freelancers

Custom Google Apps (Cloud) Database Design for Service Business

$100-500 USD

Completed
Posted over 13 years ago

$100-500 USD

Paid on delivery
Computer company in need of a custom designed database for the cloud integrated with Google Apps. You will be required to write up specifications with us that will be used for contact management, customer work orders/sales orders and scheduling. Integration with Google Contacts and Calendaring is required as well as Gmail login for authentication (willing to consider OpenID or other recommendations). All work must be open source using standard technologies. Absolutely NO Microsoft technologies will be permitted. Your experience with OOP such as CakePHP, AJAX, and other OOP will put you to the front of the line for this bid. ## Deliverables 1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement). * * *This broadcast message was sent to all bidders on Friday Nov 12, 2010 4:45:54 PM: I apologize if you were not qualified for this job. Please disregard if you do not do this type of work. Most of you requested I provide more details. I have created a list of requirements/specifications that are about 90% complete so you can more accurately bid on this job. I decided to remove calendaring and simplify the situation. Please understand that this list is still slightly incomplete and you will be required to input additional small features/requests as they come up but this should not change the scope and general idea of what is needed. Contact Management 1.) To be integrated with Gmail/Google Contacts so that we may email customers. 2.) Customer email will be stored and used for sending order updates. 3.) Management of contact information (add, delete, edit, etc.. 4.) Company, Name, Address, City, State, Zip, Phones/Phone Types, Cells/Cell Providers, Emails 5.) Company name will be contact name if no company exists or unknown 6.) Only domain authenticated users may work with work orders (except client login below). Work Orders 1.) Creation of work orders and use of work order numbers 2.) Creation Date/Time, ETA Date, Completion Date 3.) Drop down list for status of work order (Checked In, In Progress, Appointment Set, Waiting on Customer, Waiting on Parts, Preparing, Done, Void) 4.) Work order considered open with all statuses except Preparing, Done & Void) 5.) Send updates to customers email/text asking to log in for updated status (send summary with initial message). 6.) Assigned Rep (edit list) 7.) PC Make, Model, Serial, OS, RAM, HD 8.) Line items for parts or service ordered and their cost 9.) Text fields required: A.) Description of Problem B.) Work Order Log (multiple lines with date/time stamps and no delete/edit abilities) C.) Hidden Tech Notes (multiple lines with date/time stamps and no delete/edit abilities) D.) Resolution E.) Recommendations F.) Statement of Warranty & Guarantee 10.) Printable format Customers Work Order Portal 1.) Client logs in using email as username and work order number as password. Password emailed with every email/SMS. Email not to be customers primary record ID. 2.) Log customer log-ins in work order log 3.) View text fields required except Internal Tech Notes and include all info on client except name/contact info 4.) Allow customer to add notes to log and log IP, date/time. Admin Portal 1.) Make default page for login of domain users 2.) Display list of work orders in order of status then date/time. Line items clickable to view/edit item 3.) Allow only viewing of work order status 4.) Search function in most fields ## Platform Google Apps API, OOP, MySQL, PHP, AJAX, Open Source
Project ID: 3845148

About the project

22 proposals
Remote project
Active 13 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$403.75 USD in 14 days
4.2 (3 reviews)
3.6
3.6
22 freelancers are bidding on average $2,117 USD for this job
User Avatar
See private message.
$2,125 USD in 14 days
5.0 (173 reviews)
9.3
9.3
User Avatar
See private message.
$1,496 USD in 14 days
5.0 (102 reviews)
6.7
6.7
User Avatar
See private message.
$425 USD in 14 days
5.0 (24 reviews)
5.1
5.1
User Avatar
See private message.
$782 USD in 14 days
4.9 (19 reviews)
4.8
4.8
User Avatar
See private message.
$85 USD in 14 days
4.8 (7 reviews)
4.7
4.7
User Avatar
See private message.
$425 USD in 14 days
5.0 (12 reviews)
4.3
4.3
User Avatar
See private message.
$85 USD in 14 days
5.0 (6 reviews)
4.1
4.1
User Avatar
See private message.
$2,856 USD in 14 days
5.0 (1 review)
1.3
1.3
User Avatar
See private message.
$8,500 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$595 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$2,550 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$144.50 USD in 14 days
5.0 (1 review)
0.0
0.0
User Avatar
See private message.
$6,000 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$1,020 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$300 USD in 14 days
0.0 (1 review)
0.0
0.0
User Avatar
See private message.
$136 USD in 14 days
0.0 (0 reviews)
1.4
1.4
User Avatar
See private message.
$170 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$85 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$1,104.15 USD in 14 days
0.0 (3 reviews)
0.0
0.0
User Avatar
See private message.
$297.50 USD in 14 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Ontario, United States
5.0
44
Member since Feb 25, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.