design a simple crm form / system that can pull data from google docs and post transactions into a spreadsheet

Closed

I require a cloud-based system (I'm thinking google forms or similar) that users in various regions can access and securely input customer data as well as transaction details that can post to a central spreadsheet (either in google docs or dropbox). Not such a complicated task, except for one thing (otherwise I could do it myself using Jotform or google forms). The form needs to have pre-populated pricing data that is pulled from a spreadsheet, the product type and quantity is then chosen by the user and the form needs to calculate a total based on 1. the user's qty input and 2. the pre-populated pricing data.

I know this can be done, I've already got an Edit Grid spreadsheet working inside a Jotform which can be manipulated by the user in this way but the data is fixed and would need to be updated manually (not an option), google spreadsheets don't seem to have this functionality (I can only seem to get them to display in HTML, not actually accept data). Whereas the google spreadsheet actually pulls the real-time data I need to be able to use for the pricing calculations (through the =importdata function) which I can't seem to do with the Edit Grid.

I'm hoping that there is some sort of workaround that can be done using a google widget, otherwise we'll have to build something from scratch. I'm obviously trying to keep costs fairly low here, but at the end of the day need something that works properly too.

Skills: CRM, Database Administration, Software Architecture, User Interface / IA

See more: crm cloud, google docs grid widget, google forms crm, can google forms pull data, we trying to function, using google spreadsheet, spreadsheet in html, product pricing spreadsheet, html spreadsheet widget, html form to spreadsheet, grid design, google system architecture, google spreadsheet html, google. docs, google app engine pricing, docs. google, design html widget, design an app from scratch, app design costs, crm spreadsheet design, spreadsheet google, google google docs, google docs is, google docs crm, google cloud engine

Project ID: #4112766

9 freelancers are bidding on average $527 for this job

SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$350 CAD in 7 days
(21 Reviews)
6.4
sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our More

$750 CAD in 30 days
(5 Reviews)
5.4
auriclesoft09

Dear Sir, Expertise in Open Source/CRM/ERP/POS/Custom Solutions/Web designing. We do customization as per your requirements. With a good Profile in Freelancer and experience of over seven years in the Software Arena More

$1300 CAD in 42 days
(11 Reviews)
5.2
zeke

Dear Customer! I am an expert web developer with over 6 years of experience and very interested in this project. Available to start immediately and finish as soon as possible. My bid is for fast professional service More

$750 CAD in 7 days
(10 Reviews)
4.8
pbq

I have solution for you. please check it in PM

$500 CAD in 7 days
(6 Reviews)
4.0
bazzinfotech

**************************************** Please Check PMB for more details.Thanks. ****************************************

$500 CAD in 14 days
(2 Reviews)
3.0
santa99

consider it done . !!! check pm.

$100 CAD in 7 days
(0 Reviews)
0.0
JoshZERO

Hello, My name is Joshua Riddle and I am seasoned developer with the javascript, web, and google skills required to provide you with what you need. You can acxompish what you want with google alone as a platform. I hav More

$197.4 CAD in 7 days
(0 Reviews)
0.0
alucab

Dear Sir, I'm new to the platform but I have an extensive experience in software development. I think I can help you .

$300 CAD in 15 days
(0 Reviews)
0.0