Airtable vs. Lightning Tools Lightning Conductor

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Airtable
Score 8.6 out of 10
N/A
Airtable is a project management and collaboration platform designed to enable content pipelines, product management, events planning, user research, and more. It combines spreadsheet,database, calendar, and kanban functionality within one platform.
$24
per month per seat
Lightning Tools Lightning Conductor
Score 9.0 out of 10
Mid-Size Companies (51-1,000 employees)
The Lightning Conductor is a content aggregation tool for Microsoft SharePoint Online and Microsoft Teams. Users can build rich, modern content reports based upon SharePoint lists, SharePoint Search, Microsoft Graph or Microsoft 365 Groups. Content can be aggregated from lists and libraries, and other applications such as Planner, To Do, OneDrive, and Teams.
$2,200
per year per installation
Pricing
AirtableLightning Tools Lightning Conductor
Editions & Modules
Team
$24
per month per user
Business
$54
per month per user
Enterprise
Custom Pricing
Lightning Conductor WSP
From 1950
per year One WFE
Lightning Conductor Enterprise Edition
POA
per year Four or more WFE
Lightning Conductor Online
From 2200
per year per installation
Lightning Conductor Plus (Includes Data Viewer)
From 2500
per year per installation
Lightning Conductor Online Enterprise Edition (>10,000 users)
POA
per year per installation
Offerings
Pricing Offerings
AirtableLightning Tools Lightning Conductor
Free Trial
YesYes
Free/Freemium Version
YesNo
Premium Consulting/Integration Services
NoYes
Entry-level Setup FeeNo setup feeNo setup fee
Additional DetailsPrices stated are minimum per installation for "stock" products. $2.20 per user/year on top of base price. Enterprise editions can be amended to suit business needs if deemed necessary, additional costs incurred and TBD. All packages include free technical support. Free upgrades available to latest versions of tool as they are released. (online version)
More Pricing Information
Community Pulse
AirtableLightning Tools Lightning Conductor
Features
AirtableLightning Tools Lightning Conductor
Project Management
Comparison of Project Management features of Product A and Product B
Airtable
7.8
235 Ratings
1% above category average
Lightning Tools Lightning Conductor
8.6
2 Ratings
10% above category average
Task Management8.9199 Ratings8.82 Ratings
Resource Management8.0193 Ratings00 Ratings
Gantt Charts8.489 Ratings00 Ratings
Scheduling7.4165 Ratings00 Ratings
Workflow Automation8.0143 Ratings00 Ratings
Team Collaboration8.0218 Ratings00 Ratings
Support for Agile Methodology8.3108 Ratings00 Ratings
Support for Waterfall Methodology8.580 Ratings00 Ratings
Document Management7.5170 Ratings00 Ratings
Email integration7.1115 Ratings00 Ratings
Mobile Access5.9191 Ratings00 Ratings
Timesheet Tracking7.793 Ratings00 Ratings
Change request and Case Management8.1102 Ratings00 Ratings
Budget and Expense Management7.2127 Ratings00 Ratings
Search00 Ratings8.42 Ratings
Best Alternatives
AirtableLightning Tools Lightning Conductor
Small Businesses
Stackby
Stackby
Score 8.9 out of 10
Stackby
Stackby
Score 8.9 out of 10
Medium-sized Companies
InEight
InEight
Score 8.4 out of 10
Troop Messenger
Troop Messenger
Score 9.8 out of 10
Enterprises
InEight
InEight
Score 8.4 out of 10
HCL Connections
HCL Connections
Score 9.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
AirtableLightning Tools Lightning Conductor
Likelihood to Recommend
8.8
(238 ratings)
9.0
(4 ratings)
Likelihood to Renew
9.5
(5 ratings)
9.1
(1 ratings)
Usability
8.0
(36 ratings)
-
(0 ratings)
Availability
10.0
(2 ratings)
-
(0 ratings)
Performance
9.0
(1 ratings)
-
(0 ratings)
Support Rating
9.0
(30 ratings)
9.1
(1 ratings)
In-Person Training
8.0
(1 ratings)
-
(0 ratings)
Online Training
9.0
(1 ratings)
-
(0 ratings)
Implementation Rating
9.0
(2 ratings)
-
(0 ratings)
Configurability
10.0
(2 ratings)
-
(0 ratings)
Contract Terms and Pricing Model
5.0
(1 ratings)
-
(0 ratings)
Ease of integration
8.0
(2 ratings)
-
(0 ratings)
Product Scalability
9.0
(2 ratings)
-
(0 ratings)
Vendor post-sale
8.0
(1 ratings)
-
(0 ratings)
Vendor pre-sale
8.0
(1 ratings)
-
(0 ratings)
User Testimonials
AirtableLightning Tools Lightning Conductor
Likelihood to Recommend
Airtable
Airtable is an ideal platform for small and growing businesses to keep track of just about EVERYTHING they need to keep things running smoothly. It's a great way to keep tasks organized, and keep everyone on the same page with progress on all things. Our company finds the kanban particularly useful, as products go through a lifecycle from ideation to retirement, it's good to keep a database of what is in production, what's working, and what we've tried before. I can see the platform being challenging with much larger businesses, but for the small to medium businesses I've used the platform with, it is ideal.
Read full review
Lightning Tools
Having experience of SharePoint On Premise and also SharePoint Online, there isn't an out of the box app/webpart that enables you to 'roll up content' from a variety of source's (in my case SP Lists, but there are many other data sources it works with) across site collections with an easy to use and intuitive interface which is what Lightning tools excels at.
Read full review
Pros
Airtable
  • I can create tables, create and customize fields
  • Airtable has capabilities commonly found in spreadsheet applications, but also has some of the features found in databases.
  • The ability to filter fields. I set up a filter on the status field, so when a project is marked, complete, on hold, or canceled, that record is hidden from my current projects table view. If it is marked complete, the record is moved to the completed projects table view. In this way I can easily access a record of past projects
  • Being able to duplicate tables and create alternate views
  • Collapse and expand records. When I collapse the rows, I can easily scan current projects, next steps, project status, and due dates. When I expand the row, or field, I can see more detailed information about that field or record very easily. I can also expand or open the entire record. This is is helpful, when I am entering a lot of information to multiple fields in that record.
