I'm new to Freelancer and this is my first project. Thanks for taking the time to read about our quest to automate this processes in our business.
Our company uses Google Smartsheet platform to track information about our Work orders/Job numbers for the transportation services we provide.
Each row in the google smartsheet has a unique sequential work order/Run# number assigned to it (Eg. RUN# VTIA0905). Each row in has information about the load, customer details and truck assigned to undertake the delivery. This smartsheet forms the master data for our company, mainly due to the webform that effortlessly collect the data while we are on the move from our mobiles.
We use goCanvas platform for mobile data collection for guys in the field. Data from Smartsheet is currently being exported into excel, saved as CSV and then uploaded to the Canvas cloud to work as reference data for the Canvas mobile apps.
This function is currently done manually causing delays when Canvas mobile applications become outdated any time a new job is added to smart sheet and the reference file is not updated in Canvas. .
We are looking for a solution that monitors Smartsheet for data changes and updates the CSV reference data in Canvas accordingly. Alternatively this solution could run and update every minute or so.
The solution we are looking for:
• Must extract run# information from Smartsheet, using the Smartsheet API or similar, to determine if the sheet has changed since the last time it was checked for changes. If it has, the smartsheet will need to be exported and saved as cvs file to be uploaded as Canvas reference data.
We have a Microsoft server hosted and could run some form of middleware software on this cloud based server, to make the updates of the reference data work.
Our ultimate goal is to build a proprietary system that may run on its own data collection software.