As a first project I would like a simple order dispatchment app developed that allows for data to be edited by way of a UI in a Google Doc Spreedsheet.
Requirements below and mockup attached.
1) I have a Google spreed sheet with orders listed that were placed. I want to record:
a) Who packed the order
b) The time the order was packed
c) The tracking number
2) The App will pop up when called
3) The user will enter their name in the correct text field
4) The order number will be inserted into the relevant text field
5) Once the order number is inserted and tab is pressed the app must search for that order.
6) If the status is already "dispatched" a red error message should appear saying "Order is marked as dispatched"
7) If there is no error message the tracking number number text field will be available for editing
8) The order details will be displayed below the text fields
Name: Azraa Mohamed
Brand: Plum
No. of Items: 2
9) Once the tracking number is inserted a button called "submit" will be available
10) If submit is clicked it will write the name of the person who user's name, the time and the reference number. The order number field and tracking number will be cleared but the users name will remain.
11) Multiple entries can be edited in a single go.
12) The app is closed by clicking the "close" button
13) I need to be able to access the scripts in my companies closed network. I will probably just take the code and copy and paste
I want to hire someone by the hour as this is just a small test project BUT please tell me exactly how long the above project will take.
Please indicate in your bid that you understand the above requirements and don't just send me some generic response.
Thanks