Google Sheets Work Order Automation

I'm looking for assistance in creating a Google Sheets script to streamline my work order process. The project involves setting up a work order form that auto-generates sequential work order numbers and maintaining a comprehensive log sheet for easy access to all work orders.

Requirements:
- Auto-populate work order numbers in a sequential format.
- Work order form should include:
- Client details
- Job description
- Log sheet should have:
- Search functionality
- Filtering options

Ideal Skills and Experience:
- Proficient in Google Sheets scripting
- Experience with automated data entry and log management
- Strong understanding of Google Sheets functions and features

Looking forward to your expertise to enhance my workflow!