Is there a way to use a checklist collection to bulk edit checked rows?

Ask for Help
1

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…

  1. I created a screen based on my Jobs table.
  2. I added a Date component to selct the date I want to use as the resceduled date and this writes to the users table.
  3. 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…

  1. 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)
  2. 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!

2

These steps are good. I’d just tweak the checklist behavior a bit so it’s safer for multiple users.

Instead of writing a simple “checked” Boolean, have each checklist tap write the signed-in user’s Row ID into a column on the Jobs table. This way, each job row records who selected it, and you can probably block assignment if that column is not empty (to prevent two users editing the same job at the same time).

To keep the UI as a checklist, use an if-then-else column for the icon:

  • If the job’s “selected by” column is the signed-in user’s Row ID, show :white_check_mark:
  • Otherwise, show :white_large_square:

Then:

  1. Create a manual workflow on the Jobs table that accepts two inputs:

    • adjustedDate (the new date you want to move the jobs to)
    • userID (the Row ID of the signed-in user)

  2. Add an action button on your screen that calls this workflow. Pass:

    • adjustedDate from the user’s selected date
    • userID from the signed-in user’s Row ID

  3. In the workflow:

    • Filter Jobs by the “selected by” column, equal to the userID input
    • For each matching row:
      • Set the scheduled date to adjustedDate
      • Clear the “selected by” column so those jobs are fresh for the next iteration

This lets users bulk-reschedule only the jobs they personally checked, and resets the selection after each batch.