Completed

Google Sheets Customer Relationship Management database

We use Google Sheets to keep track of our customers. In order to find previous interactions with our customers we need to set up a database for reliable data storage.

Key project features:

Save Data:

- Save all rows to a database.

- Update database when cells are edited.

Retrieve Data:

- The data will be displayed in a sidebar.

- Sidebar will contain a search bar, search will browse all db data.

- Search results will be displayed in the right sidebar grouped by interaction containing all data (if not empty).

- Search results will be ordered by time, the most recent first and will be labeled with “Today” and “Yesterday”, if applicable.

- When a cell from column “Phone No.” will be populated, the script will automatically search the db and will retrieve the entries matching the phone number.

VERY IMPORTANT NOTES

We already have a version of the software built 2 months ago by a [url removed, login to view] developer but it’s super slow. Even the drop down menu from column “Status” takes way too long to execute. The custom options from menu item “CRM Menu” -> “Move row to top / Move row to bottom”, again, takes too long to execute.

Another glitch: when a phone number is inserted in a cell, the script triggers the sidebar to load, at this moment the cell gets defocused for several seconds and the users loses the ability to edit the cell. This creates a very stressful and unwanted situation.

All of the above issues must

Our customer database will grow considerably and we need the program to run fast, to be precise and reliable.

You can use any technology you think it’s most appropriate. The current program is build with php and using mysql db.

Please apply only if you think you can write a fast program that will not get cloggy as the db grows.

If you are up for the job type Electro-Sombrero.

You can follow this editable link to check the speed and test the current functionality of the sheet.

[url removed, login to view]

Thank You!

Skills: PHP, Software Architecture

See more: usp of freelancer in, top job freelancer developer, storage freelancer, software developer phone number, software developer job search, software developer find job, software developer at freelancer, script sheets, project status in freelancer com, project management at freelancer, php project management freelancer, mysql customer database, job search software developer, google sheets freelancer, google sheet freelancer, google-docs.com, google docs.com, google developer freelancer, freelancer update 2016, freelancer test results

About the Employer:
( 14 reviews ) Constanta, Romania

Project ID: #10979596

Awarded to:

Comply

Electro-Sombrero Hello I checked your spreadsheet and I offer you to make it much faster. I will get rid of the annoying progress bar. I will make moving a row to the top and to the bottom to take only a few seco More

$163 USD in 7 days
(2 Reviews)
1.8

11 freelancers are bidding on average $260 for this job

AwaisChaudhry

Hi there! I have read what you exactly need, however I would like to ask you a few questions. I wouldn't call myself a master but I do work smart and do not rest until I get the job done. Please feel free to ping me an More

$155 USD in 3 days
(29 Reviews)
6.2
lavizsolutions

Electro-Sombrero ? want to know thats meaning ..please come on chat.. Hi Adrian Zlotea, the best way i can do is, please share me your database and code, so that can check the sql queries , once you satisfied, pay More

$500 USD in 10 days
(17 Reviews)
6.4
bmartynvw

I'm an expert with over a decade experience . I have gone through your requirements. As a cloud based solution, I would recommend the use of Apex which will both be quick and can be scalable for your business. I could More

$222 USD in 3 days
(15 Reviews)
6.0
$197 USD in 5 days
(19 Reviews)
5.2
$155 USD in 3 days
(15 Reviews)
4.7
wpoppo

Hello, Thanks for giving me an opportunity to bid on your project. I can build a fantastic CRM. I have experience in developing several CRM and web based management system and very confident to deliver you the syst More

$1000 USD in 30 days
(7 Reviews)
4.5
ssshukla

i see your requirement. we can use the google sheet script for the inserting the dats in to google sheet. I have 5 + year Experience in IT industry. I have strong knowledge of ,MVC4,Linq -to-Sql, JSON , Java Script, More

$150 USD in 3 days
(24 Reviews)
3.9
$123 USD in 3 days
(7 Reviews)
3.6
rainstreamweb

Hello, This is not copy/paste message. I read your requirements. I can work with what you have requirement of. I have expertise in Ruby on Rails, Laravel, Magento, AngularJS, Core PHP etc. technologies and can w More

$155 USD in 3 days
(5 Reviews)
2.7
ratheeshKumar

Hi, i have gone through the job description and i word suggest instead of changing the technology we should optimize the current application if possible and i would like to take a look at this already build software. More

$100 USD in 5 days
(3 Reviews)
1.9
techsmithptyltd

First off "Electro-Sombrero" so you know it is worthwhile reading further. I agree PHP/MySQL (with some javascript) is a good way of achieving your goal and whilst I cannot critique your current solution without see More

$150 USD in 3 days
(2 Reviews)
1.3
khaledalam

Ok, I can start help you right now, i have ability to work well under pressure. i'm certain if you choose me will see best results, Some of our projects: [login to view URL] Don't hesitate to conta More

$111 USD in 1 day
(4 Reviews)
1.6