I’m working on solution for this thread ( Help designing spredsheet/Glide - Curriculum with many user ) and building it into into this app ( https://concepts.glideapp.io/ ). I think I came up with a really simple solution to use one list of tasks, but display it and filter Finished and Not Finished tas…

This is really clever! I was working on the opposite idea, which is to concatenate all the finished modules into one cell (one per user). But I think your idea may be better. To be clear… You are still making each user, submit a Glide Form for each module completed? What I’m doing now is based …

@Jeff_Hager Yes having the logged in users email as some kind of global variable that you could refer to would be very handy to have.

@Jeff_Hager I just added this feature request based on these ideas. [image] Create a global variable for the logged in user Feature Requests The email of a logged in user is available for Forms. Could you also make it available while creating a filter. Something like b…

To answer your questions: Yes, I’m still making the user submit a form for each module. I added extra data on the form to show which module/task they are on along with a checkbox that they have to check to confirm that they completed it. Feels a little more formal than an empty form page. Yes, I…

thanks very much! I am using query and textjoin (similar to yours to add all the emails of a complete task into one cell) … =textjoin( " , ", true , query ( find all emails that have completed a given task ) All we need now is the Glide Filter function “contatins”.

FYI, I could have sworn that I had allowed the app to be copied as a template. I just noticed that wasn’t the case, but now I’ve allowed the app to be copied.

Good new @mptpro . I think this might be doable now. I can’t fully duplicate it in my concepts app since I have it set to public, but take a look at it again. Make a copy and set to public with email. Then you can set the filter for the completed and not completed lists to signed in and not signe…

Thanks Jeff! It’s sooooo close, however, my cell that indicates completion has many email addresses in it (all the people who have completed the task). So, the “is” filter doesn’t work. If it was “CONTAINS signed-in user” it would most likely work. Thanks again for following-up with this!

No, you can’t use that method like we tried before where we built a delimited list of completed emails. That column can go away. If you look at my example, I added a relation from the Task Details to the Task Response sheet. I then created a Lookup column to pull in all of the emails that have co…

Filter to use Per User email and "contains" operator

Feature Requests

George_B October 4, 2019, 12:18pm 4

@Jeff_Hager I just added this feature request based on these ideas.

Topic		Replies	Views
Filtering By Logged In User Ask for Help	23	4750	February 29, 2020
Send email to filtered users Ask for Help	14	245	December 1, 2022
Help designing spredsheet/Glide - Curriculum with many user Ask for Help	18	964	May 12, 2020
Restrict Information for Certain users Ask for Help	27	1753	February 11, 2020
Need help/best practices for cleaning up my sheet Ask for Help	18	1098	August 5, 2020

Filter to use Per User email and "contains" operator

Related topics