My users select on the booking screen whether their children are on board the bus themselves or just sending laundry home. These selections are written to 2 different columns in the trips table, Choice-self and Choice-laundry. Other calculated columns will show different versions of these choices for use in different screens.
One of these columns (ITE calculation) should say e.g. “Wasgoed huis toe”, or just “Huis toe” (Laundry home or child self on bus home). This column will be empty if neither the child nor his laundry are on the bus. It is used in a filter on the Schedules screen toe select entries where that column is not empty. Each pickup and drop-off point in the schedule is in a custom container that is filtered on that column not being empty, among other things.
Now what happens is if the column contains “Wasgoed” and there are 2 kids with laundry in that container, the container is duplicated. So tomorrow I have laundry for 2 kids at different schools but living in same town. So the “drop-off/town” container is duplicated but the “pickup/school” one is not. If I remove the word “Wasgoed” from the column it works perfectly. It happens however I structure the filter, and whatever terms I use in the column. So “Pakkie huis toe” or just “Wasgoed” has no effect. Changing the name of the column or the order of the cases has no effect. It ONLY works if the term is exactly “Huis toe”.
The same filter is also used in the data container that contains the names. Removng it also has no effect (so it’s probably not even necessary.)
So a column that is “not empty” is is not filtered correctly if it doesn’t contain a specific term.
I need it ot display “Wasgoed…” otherwise the info on the details screen shows “Huis toe” which is not actually true.
W