Business System — Database

Set your password

You're here from the link in your email. Choose a password — you'll use it with your email address to sign in from now on.

Sign in

First time here, or forgot your password?

Enter your TrussGuy email and we'll send you a link. Open that link on this same device — it brings you back here to set your password. The link works for one hour.

Business System — Database
v2.17

Projects — Status Board

One pane per status, in the order a project flows through them. Each pane lists the projects waiting on that step — click a project to open its Project Information form.

Lost and Cancelled projects get no pane of their own — they open here as a list, so the closed-out sets never crowd the board.

Projects — List View

The status filter is the centerpiece — pick a status to see only the projects waiting on that step. Click a Project ID to open the full Project Information form.

Project IDNameClientCreation DateBid DueStatusTimer

← All Projects  ›  P-1042

Project Information — P-1042

Statuses are calculated, never typed. Checkpoints stamp date + initials automatically.

Project Status (calculated)
Plans Not Reviewed
Project Timer: 5 Days / 12 Hours

Site Specific Information

Options (multi-select)

Plans

Each plans record is one version — the first is Plans 1.0, the next Plans 2.0, and so on. Creating a record is what creates the next version, and the new record is stamped as received (date + who received it) the moment it is created. Drop the plans PDF into a record's window and the file is stored with that version.

Project Tracking — Checkpoints

Try it: tick Plans Reviewed → status becomes “Plans Not Redacted”. Tick Plans Redacted → “Redaction Not Checked”. Tick all three → “Materials Not Created”.

Quote Tracking

Each record is its own column — the newest sits at the far left and older records shift right.
Q-501Created: 10/16/2026Initials: BH
%
$

Materials

Each material gets its own RFQs to multiple suppliers, its own schedule, and supplier invoice. Click a material's ID to work its RFQs in the RFQs section below.
IDMaterialSelected SupplierProduct CostTotal CostScheduled DeliveryInvoice DueStatus

Project Completion — Checkpoints

Problem Tracking

IDCreation DateInitialsProblem DescriptionSupplier NotifiedClient ConfirmedResolved
PB-1210/17/2026BHDesign shows 2×6 top chord where plans call for 2×4 — awaiting supplier confirmation.

Project Notes

10/16/2026 · BHDesignHeel height confirmed at 12″ with designer at Apex Truss.
10/17/2026 · BHClientClient asked to hold delivery until lot grading is finished.
10/18/2026 · MBGeneralPlans are the revised set dated 10/10 — supersedes the September set.
Client 1 of 6

Client Details — Element Construction

Client #1042 · Charlottesville, VA area builder (sample record)

Relationship Status (calculated)
Never Sold

Client Information

Rule check: uncheck Active or check Do Not Contact and the date + initials stamp themselves — no typing. In the real app, deactivating a client also marks its contacts Not-Employed.

Addresses

ConfirmedActivePrimaryTypeStreet #Street NameCityStateZip
133Caggiano Dr.Gaffney29340

Social Media

Every social media presence for this company — Facebook, LinkedIn, Instagram, and the rest — with the profile address for each.

PlatformConfirmedWeb Address

Phones

ConfirmedActivePrimaryTypeValue

Emails

ConfirmedActivePrimaryTypeValue

Communication History

Every touch with this client — sent by a campaign, logged by hand, or imported from email history — is one Communication Event, newest first. This is the record Prospecting reads: no events here means Never Contacted.

DateDirectionMethodByOutcomeSummary

Projects

ProjectCreatedNameStatus

Contacts

A complete list of contacts with this client listed as their employer. Contacts with an Employment Status of "Employed" appear above those with a status of "Not-Employed".

NameTitleStatusEmailPhone

Client Notes

09/30/2026 · BHGeneralMet at Upstate builders breakfast — builds 15–20 custom homes a year, mostly Greenville / Spartanburg.
10/12/2026 · MBOutreachIntroduction sent. Prefers email first, then a call.

Other Sample Clients (click to open that client)

Contact 1 of 13

Contact Details — Sam Biber

Project Manager · Element Construction (sample record)

Contact Information

Calculated — Display Only

Employer
Element Construction
Title
Project Manager
Phone (Primary first)
(864) 555-0148
Address
133 Caggiano Dr., Gaffney, SC 29340
Email (Confirmed + Active only)
sbiber@elementconstruction.example
Relationship Status
Attempting Communication

These fields are never typed — they are calculated from Employment, Titles, and the flagged phone / email / address rows below.

Phones

ConfirmedActivePrimaryTypeValue

Emails

ConfirmedActivePrimaryTypeValueStatus

Addresses

ConfirmedActivePrimaryTypeValue

Social Media

CompanyConfirmedWeb Address
linkedin.com/in/sam-biber (sample)

Employment & Title (per employer)

ClientJob TitleStatusStatus DateConfirmed
+ New Employment row — a title is recorded per employer, so the same person can be PM at one builder and Owner at another.

Other sample contacts: Peter Piper — Office Manager · Lonnie Donegan — Site Superintendent · Richard Davis — Project Manager

Supplier Work

SupplierStatusDesigner

Check Designer for each supplier this person designs for — that is what puts them in the RFQ Designer Contact list for that supplier.

Contact Notes

10/05/2026 · BHGeneralDecision-maker on truss orders for all Element custom homes. Wants quotes broken out by house.

Communication History

Every touch with this contact — sent by a campaign, logged by hand, or imported from email history — is one Communication Event, newest first. This is the record Prospecting reads: no events here means Never Contacted.

DateDirectionMethodByOutcomeSummary

Project Records

Project IDDateProject NameStatus

Other Contacts at Element Construction

NameJob TitleEmploymentRelationship

Prospecting

Search criteria combine with the logic filter. Days-since fields narrow by how long it has been since the last quote or sale.

Results

Client IDClient NameType / SizeCreation DateRelationship StatusContact NameDays Since Quote / Sold

Outreach Campaign — Sam Biber

Campaign #C-208 · Communication Events below are generated from the recurrence — change any setting and watch them rebuild.

Campaign Status (calculated)
Ongoing

Campaign Settings

Repeat On
Ends

Auto-cancel rule (from your spec): if the contact leaves, either side goes Do Not Contact, or the client is deactivated, all future events are deleted and Cancel is checked automatically.

Communication Events (auto-generated)

IDContact DateMethodCompleteSkip

Utilities — Dropdown Lists

Every dropdown in the app is fed from one of these lists, so a new option can be added on the fly without leaving a form. Type a value and press Add to try it.

New Project

New RFQ