Data Valid between two dates, but only in certain ...

Seth_Kling · 08-25-2021 08:43 AM

I have a form that I only want them to be able to input a date in the next 30 days.

Valid If: and([DATE]<today()+31, [date]>today()-1)

However, in a different view, I don’t want this restriction - the manager needs to be able to update incorrect data from previous dates - as far back as the beginning of data collection.

Point me in the right direction on a way to do this?

*EDIT: I have a different view for this. View I want the restriction is a form (scheduling_form) and the view I don’t want the restriction is a table view (verifications)

Aurelien

HI @Seth_Kling

You may want to combine:

That would be something like:

SWITCH(
  USERROLE()="Admin",
  AND([date]<TODAY()+31, [date]>TODAY()-1),
  true
)

Or:

SWITCH(
  CONTEXT("View")="scheduling_form",    AND([date]<TODAY()+31, [date]>TODAY()-1),
  CONTEXT("View")="another_form",    AND([date]<TODAY()+60, [date]>TODAY()-6),
  AND([date]<TODAY()+100, [date]>TODAY()-100)
)

Or:

SWITCH(
  CONTEXT("ViewType")<>"Detail",    AND([date]<TODAY()+31, [date]>TODAY()-1),
  true
)

Data Valid between two dates, but only in certain views