Problem: Morning Battle with "Incorrect Orders"
One of the most frustrating tasks in running a small B2B team is verifying order data submitted by buyers.
Quantity was supposed to be "1000" but "10000" was entered
Product code should be "AB-123" but "AB-1234" was filled in
Line breaks got messed up when copy-pasting shipping addresses
Every morning when checking emails, the team lead had to send messages to buyers saying "Please double-check this." While waiting for corrections, order processing was delayed and buyers grew frustrated.
Before Situation:
• About 25~30% of daily order forms needed re-verification
• Each error required manual email review followed by buyer contact
• Average wait time for resubmission: over 12 hours
• Approximately 35% of team work time consumed by this validation task
Solution: Google Form + Conditional Validation Rules
Added data validation logic to the existing Google Form. Used Claude Code to connect an automated script that runs every time a form response is submitted.
Automated Validation Rules:
✓ Quantity range check (minimum 10, maximum 50,000)
✓ Product code format (must be exactly "XX-XXXX" format)
✓ Email address validity
✓ Shipping address length (minimum 15 characters)
✓ Delivery date is after today
✓ Phone number digit count validation
When a buyer submits the form, if conditions aren't met, an error message appears immediately: "Please review and resubmit." The form won't submit until corrections are made.
After Results
Operational Metrics Shift:
• Orders requiring re-verification: 30% → 3% (90% reduction)
• Error detection time: After email review → Real-time at form stage
• Buyer response wait time: Average 12 hours → 0 hours (instant completion)
• Team time spent on validation: 12 hours/week → 1 hour/week
Team Feedback:
In the first week, some buyers reached out saying "The form won't submit." But over 80% of buyers read the error message and corrected it themselves. The rest were resolved with a single explanatory email.
Most surprisingly, by week two, buyers started saying, "The form is strict, which helps us avoid mistakes. Thank you." Both sides built mutual trust.
Minor Setback
Initially, validation conditions were set too strictly. For example, phone numbers were restricted to exactly 10 digits, which blocked buyers entering international formats (like +82 country codes). After receiving several corrections, we relaxed the rule to "9-15 digits," and everything ran smoothly after that.
Next Phase
We're planning to integrate real-time inventory status into the form. When buyers place orders, they'll see current stock levels directly. This way they can decide "This item only has 500 units left" and adjust quantities accordingly.