**Please Read Instructions and Attachments Carefully **
I want to create an order form application that will allow me to scan barcodes (via a Bluetooth scanner) into a spreadsheet/Excel File. When each barcode is scanned into the form I want the corresponding item code, price and description to automatically appear in the cells next to the barcode (similar to the Excel “Lookup” function). This will be read (“looked-up from) a large Master CSV file containing all the item codes, descriptions and prices which will be updated regularly and downloaded to the app automatically when connected to the internet (this Master CSV file will not be visible on the app, it will be hidden)
After the barcode is scanned and the item code/description and price appears I will then enter the Quantity manually to an empty cell on the same row.
Then I will scan the next barcode and the same will happen for the row below . This will continue until the order is finished.
When I am finished the order it will save automatically to the app (under the customers name and date)
It will also be offer the function to email the CSV form as an attachment to a specific email. (When connected to the internet these emails will then send)
Please study all the requirements as seen in the attachments.
I am open to suggestions and simpler methods put forward by the programmer however these MUST BE put forward before the project is Awarded - therefore please read through the instructions carefully and I would be delighted to supply further information on request.
Please include your proposal and thought/suggestions in an email before awarding prject.