Lightning Tools Lightning Forms vs. Submittable

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.

Submittable is great for grant management, grantmaking, and scholarship awards. It's a very useful tool also when there are multiple reviewers and committees involved in the assessment of the application. The table feature is helpful, but to download the information in a usable report is a pain. Overall a very useful tool for funding.

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.

• Form-logic: Allows application forms to adjust based on answers to crucial questions (if-then-else) so that all applications don't have to see extended questions that may not apply to them or their situation.
• Messaging Platform: This platform allows interactions with applicants or internal review teams to be associated with the specific submission, allowing for an easier, complete view of an application being considered and as an audit trail.
• Good Voting/Polling Management: It makes it easier to record the latest vote/feedback from assigned team members and allows customization of the vote/feedback review as a form. It also summarizes the votes for easy review in a submissions dashboard view.

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.

• We are some of the earliest users of employee volunteerism, so there have been some things to work out. However, because of that, we've gotten a lot of one-on-one support to help make minor tweaks to the system in a way that works for us.

Incentivized

We use this software annually to help with our grant processes. Without it, I'd be so lost! Our team relies on the data from our past years to sift applications and we try to prioritize those who have applied and been a finalist but perhaps didn't win in years prior

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.

A submittable requires a great deal of thought to set up. It would be best if you really did an outline and flowcharting. Once you have a detailed plan and set up the system, you have to think of the process that you would manually do step-by-step to deal with the what-ifs; it’s beautiful. The ability to Clone events is invaluable. The onboarding can be complex, but the ease of use afterward is worth it.

Incentivized

We have thankfully never experienced an outage nor been affected by a technology issue on Submittable's side that has delayed our grant process. We have instead been able to distribute over $6M in donated dollars to AAPI small business owners because Submittable is trustworthy and available

Incentivized

We've had a quick and efficient submittable experience that has always been easy to use. When we need a report it downloads within seconds, even the larger reports are 30 seconds or less to download. Pages are quick to load and reports complete in a more than reasonable time frame

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.

I think that they are good at answering our questions and solving our problems. We occasionally get reports from applicants about problems the Submittable team has not solved, but I do not know what the applicant has done to get the problem solved.

Incentivized

We have been using this for many years but my memory is that we had a
human walk us through how to use basic features. We also used the
resource library to learn about specific topics or issues as they came
up.

Incentivized

10/10 because we were able to meet virtually and still get all of our questions answered! Online was effective too because we could easily record the sessions and review them later. Since we had to onboard our reviewers virtually, it was actually convenient that this was the same method we learned how to use the entire program virtually too.

Incentivized

I would say, provide Submittable as much detailed information on your planned use of the platform and your desires with the platform as possible, and the implementation will be tailored to accommodate your organization with minimal lag time and issues/problems.

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.

Submittable isn't in the same league as these other platforms. It's trying to get there but it's been a rocky road. Neither customer support nor the account people we've dealt with at Submittable seem particularly knowledgeable about how the product actually works for foundations and can't provide detailed recommendations for how to use the product more effectively. The decision to use Submittable was made before I came on board. We are moving to another platform next year, probably SmartSimple.

Incentivized

I wish we could choose our own number of applications we want for the year and have the price be changed because we are in-between buyable numbers and always have to add more applications at the end of the year

Incentivized

We have been easily able to grow. Not only are we able to process different applications, but Submittable makes it easy to add applications onto our plan. Additionally, their eligibility form before the application does a good job of screening applicants so we do not pay for extra applications.

Incentivized

Very professional

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.

• Time is money! Submittable has eliminated many tasks I used to do manually, thus freeing my time for other work.
• Decreased support calls and emails from applicants- Our applicants are able to successfully access and apply for our grants.
• No internal IT support needed to use this platform. That team is able to focus on their larger business projects and needs.

Incentivized