Question

Cut-off date

Forms

Updated April 14, 2020

asked on April 13, 2020

I currently have a form that needs to be submitted by the 10th of each month. I am trying to figure out how to put a hold on users trying to submit their form on the 10th until I pull reports. I then want them to be able to submit their form on the 11th. I know I can unpublish the form, but wanted to know if there was another way to have a cut-off date.

0 0

Replies

replied on April 13, 2020 • Show version history

You could have a hidden, read-only date field that defaults to the current date/time. Then create another hidden, read-only single line field that has a calculation to extract the DAY value of the current date. [Might be able to do those two in one step with the right formula. Try =DAY(TODAY()) ]

Along with that, I'd create a showing custom HTML field with a message letting your users know that today is the 10th and you are currently processing reports. Please return to this form tomorrow to fill out for next month.

I would then create a field rule

Hide All fields, Show custom HTML field with message

if hidden field = 10

4 0

replied on April 14, 2020

Thank you! That worked great!

0 0

replied on April 13, 2020 • Show version history

Good one Jared

Also, if you wanted the users to only be able to submit the form starting from the beginning of the Month to the 9th, you would just change the formula to (if hidden field <10 ) and use similar rules to hide the fields and show the Custom HTML.

FYI, if you put the fields in a Section, then you can just hide the Section and it will hide the Fields in the section as opposed to having the hide the fields individually.

In this case, ensure the Custom HMTL field is outside of that section so it not controlled by those same rules

3 0

replied on April 14, 2020

Thank you! That was helpful.

0 0

You are not allowed to follow up in this post.

Question

Question

Cut-off date

Replies

Sign in to reply to this post.