# Closing and opening form submission automation

**URL:** <https://connect.superhuman.com/t/closing-and-opening-form-submission-automation/38867>\
**Category:** Ask the Community\
**Created:** [April 3, 2023, 5:49am UTC](https://connect.superhuman.com/t/closing-and-opening-form-submission-automation/38867 "2023-04-03T05:49:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brian\_Wong](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/brian_wong/32/34110_2.png) [@Brian\_Wong](https://connect.superhuman.com/u/Brian_Wong)\
**Post date:** [April 3, 2023, 5:49am UTC](https://connect.superhuman.com/t/closing-and-opening-form-submission-automation/38867/1 "2023-04-03T05:49:47Z")

</div>

In my form submission, how can I set it to close on Fridays and open for submission on Mondays?

---

<div class="post-metadata">

**Author:** ![Scott\_Collier-Weir](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/scott_collier-weir/32/29677_2.png) [@Scott\_Collier-Weir](https://connect.superhuman.com/u/Scott_Collier-Weir)\
**Post date:** [April 3, 2023, 12:36pm UTC](https://connect.superhuman.com/t/closing-and-opening-form-submission-automation/38867/2 "2023-04-03T12:36:11Z")

</div>

Hey there! Welcome to the Coda community!

So there is no real way to CLOSE a form for submissions on certain days. There are two things you can do in this scenario though:

1. You can run a form-submitted automation that, upon each from submission, uses an IF() condition to check the current day, and if the current day is Sat/Sun, your automation would delete the submission.
  - Kind of silly, but it should work. If you need to know more about automations you can learn about them here → [Automation Video | Basics](https://youtu.be/ukfO_RwK9gE)

2. You can create a question in your form that has two aspects to it:  
a. The question is required for submission  
b. The question will throw an error if today().weekday()!=1 or today().weekday()!=7

Form validations are a feature of forms that allow you to check the current answer a user is attempting to submit, and it will block their submission if their answer does not meet certain criteria. You can then set a custom warning message as well.

So in your case, you would use the formulas in b above to essentially ensure that the submit button for a form would simply _not work_ on weekends

Here is a screenshot of me using that feature with the formula `today().weekday()!=2`. Im writing this on a Monday, so needed to use something that would work!

 ![image](https://global.discourse-cdn.com/coda1/original/3X/8/9/895a900c07ccf8a6c4875a1b7367e901e8bbbcb8.png)

**If you need some help with any of these formulas, heres some advanced documentation on:**

- WeekDay()
- WeekDayName()
- WeekNumber()

> **[WeekNumber, Weekday, & WeekdayName](https://coda.io/@simpladocs/weeknumber-weekday-weekdayname)**

---

<div class="post-metadata">

**Author:** ![Brian\_Wong](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/brian_wong/32/34110_2.png) [@Brian\_Wong](https://connect.superhuman.com/u/Brian_Wong)\
**Post date:** [April 4, 2023, 12:12am UTC](https://connect.superhuman.com/t/closing-and-opening-form-submission-automation/38867/3 "2023-04-04T00:12:08Z")

</div>

Hi Scott!

Thanks for your reply and help. That’s a terrific suggestion and I’ll give that a try.

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [April 7, 2023, 3:41pm UTC](https://connect.superhuman.com/t/closing-and-opening-form-submission-automation/38867/4 "2023-04-07T15:41:13Z")

</div>

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.