Trigger · 1 of 16Every minute
A scheduled pass runs every minute. Editing a document does not start one; the next pass picks the edit up.
- Tool
- Ops dashboard
- Hands on
- A pass to run
Step · 2 of 16Read active builds
Every active build is read with its folder and its current order-sheet link.
- Tool
- Postgres
- Hands on
- Builds to check
Decision · 3 of 16Folder scanning on?
A build can be set to manual or detached. Those are left alone until a person turns folder scanning back on.
- Tool
- Ops dashboard
- Hands on
- Scan it, or leave it
- Ways out
- On: Read the Drive folder · Off: Leave the build as it is
Step · 4 of 16Read the Drive folder
The folder's identity, its shared-drive access, whether it is in the trash, and every page of what it holds are checked.
- Tool
- Google Drive
- Hands on
- A full listing, or an error
Decision · 5 of 16Folder read in full?
A partial read is never trusted, so a link is never changed on half a listing.
- Tool
- Google Drive
- Hands on
- Match it, or keep the old link
- Ways out
- Yes: Which sheet to link? · No: Keep the old link
End · 6 of 16Leave the build as it is
No scan runs for this build, and nothing it holds changes.
- Tool
- Ops dashboard
- Leaves
- No scan for this build
Decision · 7 of 16Which sheet to link?
A sheet a person pinned wins while it is still valid; otherwise a single match is linked. A build sheet alone is never taken for an order sheet, and PDFs, Docs, Sheets and Office files all count.
- Tool
- Ops dashboard
- Hands on
- Link one, ask a person, or mark it missing
- Ways out
- One match: Save the link · Several: Ask for a choice · None: Mark the sheet missing
Step · 8 of 16Ask for a choice
The candidates are saved and the build shows that a choice is needed. Its live link is cleared until someone picks.
- Tool
- Postgres
- Hands on
- A choice waiting on the build
Step · 9 of 16Keep the old link
The previous link stays and the error is recorded against it, so a Drive hiccup never blanks a build.
- Tool
- Postgres
- Hands on
- The old link, flagged
Step · 10 of 16A person picks the sheet
An admin or editor opens the build's order-sheet manager and picks the right document.
- Tool
- A team member
- Hands on
- A chosen document
Step · 11 of 16Mark the sheet missing
With no match, an old link that no longer fits is cleared and the build is marked missing.
- Tool
- Postgres
- Hands on
- A missing status
Decision · 12 of 16Choice still current?
The choice is checked against the folder as it is now. If anything changed since the list was shown, the choice is turned back rather than written blind.
- Tool
- Ops dashboard
- Hands on
- Save it, or turn it back
- Ways out
- Yes: Save the link · Stale: Ask to refresh and retry
Step · 13 of 16Save the link
The chosen document's link is saved once it has been checked.
- Tool
- Postgres
- Hands on
- A verified link
End · 14 of 16Ask to refresh and retry
This attempt stops. The person refreshes the list and chooses again; nothing is written from a stale list.
- Tool
- Ops dashboard
- Leaves
- Nothing written
Step · 15 of 16Show it on the build
Open dashboards pick up the saved status within 15 seconds, and the build's other views follow on their normal refresh.
- Tool
- Ops dashboard
- Hands on
- The status on every build view
End · 16 of 16Wait for the next pass
This pass is done. A minute later the next one reads the folder again, so a change in Drive shows up on its own.
- Tool
- Ops dashboard
- Leaves
- The next scan in a minute