Google Forms vs. Lightning Tools Lightning Forms

Google Forms is great for simple surveys, such as quick polls, but any logic beyond conditional pages is not supported. Google Forms is best used when the survey participants have and are permitted to use a Google Account to fill out the form; we ran into issues with hospital IT departments. I don't believe there's a better free tool out there than Google Forms, though.

Incentivized

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.

• Live results: When a user completes the form the results are added instantly.
• Easy to create: Google Forms has a simple interface that allows for a wide range of question types. Google will even try to guess the question type based on the question (but this can be overridden).
• Answers export to Google Sheets: It is easy to have each response to your form add a row to a Google Sheet, allowing for further analysis or processing.
• Ability to automatically collect email addresses within a domain: If you have a form that has been shared with users in your domain, you can set it to automatically collect the users' email addresses without them needing to type it in. Makes checking whether all students have completed the form easy.

Incentivized

• 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.

• Sometimes finding the output -- a Google Sheet with all responses-- is a little difficult. It's also sometimes confusing to figure out how to get back into the Google Form Survey itself.
• As always, sharing among an institutional Google account and your personal Google account can be frustrating. You have to make a copy and can't share across the two different accounts very easily.

Incentivized

• 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 will definitely renew my use of Google Forms because I really like the ease of use and the number of tools that Google forms provide. I also love that I can administer a test in real-time and get results in a timely manner

Incentivized

Overall ease of use for staff, volunteers, and adult learners, and easy to get reports and to share reports via Sheets. As a free tool, it does more than expected. Easy to change the look and brand it to your organization, or just make it more fun, depending on what you want to use it for.

Incentivized

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.

In the years I've used GoogleForms I've never ran into any issues with the reliability or availability. Google is a gigantic company with essentially limitless resources which makes it very easy to trust that I will continue to be able to enjoy the same reliability I've come to know and expect from GoogleForms

Incentivized

One of the things that comes as a benefit of the lack to create complex logic branching and truly custom design is that there isn't lot of room to bog down the software. GoogleForms has always loaded just as fast as my internet service and device would allow it. I'm not sure about front end integrations or integrations into the form itself, as I've never explored it, but on the backend, I've never had any issues with integrations channeling from GoogleForms from the GoogleForms's end of things.

Incentivized

We haven't used much official support for Google Forms. However, because it is so widely used, there are a ton of articles and guides available online to help administrators of varying technical abilities to work through problems that arise. Additionally, Google provides an official support forum where there are discussions with other users as well as Google developers that can help address issues if needed.

Incentivized

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.

Google Forms doesn't really require "implementation": simply log into GDrive and create a survey! You can configure settings per survey to, for example, automatically write responses to a GSheet.

Incentivized

Although both platforms offer similar functionalities, Google Form has a personal advantage and it is the impeccable integration with the different applications of the Google suite, this allows to make use of all of them in a transparent way, which in the work environment allows to perform work efficiently and without affecting the quality of it.

Incentivized

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.

GoogleForms lacks the ability for complex logic branching and the ability to truly design it in a custom manner. It's pretty obvious when you land on a GoogleForm that it is in fact a GoogleForm. This rating solely reflects the lack of flexibility which in turn makes it something that wouldn't usually be scaled. That being said, if needing to scale a simple solution, GoogleForms would be up for the job.

Incentivized

• High positive impact and return of investment; easy to use and seamlessly integrated with current Google Drive and Suite
• Ability to create surveys on demand and quickly, saving time and energy
• Easy to train others in using Google Forms so that there is not a bottleneck of knowledge

Incentivized

• 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.