grabo

filtered list

Discussion created by grabo on Jan 29, 2019
Latest reply on Feb 1, 2019 by onefish

I have this problem.

An Excell document with many sheets. Each sheet is a month.

For each month these fields are present:

filter (which contains or does not contain an "x")

day

time

event

Description

 

I'm only interested in records that have filter = "x"

 

The result I would like is a text made this way:

 

January

Monday 01

Time1 event, description

Time2 event, description

Time3 event, description

...

 

Tuesday 02

Time1 event, description

Time2 event, description

Time3 event, description

...

 

Wednesday 03

...

February

....

 

In short, the month only once as a general title and the day also should not be repeated for those who are on the same day, but only at the beginning as the title of the day.

 

I created a related table on the "x" relationship that shows all the records.

I created a portal, but I could not even filter it. I can sort events by date, but the filter does not work for me. The filter was just filter = "x"

 

Probably not the best way to get what I'm looking for. What do you recommend? I think maybe a list somehow.

Outcomes