Form Management Automation for Activation or Deactivation

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