I have a formula which is used to filter a table. On the page there are a dropdown (which is used to filter by date), a checkbox (which is used to filter on status "Aangemeld") and a textinput to manual search on name or organization. I want to add an extra checkbox to filter on blank status, but I am a bit lost on where to add this to the formula.
It is quite a messy bit already to be honest.
This is how it’s build up at the moment:
Search(
Switch(
Drop_Filter.Selected.Value;
"Alles";
If(
Checkbox_Filter_Aanmelden.Checked;
Filter(
bVisitorBezoekers;
Status.Value = "Aangemeld"
);
bVisitorBezoekers
);
"Geschiedenis";
If(
Checkbox_Filter_Aanmelden.Checked;
Filter(
bVisitorBezoekers;
Aankomst < Today() && Status.Value = "Aangemeld"
);
Filter(
bVisitorBezoekers;
Aankomst < Today()
)
);
"Toekomst";
If(
Checkbox_Filter_Aanmelden.Checked;
Filter(
bVisitorBezoekers;
Aankomst > varTomorrow && Status.Value = "Aangemeld"
);
Filter(
bVisitorBezoekers;
Aankomst > varTomorrow
)
);
"Vandaag";
If(
Checkbox_Filter_Aanmelden.Checked;
Filter(
bVisitorBezoekers;
Aankomst >= varToday && Aankomst < varTomorrow && Status.Value = "Aangemeld"
);
Filter(
bVisitorBezoekers;
Aankomst >= varToday && Aankomst < varTomorrow
)
);
If(
Checkbox_Filter_Aanmelden.Checked;
Filter(
bVisitorBezoekers;
Status.Value = "Aangemeld"
);
bVisitorBezoekers
)
);
SearchInput_1.Value;
Titel;
Organisatie
)