only open the form on a certain date

Can we display forms only on certain dates in appsheet? For example, the form is only open from the 1st to the 2nd or 3rd of every month

0 2 38
2 REPLIES 2

Alright, you can use the following expression:

OR(DAY(TODAY()) = 1, DAY(TODAY()) = 2, DAY(TODAY()) = 3)

If you're talking about a view, go to its view and use this expression in SHOW IF. But if you want to prevent the user to open the form view you need to go to the action of EDIT button and there you scroll the page down and use this expression in behavior.

by form you mean to add or edit data ? because these are the only action buttons that open the form. 

if you want to disable "add" after these specific dates 1 , 2 , 3 
go to Behaviour , search for the "Add" Action of that specific table
scroll down to "Only if this condition is true
This action is available only for rows of the table that satisfy this condition"

Try this expression: 
OR(
DAY(Today()) = 1 ,
DAY(Today()) = 2,
DAY(Today()) = 3
)


You can use the same expression to show the view or hide it as well 
all depends on if you want to hide the view or just the Add action, but in all cases you can use that expression.

Top Labels in this Space