Good day Gliders. I’m still regularly having problems specifically with the data grid.
I use a grid connected to the Trips table, filtered for a specific day. In this grid I can change the pickup times and sequence at schools to fit changing circumstances. Like now kids are writing exams so schools finish at different times.
I have 2 problem situations:
- Duplicated info in the schedules. The schedules present the info from the grid in the sequence entered there. Schedules consist on custom containers, each filtered on the sequence number (and some other things.) Regularly, but not always, one or more of the containers are duplicated. U to now it has always been an error in the grid - different spellings or same times or sequence numbers for different schools. But not today. I have double-checked every column in the grid for differences and there are none. I even deleted those entries and added them again, with the same result. And not only in the pickup schedule, the drop-off schedule also duplicates the bus stops - for only the 2 stops where the kids from the duplicate schools disembark.
Here are some screenshots:
The last 4 entries are affected. As you can see they each have the same name, pickup time ( 1st time column) and sequence (4 or 5)
This is the schedule:
- I have posted this before, but when I copy a cell in the grid and paste it into another cell - like the time or sequence number for the same place - it pastes the complete layout of the Welcome screen. Sometimes everything, sometimes the first few rows.
Twice now it also caused the whole Welcome screen contents to disappear. The first time I didn’t notice it immediately - I didn’t go to the bottom of the grid where it was pasted.. Only saw it when I went out and back to the Welcome screen.
Instead of this
Frustrating.
Update:
I have found the problem to the duplications in the schedule but I do not know the reason. The problem was that for those 2 schools each one had a “Wasgoed” (laundry) entry as well as one without. So the column the filter uses had an entry “Wasgoed huis toe” and an entry “Huis toe”. The filter is <includes “huis toe”> which will select both values. Correct, since both will be on the bus, the “wasgoed” just doesn’t count as an occupied seat.
So why is the custom collection duplicated for the different wording in the column, if the filter selects both wordings?