Ditutup

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

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.

Kemahiran: CRM, Pentadbiran Pangkalan Data, Kejuruteraan Perisian, Antara Muka Pengguna / Seni Bina Maklumat

Lihat lebih lanjut: crm cloud, google docs grid widget, google forms crm, google forms pull data, trying function, using google spreadsheet, product pricing spreadsheet, html spreadsheet widget, grid design, google system architecture, google spreadsheet html, google app engine pricing, design html widget, design app scratch, app design costs, crm spreadsheet design, spreadsheet google, google docs crm, google cloud engine, app costs, spreadsheet design, pull data, google spreadsheets, google forms, customer spreadsheet

Tentang Majikan:
( 6 ulasan ) Vancouver, Canada

ID Projek: #4112766

9 pekerja bebas membida secara purata $527 untuk pekerjaan ini

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 dalam 7 hari
(21 Ulasan)
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 Lagi

$750 CAD dalam 30 hari
(5 Ulasan)
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 Lagi

$1300 CAD dalam 42 hari
(11 Ulasan)
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 Lagi

$750 CAD dalam 7 hari
(10 Ulasan)
4.8
pbq

I have solution for you. please check it in PM

$500 CAD dalam 7 hari
(6 Ulasan)
4.0
bazzinfotech

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

$500 CAD dalam 14 hari
(2 Ulasan)
3.0
santa99

consider it done . !!! check pm.

$100 CAD dalam 7 hari
(0 Ulasan)
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 Lagi

$197.4 CAD dalam 7 hari
(0 Ulasan)
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 dalam 15 hari
(0 Ulasan)
0.0