Contact person: Business Client

Phone:Show

Email:Show

Location: Blantyre, Malawi

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"I run several stores and need a quick Google Sheets solution that lets each salesman record daily sales while keeping the history completely hidden from them.

Current requirements
• Access level must be “Only able to enter data.” No one should ever view or edit past rows except me.
• When a salesman opens the file, he should see a clean input area where he:
– Picks the date via “Select from a calendar dropdown.”
– Enters the “Date & Sales Amount” (plus chooses his store number if needed).
• The script should default to today’s date but also allow a back-dated entry if the previous day was missed.
• Every submission is silently copied to a protected master sheet that I alone can see. That master sheet must group results by Store 1-5 so I can review complete monthly totals.

Tech notes
– Google Apps Script or another native method is fine as long as it works on both desktop and mobile.
– I’ll need clear comments or a short setup guide so I can add more stores or users later.
– Speed matters: I’d like a functional draft as soon as possible because additional automation and reporting upgrades will follow.

Tell me the approach you’d use and your estimated turnaround for delivering this first version." (client-provided description)