# theShip.pknw1.co.uk

# Links

[https://drive.google.com/drive/folders/1ITBmGc34FP1g0ZwtdvRStMzficGO11lL?usp=sharing](https://drive.google.com/drive/folders/1ITBmGc34FP1g0ZwtdvRStMzficGO11lL?usp=sharing)

Food Menu - [https://ship.pknw1.co.uk/food.html](https://ship.pknw1.co.uk/food.html)

configure via - [https://docs.google.com/spreadsheets/d/1j9B9KhiG49ZzxUS0qQnfQ67F52aT8S6Pw2Bqj4jMn2M/edit?gid=1856216985#gid=1856216985](https://docs.google.com/spreadsheets/d/1j9B9KhiG49ZzxUS0qQnfQ67F52aT8S6Pw2Bqj4jMn2M/edit?gid=1856216985#gid=1856216985)

[https://ship.pknw1.co.uk/events.html](https://ship.pknw1.co.uk/events.html)

[https://docs.google.com/spreadsheets/d/1\_VNCxdXZEtoN93X0\_ZKeeAWPXqaKEqSf5QpTpGqjz9o/edit?gid=352850717#gid=352850717](https://docs.google.com/spreadsheets/d/1_VNCxdXZEtoN93X0_ZKeeAWPXqaKEqSf5QpTpGqjz9o/edit?gid=352850717#gid=352850717)

[https://ship.pknw1.co.uk/reservations.html](https://ship.pknw1.co.uk/reservations.html)

[https://docs.google.com/spreadsheets/d/1S74pHxt2xKaAYuUrbIdmhJwcXqPkkJeFj1V8MQdlgIs/edit?gid=0#gid=0](https://docs.google.com/spreadsheets/d/1S74pHxt2xKaAYuUrbIdmhJwcXqPkkJeFj1V8MQdlgIs/edit?gid=0#gid=0)

# Home Page

<details id="bkmrk-home-page-fullscreen"><summary>Home Page Fullscreen</summary>

[![FireShot Capture 014 - Home - theship.pknw1.co.uk.jpg](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/scaled-1680-/fireshot-capture-014-home-theship-pknw1-co-uk.jpg)](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/fireshot-capture-014-home-theship-pknw1-co-uk.jpg)

</details><table id="bkmrk-1.-%C2%A0-open-google-dri" style="border-collapse:collapse;width:100%;height:1512.42px;"><colgroup><col style="width:9.65435%;"></col><col style="width:90.3457%;"></col></colgroup><tbody><tr style="height:29.8px;"><td style="height:29.8px;">  
</td><td style="height:29.8px;">  
</td></tr><tr style="height:257.383px;"><td style="height:257.383px;">1.</td><td style="height:257.383px;">[![Screenshot 2025-07-12 at 01.57.00.png](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/scaled-1680-/screenshot-2025-07-12-at-01-57-00.png)](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/screenshot-2025-07-12-at-01-57-00.png)

Open Google Drive Folder

</td></tr><tr style="height:240.583px;"><td style="height:240.583px;">  
</td><td style="height:240.583px;">[![Screenshot 2025-07-12 at 01.58.40.png](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/scaled-1680-/screenshot-2025-07-12-at-01-58-40.png)](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/screenshot-2025-07-12-at-01-58-40.png)

Select Bookings

</td></tr><tr style="height:266.133px;"><td style="height:266.133px;">  
</td><td style="height:266.133px;">[![Screenshot 2025-07-12 at 02.23.24.png](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/scaled-1680-/screenshot-2025-07-12-at-02-23-24.png)](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/screenshot-2025-07-12-at-02-23-24.png)</td></tr><tr style="height:48.25px;"><td style="height:48.25px;">  
</td><td style="height:48.25px;">[![Screenshot 2025-07-12 at 02.23.39.png](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/scaled-1680-/screenshot-2025-07-12-at-02-23-39.png)](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/screenshot-2025-07-12-at-02-23-39.png)</td></tr><tr style="height:551.067px;"><td style="height:551.067px;">  
</td><td style="height:551.067px;">[![Screenshot 2025-07-12 at 02.25.24.png](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/scaled-1680-/screenshot-2025-07-12-at-02-25-24.png)](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/screenshot-2025-07-12-at-02-25-24.png)</td></tr><tr style="height:29.8px;"><td style="height:29.8px;">  
</td><td style="height:29.8px;">[![Screenshot 2025-07-12 at 01.53.37.png](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/scaled-1680-/screenshot-2025-07-12-at-01-53-37.png)](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/screenshot-2025-07-12-at-01-53-37.png)</td></tr><tr style="height:29.8px;"><td style="height:29.8px;">  
</td><td style="height:29.8px;">[![Screenshot 2025-07-12 at 01.53.56.png](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/scaled-1680-/screenshot-2025-07-12-at-01-53-56.png)](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/screenshot-2025-07-12-at-01-53-56.png)</td></tr><tr style="height:29.8px;"><td style="height:29.8px;">  
</td><td style="height:29.8px;">[![Screenshot 2025-07-12 at 01.54.36.png](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/scaled-1680-/screenshot-2025-07-12-at-01-54-36.png)](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/screenshot-2025-07-12-at-01-54-36.png)  
</td></tr><tr style="height:29.8px;"><td style="height:29.8px;">  
</td><td style="height:29.8px;">  
</td></tr></tbody></table>

<table id="bkmrk--1" style="border-collapse:collapse;width:100%;"><colgroup><col style="width:14.5411%;"></col><col style="width:85.4589%;"></col></colgroup><tbody><tr><td>  
</td><td>  
</td></tr><tr><td>  
</td><td>[![Screenshot 2025-07-12 at 03.15.38.jpg](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/scaled-1680-/screenshot-2025-07-12-at-03-15-38.jpg)](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/screenshot-2025-07-12-at-03-15-38.jpg)</td></tr><tr><td>  
</td><td>[![Screenshot 2025-07-12 at 03.15.28.jpg](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/scaled-1680-/screenshot-2025-07-12-at-03-15-28.jpg)](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/screenshot-2025-07-12-at-03-15-28.jpg)</td></tr><tr><td>  
</td><td>[![Screenshot 2025-07-12 at 03.15.50.jpg](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/scaled-1680-/screenshot-2025-07-12-at-03-15-50.jpg)](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/screenshot-2025-07-12-at-03-15-50.jpg)</td></tr><tr><td>  
</td><td>  
</td></tr><tr><td>  
</td><td>  
</td></tr><tr><td>  
</td><td>  
</td></tr><tr><td>  
</td><td>  
</td></tr><tr><td>  
</td><td>  
</td></tr></tbody></table>

<table id="bkmrk--3" style="border-collapse:collapse;width:100%;"><colgroup><col style="width:12.8725%;"></col><col style="width:87.1275%;"></col></colgroup><tbody><tr><td>  
</td><td>  
</td></tr><tr><td>  
</td><td>  
</td></tr><tr><td>  
</td><td>  
</td></tr><tr><td>  
</td><td>  
</td></tr><tr><td>  
</td><td>  
</td></tr><tr><td>  
</td><td>  
</td></tr><tr><td>  
</td><td>  
</td></tr></tbody></table>

# Summary

### A Reactive website containing content which can be user modified in real time through one of three Google Sheets

- #### Food Menu - live update menu on the website
- #### Events - pre-fill upcoming events andonly display upcoming and not previous events
- #### Bookings - Receive and manage online bookings

### Food Menu

[![FireShot Capture 015 - Food - theship.pknw1.co.ukb.jpg](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/scaled-1680-/fireshot-capture-015-food-theship-pknw1-co-ukb.jpg)](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/fireshot-capture-015-food-theship-pknw1-co-ukb.jpg)

#### Live Update Menu

[![Screenshot 2025-07-12 at 03.44.35.jpg](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/scaled-1680-/screenshot-2025-07-12-at-03-44-35.jpg)](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/screenshot-2025-07-12-at-03-44-35.jpg)

### Bookings

[![FireShot Capture 016 - Reservations - theship.pknw1.co.uk.jpg](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/scaled-1680-/fireshot-capture-016-reservations-theship-pknw1-co-uk.jpg)](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/fireshot-capture-016-reservations-theship-pknw1-co-uk.jpg)

#### Bookings Summary

[![Screenshot 2025-07-12 at 03.40.40.jpg](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/scaled-1680-/screenshot-2025-07-12-at-03-40-40.jpg)](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/screenshot-2025-07-12-at-03-40-40.jpg)

#### Bookings Today View

[![Screenshot 2025-07-12 at 03.40.54.jpg](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/scaled-1680-/screenshot-2025-07-12-at-03-40-54.jpg)](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/screenshot-2025-07-12-at-03-40-54.jpg)

#### Bookings Tomorrow View

[![Screenshot 2025-07-12 at 03.40.58.jpg](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/scaled-1680-/screenshot-2025-07-12-at-03-40-58.jpg)](https://bookstack.notflix.pknw1.co.uk/uploads/images/gallery/2025-07/screenshot-2025-07-12-at-03-40-58.jpg)

Food Menu

Live update the food menu in Google Sheets spreadsheet

Accept Bookings

- Submitted form updates booking in Google Sheets 
    - Auto Process Confirmaton emails
    - Update appropriate Google Sheet with details (Food, Group Bookings etc)
- Google Shets Bookings Sheet 
    - Opens to summary for roday and tomorrow booking numbers
    - Select Today for a current list
    - Print to table
- Bookings Sheet also has built in functions: 
    - Cleanup - moves all historic bookings to History sheet
    - Send Confirmation Emails
    - Print today summary

Manage Events

- Update Sports Tab updates the Live Sport Page
- Regular Events updates recurring events on Entertainment Page
- Live Entertainment updates on Entertainment Page