Lightning Forms is a SharePoint list form design tool that aims to enable users to improve the logic, layout and styling of responsive SharePoint Forms. Lightning Forms offers cascading lookups, customized buttons with actions, repeating lists integration, tab controls, styling and conditional control formatting, calculations, and expressions. These features help users to build business forms within SharePoint and offers an alternative to InfoPath Forms.
$2,200
per year per installation
QuickBooks Online
Score8 out of 10
N/A
QuickBooks Online is a SaaS version of the QuickBooks product. It contains all of the features found in the local version. Higher-priced plans include greater automation, payment management, inventory and time tracking, and analytics features.
$38
per month
Pricing
Lightning Tools Lightning Forms
QuickBooks Online
Editions & Modules
Lightning Forms OnPrem
From $2000
per year per installation
Lightning Forms Plus OnPrem
From $3500
per year per installation
Lightning Forms OnPrem Enterprise Edition
POA
per year per installation
Lightning Forms (Online)
From $2200
per year per installation
Form Designer Suite (Online)
From $4000
per year per installation
Lightning Forms Enterprise Edition (Online)
POA
per year per installation
Simple Start
$38
per month
Essentials
$75
per month
Plus
$115
per month
Advanced
$275
per month
Offerings
Pricing Offerings
Lightning Tools Lightning Forms
QuickBooks Online
Free Trial
Yes
Yes
Free/Freemium Version
No
No
Premium Consulting/Integration Services
Yes
Yes
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
Prices stated are minimum per installation for "stock" products.
$2.2 & $4.00 per user/year for each product ion 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 versions)
Overall, there are many use cases for which Lightning Forms provides a slick, easy to develop and extremely useful solution. Request forms that need to be actioned and inspection forms are the scenarios that we have used them for so far, which have seen a lot of success. We have decided that other scenarios that are perhaps more sensitive, for instance forms that may contain special category data relating to our customers, are less appropriate given the permissions/licensing constraints of both SharePoint and Lightning Forms.
QBO is a great solution for small and midsize companies. If the goal is to record all transactions and pull reliable financial reports, QBO is a great option. QBO is also a great solution if most operations are run in a system like Ramp. It syncs well with systems like that and turns the data into something management can use to make decisions. QBO is great because so many people use it. It is easy to find training online, and many people have experience with it.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Simple user interface - users of the forms intuitively aware of how/where to input information. This is in part due to being able to show or hide different questions or areas of the form, and making them required or not, based on previous answers.
Low/simple code - building complex forms with automation and multiple dependencies or lookups is relatively easy once you get started. You have the power of JavaScript to use and do some quite clever things if you can get to grips with it - a lot of solutions are only a Google away.
As it is based on SharePoint, it integrates perfectly with the rest of the M365 suite. Things like PowerAutomate enhance its functionality even further.
Workflows for accounts payable invoice review are terrific.
Bill payment allows you to pay vendors online via ACH or check without having to write a physical check, which reduces admin time.
The cloud based login lends well to a remote or hybrid work environment for staff.
QuickBooks Online allows you to pre-configure vendors' general ledger expense accounts. This helps with general ledger coding accuracy and consistency.
QuickBooks Online integrates with Rippling HRIS, Coast, Capital One, JPMorgan Chase, etc., which lends well to an efficient month-end closing and reduced administrative time.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
The styling of the form can sometimes be slightly awkward to use depending on what you're looking to do. For instance, if I was looking to highlight fields that users have missed (left empty), I would need to set up a validation for that question and then set a style for that particular field for when it is invalid. When you have a large and complex form with lots of dependencies, this is awkward.
Support for complex and niche issues is slightly lacking in my experience. I submitted a helpdesk ticket for help with a strange issue I couldn't figure out, which took several weeks to get a response to. Because it is niche, it's more difficult to find an answer by searching the internet. Luckily, knowing there is likely to always be a fix if you find the right place/use the right formula, I manage to resolve the issue with some trial and error.
It is disappointing that Lightning Forms does not integrate with the MS Lists app. Having the ability to access the form through the list app would add in a lot of useful functionality, including a better experience for users when taking photos to add as attachments.
I dislike that the online bill pay option through QuickBooks is required for their invoicing.
The auto-fill portion of the customer setup, specifically the company name, is listed, but it also auto-fills in the name portion, which is inconvenient and time-consuming to remove.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
It like the product 'right out of the box' and I trust Intuit will continually improve it over the years based on my experience with their desktop products. The large providers of Apps makes customizing the entire package relatively easy and seamless for a wide variety of business types.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
It is very user friendly both to me who is building the content (with little background knowledge of coding etc., other than what I have picked up from using products like PowerAutomate, PowerBI, a bit of html etc.) and to end users of varying levels of IT proficiency. This has been extremely important as we have used the forms to make relatively large process changes, and need to have our users on board and seeing that it is actually easier than it was before.
Beyond being overkill for a small org's needs, QBO is constantly stealing screen real estate and attention by hammering users for account upgrades, connecting to one of their approved consultants or buying add-ons. The idea of using a simple configurable bookeeping and light accounting interface is completely missing. At the very least, we should be able to hide functions like inventory that we will never use.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Some support has been okay, but in one instance of a fairly complex problem, the support team were not able to provide me with a fix within a few weeks, before I was able to find a workaround myself.
In my experience, most representatives keep me on the phone for hours, literally, for a single issue and then usually cannot resolve it satisfactorily. I have 10 open cases that need resolution and, in my experience, there has been NO follow-up communication on any of them.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
The person in charge of QB needs to be very accurate with record keeping and is recommended to stay on top of tasks. The biggest issue we have is reconciliation, and those issues occur only when too much time has occurred between reconciliations
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
We were using Microsoft Forms, SharePoint Lists and PowerAutomate to attempt to do much of what we are currently doing. Functionality is very limited in comparison. The ability to make questions required based on previous answers was a massive improvement from normal SharePoint List forms and has greatly improved the quality of data. Also just the very visual display and customisation is much better.
As a freelance bookkeeper, the Desktop version of QuickBooks Online doesn't allow for ease of access from any device. Having to be on a computer with the software downloaded creates additional work to gain access to all required filings etc. Also, I personally find the linking functionality on the Online version to be much more streamlined and user friendly.
As we have grown along our professional path, we have also expanded our use of QB. The scalability is easy and features seem to be waiting for you until you need them. We have increased profits by over 10x from our first year in business to the current and have yet to find a reason to look elsewhere
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
We changed the process by which site colleagues report repairs on behalf of customers. Instead of emailing them into a shared inbox, they now report them using a lightning form. We have seen a great improvement in the time taken for our team to log the repair issue from the time is arrives with them.
We anticipate that streamlining our void property reletting process by using a SharePoint kanban board view with lightning forms (providing a single platform for all things void) will reduce avoidable days vacant and therefore reduce our void loss.
QuickBooks has given us a useful portal by which to get an overview of our financials.
QuickBooks has given us a relatively easy way to send out invoices quickly and efficiently.
Due to the customization limitations on QuickBooks, we've had to get creative in third-party implementations to better represent our brand and to track financials.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
