We currently use the attached file for collecting customer special orders, we use google apps for business in our company and want to create a google intranet site for staff to record the special order and then track the various steps / status of the order. Steps / status include: New, Ordered, Received, Customer notified, Customer picked up and closed
Hi, can help.
Yes it's possible create orders tracking dashboard system base on google spreadsheets, integrate it into google sites and automated all with google scripts.
Project will consists from three main parts and can be extended:
I. Database development base on google spreadsheet
II. Spreadsheet company data management logic
III. Dashboard front-end/visualization of the google sites development and connection it with spreadsheet database layer.
Each part development will costs 250 CAD
Few questions:
1. how you plan input company data? Via form or directly into the google sheet?
2. do you plan to use/include time notificators for deadline of order status?
Regards, Viktor
I'm new to this site; so I want to get a few small project under my belt. I'm willing to do this cheap. 13 years PHP & 7 Years Magento experience. I'd love to discuss this more; not sure how much help you need.