Configuring a check list for multiple tasks

Ask for Help
1

Hello Glide community! I have hit a road block. I am trying to create a training and development app that consists of 6 positions and each position requires certain training areas to be completed. Once all of the items have been completed (checked) there is a promote button that will clear current tasks and load the next positions tasks. I have tried variations of relations and lookups but none have worked.

2

To clarify, each of the 6 positions has the same areas to be checked off?

3

Thanks for looking at this. The items will be different for each position. There will be 20 employees who will be tracked.

4

Got it. So looks like you’ll need 4 tables:

  1. Users
  2. Positions
  3. Tasks
  4. Completions

Create RowIDs in all tables.

The Tasks table has a Position ID column. The Completions table has a Tasks ID and User ID column.

The Positions table has a multiple relation column to the Tasks table to define which tasks belong to each position.

In the Tasks table, create a query column to the completions table with filters:

  1. Task ID > is > this row > Row ID
  2. User ID > is signed in user

To complete a task, instead of using a checkbox, use a button that writes a row to the Completions table that captures the task’s row ID and the User’s row ID. This will cause the query column to be “not empty” for that user which you can use as a condition to know that the user has completed that task.

I made a video on this earlier this year. Look at 19:00

Glide: 4 Methods for Creating CHECKLISTS

5

Thanks Robert! I’ve watched several of your vids but not this one. Great stuff you’re putting out for us. Thank you!

1 Like