One-time setup to connect the vessel report form to the Miami office dashboard. Takes about 10 minutes. Free — uses Google Sheets.
This will store all submitted reports
Go to sheets.google.com and create a new blank spreadsheet.
Name it something like "Anglo Eastern — Hotel Director Reports".
Inside your Google Sheet
In your Google Sheet, click Extensions → Apps Script in the top menu.
A new tab will open with the Apps Script editor. Delete all existing code in the editor.
Copy from the apps-script.gs file
Open the file apps-script.gs (included with this platform). Copy the entire contents and paste it into the Apps Script editor.
Click the 💾 Save button (or Ctrl+S) in the Apps Script editor.
This creates the URL that connects everything
In the Apps Script editor, click Deploy → New deployment.
In the dialog that appears:
Click Deploy. Google will ask you to authorise the script — click Authorise access and follow the prompts.
After deployment, you will see a Web App URL that looks like:
Copy this URL — you will need it in the next step.
Submit page (vessel) and View page (Miami)
The URL is saved automatically in the browser once you paste it. You only need to do this once per device.
On the vessel: Open the Submit Report page → paste the URL in the yellow banner at the top.
In Miami: Open the View Dashboard page → paste the same URL in the yellow banner → click Load Reports.
Submit a test report to verify everything works
On the vessel side, open Submit Report, fill in the vessel name and date, then click Submit Report to Miami.
On the Miami side, open View Dashboard and click Load Reports. The test report should appear within seconds.
You can also check the Google Sheet directly — a new row should have been added to the Reports tab.
What each party does every day
🚢 Onboard (Hotel Director):
1. Open Submit Report page
2. Fill in all sections (Cape Denison, The Hut, Crew Mess, Summary)
3. Click Submit Report to Miami
4. Done — takes about 5–10 minutes
🏢 Miami Office:
1. Open View Dashboard page
2. Click ↻ Refresh to see latest reports
3. Click any report card to expand and read full details
4. Filter by vessel name or date as needed