Read full review
Lightning Tools
  • Aggregate documents across SharePoint site & libraries
  • Filtering for owner/person responsible & due dates
  • Ease of end-user filtering on columns
  • Color-coding & other formatting
Read full review
Cons
Airtable
  • When records are deleted, there could be more options for what happens to associated records in other tables.
  • Multi-select fields should be sortable.
  • The per-user pricing model can be cumbersome when you need to share bases with third parties but can't use a publicly accessible URL.
Read full review
Lightning Tools
  • Mobile Friendly
  • Calendar/Gantt views
  • Complex/Custom Logic
Read full review
Likelihood to Renew
Airtable
We will 10/10 renew the use of Airtable because it has brought great value to our team. Not only is Airtable affordable, but it's also user-friendly and helps our team be efficient. We no longer need to rely on Excel spreadsheets being passed from person to person via email. Furthermore, we aren't dealing with corrupt Excel spreadsheets and the need to salvage data when a file is accidentally altered.
Read full review
Lightning Tools
No answers on this topic
Usability
Airtable
IMO the usability of this product is its greatest asset. The UI is clean and the menus are intuitive to the point where I'd feel confident having a non-spreadsheety colleague take on building an Airtable for the first time with next to no training. I can't say that about every table-like software product that I've used such as Notion.
Read full review
Lightning Tools
No answers on this topic
Reliability and Availability
Airtable
I have rarely experience downtime, compared to other tools, and given how much time we spend on the tool. Even if there were to be, their updates on it are very timely, and our support team are able to provide any questions regarding
Read full review
Lightning Tools
No answers on this topic
Performance
Airtable
I never had any issues with load time, even with the integrations that we use today (google sheets) However, I'm curious if adding additional layers of integrations would slow down performance. We do carry quite a bit of data in Airtable, but, again, no impact on overall performance
Read full review
Lightning Tools
No answers on this topic
Support Rating
Airtable
Airtable has great support. They have a variety of support features to answer any questions. They have great self teaching instructions for templates and product tours. They also have support for teams and project management. They also have a fantastic customer help line. They are able and willing to answer customer questions and never have customers waiting long
Read full review
Lightning Tools
The Lightning Tools support team responds quickly, and team members are very friendly and helpful.
Read full review
In-Person Training
Airtable
This training was done in-house, but the Airtable team provided resources and how to guides to ensure that we covered all components of the system
Read full review
Lightning Tools
No answers on this topic
Online Training
Airtable
Recorded trainings were provided by the Airtable team. Great as an evergreen resources to new team members and for anyone that wants to refresh their Airtable knowledge
Read full review
Lightning Tools
No answers on this topic
Implementation Rating
Airtable
Training all users was an important part of the implementation, which did take considerable time and effort. At first glance without training, the content calendar can be overwhelming because of the amount of data. The features within Airtable seem to be endless but our team was able to identify the most important to be successful.
Read full review
Lightning Tools
No answers on this topic
Alternatives Considered
Airtable
Airtable was a really good fit for this specific use case as it provided a huge number of collaboration features in an intuitive and pleasant-to-use interface. The free tier worked initially with our work, and the upgrade pathway was fair and made sense for us.
Read full review
Lightning Tools
I haven't found another product to compare this one to. Only in SharePoint Online which has a similar App 'Highlight Webpart' ... it's far too complicated to set up and requires learning yet another language and exporting and importing via PowerShell to get any real results that would be useful.
Read full review
Contract Terms and Pricing Model
Airtable
I did not help purchase the product, but Airtable's per user pricing structure is inconvenient when some users only need occasional or read-only use.
Read full review
Lightning Tools
No answers on this topic
Scalability
Airtable
There are TONS of opportunity to scale, but I think it's a matter if you have the time and resources to do so because the initial setup can be fairly time consuming and prioritized dedication
Read full review
Lightning Tools
No answers on this topic
Return on Investment
Airtable
  • It gives us a real-time experience of working.
  • Through this platform, I always have the idea bout which of my team member is working on which particular part of the project, I can easily track their progress, and also I can easily correct them where it is required by adding sticky notes, by sending the attachments and URLs.
  • Quality services.
