Google Sheets and Docs Workflow Automation

Job ID: 39708583

Budget: $250 – $750 USD

I have a party rental company. We do apx 30-40 weekly events. Every week I have to make two new forms and some of the info is the same on both forms so I want to save time by having certain info auto populate from Form #1 to Form #2.
Form #1 WEEKLY EMPLOYEE CALENDAR (google sheet)
Form #2 TRUCK SCHEDULE (google document)

Objective:

After we fill in every event detail on Form #1 WEEKLY EMPLOYEE CALENDAR (google sheet), 5 cells from each event will be auto populated to Form #2 TRUCK SCHEDULE (google document). I assume you will need expertise in Google Apps Script in addition to google documents and google sheets. Open to discuss other ideas.

-I have the 2 forms that you'll use as templates, please maintain the same look for both forms.
-These forms will be used online so they must auto populate for remote users as well.
-All font styles and colors shd also be duplicated between documents.
- Auto populating is one directional from Form #1 to Form #2, not backwards, so anything directly entered in Form #2 will not auto populate Form #1.

-Need to be able to duplicate and use a new copy of both forms every week and save a copy of the old forms for our records.

Forms #1 & #2 will be set up to have 10 events for every day of the week M-F and Sun, and Sat will have 18 events.

The data that will be auto populated from Form #1 to Form #2 is:

-Client Name
-Venue
-Booked Time
-Package
-Instructions