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

Peggy Parchert · 08/29/22

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 · 03/10/23

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 · 03/27/23

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

Salma · 03/29/23

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 · 05/03/23

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 · 05/19/23

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å · 05/19/23

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 · 05/20/23

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 · 06/06/23

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. · 06/30/23

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. · 07/28/23

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 · 10/18/23

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!

Sign in to submit new ideas and vote

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

Idea Submitted · Last Updated 08/29/22

Comments

Categories