Read full review
Lightning Tools
  • Policies easier to portray
Read full review
ScreenShots

Airtable Screenshots

Screenshot of Screenshot of Screenshot of Screenshot of Screenshot of

Lightning Tools Lightning Conductor Screenshots

Screenshot of MODERN SHAREPOINT LIST ROLLUP
The Lightning Conductor is a SharePoint Content Aggregator that can be configured quickly by business users. The Lightning Conductor can be used to aggregate content from SharePoint Lists such as Tasks, Document Libraries, Contact Lists, and Custom Lists making it easy to view content in one place even if it is distributed across many sites and site collections. Key data can be highlighted using conditional formatting and data-bars as shown. Content from Search and Microsoft Graph can also be aggregated with the Lightning Conductor.Screenshot of CONTENT AGGREGATION WITHIN MICROSOFT TEAMS
The Lightning Conductor Web Part can be used within Microsoft SharePoint or Microsoft Teams. Even if content is stored within SharePoint sites, it is useful to have aggregated Documents, Tasks, Announcements, Calendars or Custom Lists from multiple sites displayed in a single handy view in Microsoft Teams. The Lightning Conductor can be added as a Teams Tab in any Microsoft Teams Channel.Screenshot of BUILDING REPORTS ON MICROSOFT GRAPH
The Lightning Conductor can be used (without code) to aggregate content from Microsoft Graph as well as Search and SharePoint Lists. This example displays Microsoft Planner Plans and Microsoft Planner Tasks where users can Add new Tasks, Assign Users to Planner Tasks, Delete Tasks, and Complete Tasks. The same can be performed on Microsoft To Do items and displayed within Modern SharePoint pages or Microsoft Teams Tabs. The Lighting Conductor can also contain multiple views of content, making it ideal to display all of your tasks from SharePoint Task lists, Microsoft To Do and Microsoft Planner in a single web part or Teams Tab.

*Microsoft Graph Reports are only available for SharePoint Online and not SharePoint 2019.Screenshot of BUILDING REPORTS ON MICROSOFT 365 GROUPS
Powered by Microsoft Graph, the Microsoft 365 Group Rollup Provider enables users to aggregate content by browsing and selecting Microsoft 365 Groups. Within Microsoft 365 Groups, you’ll be able to select entities such as Drive Items, Owners, Members, Planner Plans, Planner Tasks, Events, Posts,  Sites, Lists, and Calendars.

*Microsoft Graph Reports are only available for SharePoint Online and not SharePoint 2019.Screenshot of AGGREGATING USING SEARCH
When performance is critical, search can be used for rollups. The Lightning Conductor offers three data source configurations to get to content. Object Model (Real Time Aggregation from SharePoint Lists), Microsoft Graph (Aggregation from Graph Entities such as Planner, OneDrive, Outlook), and Search. The Search Data Source enables the aggregation of content from large SharePoint lists and libraries when performance is critical. Thousands of documents can be displayed in under a second using Search.Screenshot of HIGHLIGHTING KEY BUSINESS DATA WITHIN VIEWS
End users and Site Owners can highlight the data that is important to them, the data that they need to prioritize. Using conditional formatting, data bars, and icons, conditions can be configured to highlight the data that is most important. Icons and Data Bars can be any color or size desired. Examples include highlighting High Priority tasks, Showing data bars for the completion progress of Tasks, or indicating which tasks are assigned to any particular user.