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.
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:
Do the same with modified numbers for the remaining two views.
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:
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
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"
)
)
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.