I need a database & mobile app to be created where I can enter the below details:
1. Customer Name
2. Phone (H):
5. Delivery Option : (radio button to select “Pick-up” or “Delivery”)
6. Address: (if delivery option is “Delivery” then should ask to put address)
a. Address Line 1
b. Address Line 2
7. Date of Delivery:
8. Time of Delivery:
9. Order: (Drop down list – details will be provided)
10. Pre-Payment: (check-box)
11. Source of Referral:
With delivery date and time I need build in a logic to be put in place. If there is already and order in that time slot then it should not allow to book the order, and should give them option of next available time slot. (Order interval will be 30min). Order cannot be placed within 7 days, if this is the case then it should give a prompt to contact us to place order.
I also need 4 disclaimer be put in the app function only.
However I should be able override this if needed.
With app, I should have page which tells about my company, facebook link, order and contact page.
Also there should be option, where I can block out dates, so no orders can be placed during that period.
Also need a to be able pull data into excel format for my reporting