Help

Re: 30, 60, 90 Day Check In After Clients Start Date

770 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Admin_Departme1
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey Airtable Community,

I need some help with triggering the right filters based off a clients start date. We are currently wanting the client to be moved into a 30 Day Check In View between 30 and 59 Days into their program, a 60 Day Check In View between 60 and 89 days into their program, and a 90 Day Check In View between 90 and 120 Days into their program.

Does anyone know the right filter combination to make this happen? All the ones I’ve attempted so far are not populating as intended.

2 Replies 2

Hi @Admin_Department1,
I would make a formula that shows me the number of days it has been from Check-In to Today

DATETIME_DIFF(TODAY(), {Check In Date}, 'days')

Then create the three views, 30 day, 60 day, 90 day.

Set filter for 30day view to:

image

Do the same with modified numbers for the remaining two views.

Nice. I think I would extend this a bit and make it a formula field that updates to display the view it would be in too, so that I could use group by’s and stuff

Screenshot 2022-09-10 at 10.34.42 AM

Base Link

IF(
  AND(
    DATETIME_DIFF(TODAY(), Date, "days") >= 30,
    DATETIME_DIFF(TODAY(), Date, "days") <= 59
  ),
  "30 Day Check In View",
  IF(
    AND(
      DATETIME_DIFF(TODAY(), Date, "days") >= 60,
      DATETIME_DIFF(TODAY(), Date, "days") <= 89
    ),
    "60 Day Check In View",
    IF(
      AND(
        DATETIME_DIFF(TODAY(), Date, "days") >= 90,
        DATETIME_DIFF(TODAY(), Date, "days") <= 120
      ),
      "90 Day Check In View"
    )
  )
)