Hi Gliders. SUCCESS achieved with the custom layout of the pickup schedule I tried @ThinhDinh and @Jeff_Hager ‘s patience with. I used a combination of Custom collections to filter and order by pickup sequence, and a card collection inside that just for the passenger names. See screenshot below. Now one quick question:
Each button in a collection calls a manual workflow (triggered) that loops through the Ritte (Trips) table filtered as follows:
Route=1
Trip date is on or after today
Trip choices include To Home
Pickup sequence is (1, 2, 3 etc… for that collection)
But when I press the button in any collection, it writes the time to all the rows, filtered only by Route.
What is missing so that it will write to rows that include all the filters?
From your wording, you’re looping through the Trips table. In the loop module, you should double-check the filter logic to ensure all desired conditions (Route, trip date, trip choices, pickup sequence) are included.
Hi @ThinhDinh I have tried to use the loop filter instead of the button action filter, but immediately ran into an obstacle. If the workflow loops through all the records, what value should I compare the filter with: E.g. the pickup number is… what? I cannot hardcode it because I use the same workflow for every button. Or is that the problem? I thought the button filter would be active in the loop and save me duplicating the workflow 10x. A variable for the pickup number that increases its value for every loop would have been nice.
I want to make it clear first the “button filter” is a visibility condition, not a “filter” on data that would be processed downstream.
I’m making a best guess based on your posts. What you are trying to do here is clicking a button and set a value on all rows related to the sequence number of the card that you’re clicking on.
To do that, you just need one manual workflow. Set the manual workflow to accept a “sequence” input.
Then, back to your “trigger workflow” action that you’re showing on the screenshot here, and add the sequence of the card item as an input to that manual workflow.
In your manual workflow “Skool opgelaai”, add a loop after the trigger. Loop through the relevant table and add filters for:
Pickup sequence equals Trigger > sequence.
Add any other filters here that you want, based on your screenshot above.
