Visitor Log Template

A security visitor log with ID checks, badge numbers, vehicles and time on site, linked to the host each visitor came to see.

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

Log Sheets

Tables

Hosts, Visitor Log

Fields

20

Views

grid, form, calendar, dashboard

Tables, columns and sample rows

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

Hosts

6 fields · 4 sample rows

  • Hosts (Grid)
HostTextDepartmentSingle selectEmailEmailExtensionTextVisitsLink to another tableVisitor CountCount
Anita RaoSales[email protected]201Kunal Bose1
Vivek MenonHR[email protected]305Priyanka Nair1
Laura ChenEngineering[email protected]412Daniel Smith1
Facilities DeskFacilities[email protected]100Ravi Electricals crew, Amazon courier2
Field details
Host · Text
Department · Single select
Sales, HR, Finance, Engineering, Facilities
Email · Email
Extension · Text
Visits · Link to another table
Links to Visitor Log
Visitor Count · Count

Visitor Log

14 fields · 5 sample rows

  • Visitor log (Grid)
  • Visitor registration (Form)
  • Calendar (Calendar)
  • Footfall (Dashboard)
VisitorTextCompanyTextPhonePhoneVisitor TypeSingle selectHostLink to another tableDateDateTime InDurationTime OutDurationHours On SiteFormulaID TypeSingle selectID Last 4TextVehicle No.TextBadge #TextSignatureSignature
Kunal BoseZenith Partners+91 98300 12121ClientAnita Rao19 Nov 202610:0511:401.58Driving licence4471KA01 MJ 2020G-12
Priyanka Nair+91 98950 34343IntervieweeVivek Menon19 Nov 202611:00Aadhaar9087G-13
Ravi Electricals crewRavi Electricals+91 99860 56565ContractorFacilities Desk19 Nov 20268:30Company IDKA05 TT 7766C-04
Daniel SmithCloudway Inc.VendorLaura Chen18 Nov 202614:0016:152.25Passport5512G-08
Amazon courierAmazonDeliveryFacilities Desk18 Nov 202612:2012:300.17Company ID
Field details
Visitor · Text
Company · Text
Phone · Phone
Visitor Type · Single select
Guest, Client, Contractor, Vendor, Interviewee, Delivery, Government / audit
Host · Link to another table
Links to Hosts
Date · Date
Time In · Duration
Time Out · Duration
Hours On Site · Formula
IF(AND({Time In}, {Time Out}), ROUND(({Time Out} - {Time In}) / 3600, 2), BLANK())
ID Type · Single select
Aadhaar, Driving licence, Passport, Company ID, None
ID Last 4 · Text
Vehicle No. · Text
Badge # · Text
Signature · Signature

Form view “Visitor registration” asks for: Visitor, Company, Phone, Visitor Type, Host, Date, Time In, ID Type, ID Last 4, Vehicle No., Signature.

Visitor Log Template: 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