Hi there,
i have this calendar where I want to show only events where the Subject contains the word “Booking”
At the moment the function of “Circle2” on visible is:
CountRows(Filter(MyCalendarEvents; DateValue(Text(Start)) = DateAdd(_firstDayInView;ThisItem.Value;Days))) > 0 && !Subcircle1.Visible && Title2.Visible
How can I modify the function to also have the filter that shows me the events that contain the word "Booking" of the subject?
All the best
Solved! Go to Solution.
@Z_BI
Try this
CountRows(
Filter(
MyCalendarEvents,
DateValue(Text(Start)) = DateAdd(
_firstDayInView,
ThisItem.Value,
Days
),
"Booking" in Subject
)
) > 0 && !Subcircle3.Visible && Title25.Visible
@Z_BI
Try this
CountRows(
Filter(
MyCalendarEvents,
DateValue(Text(Start)) = DateAdd(
_firstDayInView,
ThisItem.Value,
Days
),
"Booking" in Subject
)
) > 0 && !Subcircle3.Visible && Title25.Visible
User | Count |
---|---|
246 | |
105 | |
82 | |
50 | |
43 |