Construction CRM

Track clients from first site visit to signed contract, keep a vetted contractor roster with insurance expiry, and schedule every job.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Construction

Tables

Clients, Contractors, Jobs

Fields

33

Views

grid, kanban, form, timeline

Tables, columns and sample rows

The 3 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Clients

12 fields · 5 sample rows

  • Clients (Grid)
  • Sales pipeline (Kanban)
  • Request a quote (Form)
ClientTextPhonePhoneEmailEmailSite addressAddressProject typeSingle selectEstimated valueCurrencySourceSingle selectStageSingle selectNext follow-upDateJobsLink to another tableContracted valueRollupNotesLong text
Mr. & Mrs. Bhosale+91 98220 31313[email protected]Plot 18, Baner, Pune, Maharashtra, IndiaNew build₹95,00,000ArchitectContractedBhosale villa — structure, Bhosale villa — interiors₹1,16,00,000
Café Mocha Koregaon Park+91 98500 42424[email protected]Interior fit-out₹28,00,000InstagramNegotiation21 Nov 2026₹0
Rebecca Hughes+91 97600 53535[email protected]Renovation₹14,00,000ReferralEstimate sent24 Nov 2026₹0
Shinde Warehousing+91 98810 64646Commercial₹2,20,00,000WebsiteSite visit20 Nov 2026₹0
Vivek Malhotra+91 99220 75757Extension₹18,00,000Site boardContractedMalhotra first-floor extension₹17,50,000
Field details
Client · Text
Phone · Phone
Email · Email
Site address · Address
Project type · Single select
New build, Renovation, Extension, Interior fit-out, Commercial
Estimated value · Currency
INR
Source · Single select
Referral, Website, Architect, Site board, Instagram
Stage · Single select
Enquiry, Site visit, Estimate sent, Negotiation, Contracted, Lost
Next follow-up · Date
Jobs · Link to another table
Links to Jobs
Contracted value · Rollup
sum of Contract value via Jobs
Notes · Long text

Form view “Request a site visit” asks for: Client, Phone, Email, Site address, Project type, Notes.

Contractors

11 fields · 4 sample rows

  • Roster (Grid)
ContractorTextTradeSingle selectContact personTextPhonePhoneLicence no.TextInsurance expiryDateInsuranceFormulaDay rateCurrencyRatingRatingJobsLink to another tableActive jobsCount
Volt ElectricalsElectricalSanjay Pawar+91 98230 11111MH-EL-22/44717 Jun 2027Valid₹4,5005/5Bhosale villa — structure1
AquaFix PlumbingPlumbingRafiq Shaikh+91 98230 222227 Dec 2026Expiring soon₹3,8004/5Bhosale villa — structure1
WoodCraft InteriorsCarpentryJoseph Pereira+91 98230 333339 Nov 2026Expired₹4,2004/5Malhotra first-floor extension, Bhosale villa — interiors2
ColourPro PaintersDrywall & paintingGanesh Jadhav+91 98230 444445 Oct 2027Valid₹2,8003/5Malhotra first-floor extension1
Field details
Contractor · Text
Trade · Single select
Civil, Electrical, Plumbing, HVAC, Carpentry, Drywall & painting, Flooring & tiling, Glazing and 1 more
Contact person · Text
Phone · Phone
Licence no. · Text
Insurance expiry · Date
Insurance · Formula
IF({Insurance expiry}, IF(DATETIME_DIFF({Insurance expiry}, TODAY(), 'days') < 0, 'Expired', IF(DATETIME_DIFF({Insurance expiry}, TODAY(), 'days') <= 30, 'Expiring soon', 'Valid')), 'Missing')
Day rate · Currency
INR
Rating · Rating
Jobs · Link to another table
Links to Jobs
Active jobs · Count

Jobs

10 fields · 3 sample rows

  • Jobs (Grid)
  • Schedule (Timeline)
  • Job board (Kanban)
JobTextClientLink to another tableContractorsLink to another tableProject managerTextStartDateFinishDateDuration (days)FormulaContract valueCurrencyStatusSingle selectService notesLong text
Bhosale villa — structureMr. & Mrs. BhosaleVolt Electricals, AquaFix PlumbingNikhil5 Oct 20262 Feb 2027120₹92,00,000In progress
Malhotra first-floor extensionVivek MalhotraWoodCraft Interiors, ColourPro PaintersAyesha29 Nov 202613 Jan 202745₹17,50,000Scheduled
Bhosale villa — interiorsMr. & Mrs. BhosaleWoodCraft InteriorsNikhil7 Feb 202729 Mar 202750₹24,00,000Scheduled
Field details
Job · Text
Client · Link to another table
Links to Clients
Contractors · Link to another table
Links to Contractors
Project manager · Text
Start · Date
Finish · Date
Duration (days) · Formula
IF(AND({Finish}, {Start}), DATETIME_DIFF({Finish}, {Start}, 'days'), BLANK())
Contract value · Currency
INR
Status · Single select
Scheduled, In progress, On hold, Snagging, Completed
Service notes · Long text

Construction CRM: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates