I have a Glide based app (multiple users) have a list of jobs to do on a certain date. I can edit the due date for each individual job but I would speed things up significantly if I could use the checklist collection to select jobs that I want to edit the due date for, and then reschedule them all one in one go.
This is what I tried…
- I created a screen based on my Jobs table.
- I added a Date component to selct the date I want to use as the resceduled date and this writes to the users table.
- I added a collection of the jobs which I can filter by area ett. The collectio is a checklist
Now this is where I’m stuck…
- I added an action button to create a workflow based on the Jobs table which filters the Boolean column for checked items (The ones selected from the checklist)
- The action is to set the column value of the scheduled date to the selected date (written in the users table)
Step 5 causes the issue that the workflow needs to be triggered by user interaction and so it will not allow me to write data from the user table column.
I’m struggling to find a work around as I keep hitting a wall in the workflow…
Any help would be much appreciated!