My school charter bookings are working so parents can book their children. The next step was to create a schedule with passenger names, pickup school and time etc. A simple table layout took care of that, but I would like to have a customized form that is more user-friendly. The table can e.g. group by pickup point but then it’s not sorted by pickup time (The groups, not the rows in the group.) So each row must then display the same pickup time, and the time is not front and center for the users.
I would like to have a form with each pickup point and time as a heading, starting at earliest pickup time (or first pickup sequence) then the passengers’ names etc in sorted rows below. Repeat for the next pickup time or sequence number.
I’m wonder if that’s possible? If not then a list sorted by pickup times would be acceptable, but with the time also displayed prominently somewhere sensible outside of the table.
Furthermore, if it would be possible for the driver to change the sequence if needed - by time if grouped according to time, else by sequence number.
We pick up at a max of 7 places, seldom all 7 together, so not a big job to change the sequence. The driver should just edit the time/seq no. Will the sequence re-sort in the form by itself or can it be done with a button?
And lastly, the driver should have a button to “mark” loading as completed and write the current date/time to each row in the group.
Any ideas?
Edit:
So many issues arose while I was trying out different scenarios. First I noticed the calculated ETA was wrong, I left out a component. I fixed that and now it’s correct but the formatETA column does not update. It is experimental FormatDate type (HH:MM). This formatted time is used in the bus schedule layouts.
The layout consisted of custom containers with a heading (Pickup point, time), and a table with just the passenger name. The layout is filtered on Route (1 or 2) and a date (on/after today). Then the table is filtered on a manual pickup sequence number as well as the route and date as above. A one stage I had the heading displaying the pickup point and time, again filtered by sequence number. I t worked perfect for seq 1. I then duplicated the container, changed all the seq filters to 2, and it refused to display ANYTHING. as long as seq is 1, I can have any number of containers displaying correctly.
Then I tried another layout and lost everything. Now the container shows the correct data and I can duplicate it and change the seq filter for the table but the header stays the same.
Yet another problem I don’t understand is the DateTime columns. I have in my Schools table and my Hostels table each the exact same column, displaying as time only, without seconds, ignoring time zones. In Schools the column has a clock icon, but in Hostels it shows a calendar.
Still trying …
And picked up another bug. Like I said, the table rows display the correct data for that Seq number but no other component does. I added a button with a manual trigger to write the current date/time to the Trips table (for offloading and later picking up too. If I filter the button with a Seq condition other than 1, it disappears. I checked the value of seq number with a text component, a field component and a number entry and they all showed 1, irrespective of what the actual seq number is.
I give up. Anyone has an idea?