it would be great if we could set a day and time to either enable or disable a form. We want to cut off form entries as of midnight, and I will have to go in a manually do that.
Sign in to see the current vote count, add your own vote, or leave a comment.
In the meantime…
Add a header to the form that includes a note about submissions being closed.
Add a new date field that is hidden and set the default value to be the date you want to stop allowing submissions.
Use three field logic rules based on this date.
First: If the date is after today, show the fields for submission.
Second: If the date is today, show the fields for submission.
Third: If the date is before today, only show the header.
If only the header is shown, no additional fields can be filled in. With no fields filled it, users cannot submit new entries.
While it technically doesn't deactivate the form, it does remove the ability to submit the form once the date is reached.
Brilliant! Can’t believe I hadn’t thought of that.
Thank you!
Happy to help. 👍️
I have a workflow with nearly 40 automations, half of which are email-based requests for updates with various sets of triggers. While I know the automations work, due to months of testing, when our system went live to the institution, I became very worried that the automations wouldn't run and I'd have no idea whether or…
Description: When users upload multiple photos in one action via the Smartsheet iOS mobile app, all files are assigned the same generic name and timestamp. This makes it difficult to identify individual photos and creates confusion in workflows that rely on accurate, unique file naming. Why This Matters: Industry Standard:…
We are recently starting to use the Smartsheet API and Data Shuttle for maintaining Dashboards. We have discovered that the Data Shuttle workflow will notify the owner when the process completely fails, however it will not send notifications wuth a partial failure indicated by the Yellow Caution sign. Since many of our…
