Ok, based on your earlier screenshots, I was under the impression that the Unique sheet was just a copy of your user profile sheet and you were using it. Instead you are building it from the Vocab sheet? Is there any reason you don’t just use a user profile sheet and let Glide fill it whenever a new user signs in? That way it’s unique on its own as glide will only fill it with a unique email once.
1 Like
Well Unique tab is very much the user profile too. I created a new spreadsheet and named user profile “Unique”.
Considering unique tab Users profile and as you said it is unique its own way on glide, how to calculate the total words for each user in Data Editor then?
To be honest, I would personally enable the user profile feature in glide and let Glide fill the user profile sheet when new users sign in. Then I would create a relation and rollup in glide to count the number of words.
That should be it.
I think we are overcomplicating things with all the extra sheets and steps. I think you only need a profile sheet and a vocab sheet to accomplish what you want. Going back to my first post in this thread, I think you are running into issues because you are using a combination of a UNIQUE formula and checkbox validation, which appears to cause weird issues in the Google sheet because it can add extra rows. I would rather address that problem first, by removing the stuff we don’t need, before moving on to the counts for the progress bar.
1 Like
Sounds better.
I just removed unique tab now.
For now I only have user profile and vocab!
-
Profile tab contains name, email address and image columns.
-
Vocab contains as shown in screenshot
Which columns I should create relation between and where to start? Kindly guide me in details
So now you should be able to create a relation column in the Profile sheet that will link the profile email to the email in the Vocab sheet. Once you do that, you should be able to create a Rollup column and set it to count the number of rows in the relation. This should be your number of words for each user. You should then be able to use that rollup column for your progress bar value.
If you don’t currently have email in your Vocab sheet, then I would add a column for it and use the email special value component in the form to automatically fill the email of the signed in user when they submit the form.
It works. Actually I made a copy first then I did the following:
- I deleted all data validation columns in User tab in google sheet then I created just simple column in which whenever I switch on on glide, it makes it true on google sheet specifically to that user on both google sheet and editor.
- I deleted all rows in User tab to the point that no more space available so whenever a user signs in, google sheet creates a new row automatically and it works.
- I also deleted Unique column since everything is done on Glide.
Based on your idea about how to calculate total words, it works too. But since I already have users signed in, I had to add their emails in Vocab tab next to their names manually so Glide can identify them. I ran multiple tests and they totally went well.
Thank you so much Jeff for your patience and help, highly appreciated.
1 Like
Nicely solved @
1 Like