Troubleshooting

Find the symptom, open it.

Setting up

One of three things:

You did not reload. The menu is added when the spreadsheet opens.
The code was not saved. Extensions → Apps Script, hit save, reload.
The spreadsheet is in Office mode. If the title bar says .XLSX, Apps Script cannot attach. Redo step 1 via File → Import → Replace spreadsheet.

"Google hasn't verified this app"

Expected. It is your own script and was never submitted for review.

Advanced → Go to Training log (unsafe) → Allow.

It asks only to read and write the spreadsheet it is attached to, and to show its own web page.

"SyntaxError: Identifier 'CFG' has already been declared"

Something is declared twice, which stops the whole script from parsing — so every link shows this until it is fixed. Two causes:

A second .gs file. Apps Script joins every .gs file into one shared scope, so two copies of Code.gs collide even though each looks fine alone. The Files list on the left should hold exactly two entries:

   Files
     Code.gs        ← all the server code
     Index.html     ← the whole interface

Delete any other .gs — a Code 2.gs, or a new file pasted into instead of replacing the original.

Pasted twice into one file. Click Code.gs, select all (Ctrl/Cmd + A), delete, then paste once. Ctrl/Cmd + F for const CFG should find a single match.

Then save and redeploy — Deploy → Manage deployments → pencil → Version: New version. Saving alone leaves the broken version being served.

The same message with another name — COL, WIDTH, HEADERS — has the same cause and the same fix.

"Sorry, unable to open the file at present"

The link points at a deployment that is not live.

   ✓  https://script.google.com/macros/s/AKfy…/exec     share this
   ✗  https://script.google.com/macros/s/AKfy…/dev      owner-only test link

It is the /dev link — the editor’s test link, useless to anyone else.
The stored link is stale. A new deployment mints a new URL. Run Training → Set web app link and paste the current one from Deploy → Manage deployments.
Nothing is deployed. Saving is not deploying — see step 3.

The app cannot work this URL out reliably for itself, which is why it asks you to paste it once.

The admin link says "Read only"

The key is missing or mangled. It must end ?key= + the key, nothing after:

   ✓  …/exec?key=a1b2c3d4e5f6g7h8
   ✗  …/exec?key=a1b2c3d4e5f6g7h8/

Get a fresh copy from Training → Show shareable links. Chat apps and calendar invites are the usual culprits — they shorten links and drop the query string.

Changes to the code are not showing up

Saving in the editor does not change what the links serve; a deployment is pinned to a version.

Deploy → Manage deployments → pencil → Version: New version → Deploy.

The sidebar (Training → Open entry form) always runs the latest saved code, which is why something can work there and not on the link.

During a session

The bar says “N changes not saved yet”

Normal on patchy wifi, and nothing to act on. The changes are queued and being retried — on reconnect, on returning to the tab, and on a backoff up to 30 seconds. Retry now forces an attempt.

Keep training. The numbers on screen are what you entered.

Do not close the tab while it is amber, and expect set counts, new exercises and Delete this session to be refused until it clears — they move rows around underneath the pending writes.

"Not saved: row 14 now holds something else"

A change was queued against a row that has since moved, usually because sets were added or removed elsewhere while it waited.

That one change is dropped and the session reloads, because replaying it would write onto whatever occupies the row now. Re-enter that one value. Nothing else is affected.

"Save failed …"

Message	Meaning	Fix
`Read-only view`	The key was rotated mid-session	Reopen the current admin link
`No sheet named "Log"`	The tab was renamed	Rename it back to exactly `Log`
`is no longer in that session`	A note was queued for an exercise since removed	Re-add it if you still want it

"No earlier Push to build from" / "No template rows for Push"

You picked a way to start that has nothing behind it. The app only offers sources it can see are available, so this usually means the page has been open a while — reload it.

Empty is always available. To make From the template work for a day, add rows for it to the Templates tab.

The numbers do not go up when I tap +

You are on the viewer link — check for the blue READ ONLY banner.
You tapped the number, not the button. Tapping selects it for typing.
It is at its limit. RPE clamps to 1–10, set counts to 0–10.

The sheet shows values I did not enter

Starting a session writes its proposed rows immediately, before anything is tapped — see the progression rule. Change them freely; each row is overwritten as you go.

Data and display

A record looks wrong

Records are read straight from the Log tab, so a wrong record means a wrong row. Usually a mistyped weight — 1000 for 100 wins every record it touches. Fix the row, then Training → Rebuild records.

Also worth knowing: two spellings of an exercise are two different exercises, and bodyweight work only ever produces a Most reps record.

The Records tab looks out of date

It is rewritten by Training → Rebuild records, by deleting a day, and by archiving — not while you are logging. Rebuilding it is a full pass over the Log, which is exactly what you do not want hanging off adding an exercise mid-session.

The Best strip and the ★ inside the app are always live regardless: they are worked out from the Log on every load and never read that tab.

An exercise picture does not show

Column D needs a direct link to the image file, public, ending in .jpg, .png, .gif or .webp.

A link to a page containing the image will not work. That is what the video column is for.
A Google Drive /view link is a page. Convert it to https://drive.google.com/thumbnail?id=FILE_ID&sz=w640 — see showing what the movement is.
Share it as Anyone with the link.

Reload the app after editing. A broken link shows no thumbnail rather than breaking the card.

The ▶ How to link is missing on an exercise

It comes from column F of the Exercises tab. Rows added by the app itself — a name typed into + Add exercise that was not on the list — get no link, because the app only appends the name.

Paste one in: a YouTube search works, and so does a link to a specific video.

Reload the app after editing; the list is read when the page loads.

A viewer sees no day buttons, or fewer than I do

Deliberate. The admin sees every day type they could start — Templates, everything logged, and Custom. A viewer sees only day types that have sessions, because the rest would be buttons that always answer “nothing logged”.

A brand-new log shows a viewer “Nothing has been logged yet.”

An exercise autocompletes to the wrong name, or not at all

The list is the Exercises tab, and anything typed into + Add exercise that is not already there gets appended — so a typo becomes a permanent suggestion. Delete the bad row from that tab.

Existing Log rows keep the name they were saved with; correct those separately if it matters.

Recovery

My whole log is empty

Almost always a template re-import. File → Import → Replace spreadsheet replaces the entire spreadsheet, and the template’s Log tab contains only headings — so importing it again to “update” wipes every session.

Recover it: File → Version history → See version history, pick a version from before the import, Restore this version.

Then update the way that does not destroy data — see updating the code. The code lives in Apps Script, so updating it never needs an import at all.

I deleted the wrong day, or removed the wrong exercise

The app has no undo. The spreadsheet does:

File → Version history → See version history, pick the version from before it happened, Restore this version.

If nothing else has happened since, Edit → Undo in the sheet works normally.

Typing in the sidebar goes into the spreadsheet instead

A Google Sheets quirk — the grid steals keyboard focus from a sidebar. The app fights back but not perfectly.

The sidebar is a test harness. Use the deployed link for real sessions.

The page is blank

Reload once. Still blank: open it in a private window. Apps Script web apps get confused when a browser is signed into several Google accounts at once.