Viewing Others' Task Progress

[LVaurie]

I’m looking to configure Glide so that a certain type of user can visually access the progress of another user on their personal checklist.

One user has access to a task list, which they check off as they complete tasks. The other type of user does not have any tasks to complete, but needs to be able to see the task lists of other users and which tasks have been checked off.

I haven’t been able to accomplish this yet. Could someone help me?

[Darren_Murphy]

Can you share a screen shot of what your Tasks table looks like in the Data Editor?

[LVaurie]

Here :

[Darren_Murphy]

Okay, the challenge you have there is your completion column is User Specific, which means that each user can only see their own status for each task.

If you want others to see it, you need to take a different approach. One approach would be to instead use a non-user specific Multiple Files column to store an array of UserIDs, and add each users ID to that column as they complete each task.

The below tutorial walks you through how to set that up:

A NEW way to Trebuchet!

Hey fellow Gliders! If you haven’t heard of the Trebuchet method, it’s a term coined by @Lucas_Pires that refers to creating inline arrays. Inline arrays can be an efficient way to create relations without requiring a helper table thereby preserving your row count! Previously, the Trebuchet method required about 6 columns and 2 custom actions (4 updates to add and remove a single item). This new version of the Trebuchet method cuts that usage IN HALF (3 columns, 1 action). …

[LVaurie]

Thank you very much! This is really interesting and informative.
I managed to capture the essence of the desired functionality thanks to this video! Now, I do not understand several elements:

1. Why can’t I have a real action button? I am forced to use a “…” button that appears when hovering over an element to perform the add or delete action (see photo). In the video, we know because of this whether an item has been favorited (in which case, it can be removed) or the opposite.
   

2. Is it possible to do this with a switch? It seems complicated…

3. In the User view, I now display the list of items checked by the user. How could I show some kind of progress indicator in the same interface, or even a complete list of items with a checked/unchecked status?

[Darren_Murphy]

@LVaurie

Why can’t I have a real action button? I am forced to use a “…” button that appears when hovering over an element to perform the add or delete action (see photo).

That’s just the way most collections behave. If you want something that’s more customisable, try experimenting with a Custom Collection or the New Table Collection (this one needs to be enabled from your Glide dashboard under Settings->Previews)

@LVaurie

Is it possible to do this with a switch? It seems complicated…

Unfortunately, no. You need an action, and actions cannot be assigned to switches.

@LVaurie

In the User view, I now display the list of items checked by the user. How could I show some kind of progress indicator in the same interface, or even a complete list of items with a checked/unchecked status?

You mean when viewing a specific users detail screen, yes?
You could do something like the following:

• Add a text column to your Users table. This will be used to temporarily store the ID of the User being viewed. Let’s call is “Selected UserID”
• Modify the action that takes you to a Users detail screen. Make it a custom action with two steps:
  – Set Column Values → User Profile Row → Selected UserID → RowID (of the user that was selected)
  – Show Details Screen → This item
• Now in your Tasks table, create an if-then-else column:
  – If User Array (all the users that have completed the task) contains User Profile → Selected UserID, then “Completed”
  – Else “Not Completed”
• Now you can display the Tasks table in a collection on your User Details screen and use that if-then-else column to show the status of each task for the user being viewed.

[LVaurie]

@Darren_Murphy

If you want something that’s more customisable, try experimenting with a Custom Collection or the New Table Collection (this one needs to be enabled from your Glide dashboard under Settings->Previews)

Thanks!
The list view Collection shown below is the one that suits me best. Is it possible to maintain the two button actions via the checkbox in this collection with an Action to create?

[Darren_Murphy]

@LVaurie

Is it possible to maintain the two button actions via the checkbox in this collection with an Action to create?

No, I’m afraid not.

Did you try the New Table collection style?
I expect with that you can get something very close to what you want.

[LVaurie]

@Darren_Murphy

Did you try the New Table collection style?
I expect with that you can get something very close to what you want.

I haven’t found it

[Jeff_Hager]

You need to enable it in Previews. Then you will see it as a new component.

Preview Features | Glide Docs

[LVaurie]

@Darren_Murphy

Modify the action that takes you to a Users detail screen. Make it a custom action with two steps:
– Set Column Values → User Profile Row → Selected UserID → RowID (of the user that was selected)
– Show Details Screen → This item

How do you do that? I can’t find the way to make a two steps action.

[Darren_Murphy]

[LVaurie]

@Darren_Murphy

If User Array (all the users that have completed the task) contains User Profile → Selected UserID, then “Completed”

Thanks for all of the answers! It helps me navigating and discovering Glide.
At this moment, I built a ‘Multiples Files’ column in my Users table, which is filled each the user check a task, with the task ID.
With that (or not?), how could I make that User Array for the tasks?

[Darren_Murphy]

I believe that is covered in the tutorial that I linked to in one of my earlier replies:

@Darren_Murphy

The below tutorial walks you through how to set that up:

wave Hey fellow Gliders! If you haven’t heard of the Trebuchet method, it’s a term coined by @Lucas_Pires that refers to creating inline arrays. Inline arrays can be an efficient way to create relations without requiring a helper table thereby preserving your row count! Previously, the Trebuchet method required about 6 columns and 2 custom actions (4 updates to add and remove a single item). This new version of the Trebuchet method cuts that usage IN HALF star_struck (3 columns, 1 action). …