Deactivate form after set # of entries/submissions OR by date

Peggy Parchert

It would be a great thing to be able to specify that a form be made inactive after a set # of entries.

For example, my company is sending out an email with a link to a form created to gather demographic information on the individuals. The first 40 submissions are eligible for a 'free lunch' and we don't want to continue taking submissions once we have 40.

Thanks -Peggy

Deanna Vandermeer

We have many Smartsheet forms which we use as a way to gather attendance for our district's professional learning events, meetings, trainings, etc., as well as many forms to intake survey or voting responses from professional learning events or resource evaluations. Many of these forms are utilized throughout the entire school year but need to be deactivated at certain times and then reactivated at certain times (i.e., attendance form turned on at the start of the event and turned off at the end of the event or monthly on certain Fridays for Friday PL days, etc.). Currently the only way to do this is to login and manually deactivate or activate each form, which sometimes involves the need to add task reminders to my calendar, then login to Smartsheet to deactivate or activate a form. This can be inconvenient as sometimes these events are outside of regular working hours or requires a person to work during days off or when home ill. It is important though to deactivate, or even to activate, a form during the appropriate time and date as we do not want data coming in outside of the structured times for the event. Wouldn't it would be an incredibly unique and timesaving function if Smartsheet were to come up with a way to automated this? It would be HUGE help to be able to set this as a task (i.e., activate the form at 6:30 AM on this date, deactivate the form at 10:00 PM on this date).

Melissa Boehl

Would love to be able to set a date/time for a form to automatically start or stop taking submissions.

Salma

Hi smartsheet team,

I've been working on a registration form using Smartsheet and have created it here: https://app.smartsheet.com/b/form/c5f7e9f912b647d7bc9059ba18ed94d8. Related to the second question, 'which class will you attend?', I was looking to see if I could place a selection / registration cap for each option. For example, option 1 would only allow 6 people to select / register, option 2 would only allow 10 people to select / register, etc.

I learned through your support team that this is not possible with smartsheet today and suggested I complete a request like this. Hence this :)

While I know I can keep an eye out on registrations and remove the option when I reach my desired cap, it's highly manual and when you're expecting a lot of registration, it's a lot of work that I know (and I'm sure others) would like to avoid if the above option of capping was available.

Thanks for the consideration,

SA

Reginald

I think it would be a great idea or a great option to have the ability to place automation on the form Activation/Deactivation button.

In my line of business we are constantly activating and deactivating multiple forms every week for a specific number of days. Having so many opening and closing forms becomes a little overwhelming when trying to have a cut off date and time. The option to set this up when opening the form that it should closed on this day at this time would be a HUGE help!

Kari G

We have medical classes with a limited number of spots on a weekly basis. Right now we have to do separate sheets for each class, which is very tedious and overkill, we have to try and catch the sheet and form with alerts, in order to deactivate the form so we don't go over our state mandated ratio limit.

Limiting the amount of rows you want a sheet to have or the number of form entries would be amazing for the medical field in soooooo many ways!!!

Andrée Starå

Hi @Kari G

I hope you're well and safe!

Here's a possible workaround or workarounds

• You could collect them all in one sheet, and with the help of some helper columns, we could count the number of rows per event and trigger alerts when you're getting close or reaching the limit.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

marc4

Have you tried using Google Forms and using the smartsheet connector to tie the data to your smartsheet?

https://www.smartsheet.com/marketplace/apps/google-forms

Google forms will let you “Disable on date” and “Disable on submission limit.”  and has logic.

/marc

crystal.schroeder

My company would benefit from this feature. We allow only so many requests a day and to be able to cap them would help tremendously.

Susan L.

I would love this feature as well. We often gather time-sensitive/quick turnaround information and instead of saying in our message "information received after XXXX can not be considered" it would be super to "disable" the form and have an automated message along the lines of "The deadline to respond has passed" or..similar.

Victoria K.

It would be very helpful to be able to limit form submissions for registration purposes.

Similar to the training use cases above, we are trying to use Smartsheet to organize registration for a vaccine clinic. It'd be a huge help if we could limit each date/time selection to only be used once.

Joan B

Please add restrictions to Form for the option to limit the number of times someone can use the link--to ensure only one survey response per person, and also add the option to inactivate a form link at a designated date when creating the form.

Thank you!

Amanda Miller

Enable timed form shut-offs, so you don't have to set reminders and manually close out timed forms

kendalsolak

This would be so helpful for event management and managing breakout room attendance if this feature can be added!

Deanna Vandermeer

@marc4 - we actually have in fact tried using Google Forms with the Smartsheet connector add-on. However, we repeatedly ran into problems with the connector including the Google form just randomly disconnecting from Smartsheet and failing to enter new entries. While yes, it's a nice idea, sadly our experience has been so frustrating with this non-supported add-on feature that we left it behind many years ago. I have developed a few workarounds to help mimic the ability to "deactivate" the form but it would still be really nice if Smartsheet could consider accelerating their timeline with regard to this enhancement request up on their list. After all, if Google can make it happen then most certainly Smartsheet should be able too, especially since hands down they are a far superior platform (especially in the realm of forms and sheets) in my humble opinion.

Bek T

Another user here echoing all the comments in this thread. We are looking to move all of our training registrations to a SmartSheet form so we can capture all the data in one place in the background, to run reports, etc. and having an auto-complete date would be ace, instead of having to create manual work-arounds/set up reminders or workflows (seems to defeat the purpose of minimising the work involved). So if this could be moved to the front of the list of developments, that would be ace; as Deanna mentioned, if Google/MS forms can include an auto-cut off date for the link, surely Smartsheet could too (I also agree Smartsheet is far superior for forms and sheets).