So, setting up a new app. New user signs up. They add their data. Any data they add on other sheets is controlled too. Do you control that data via their email address or their RowID So far I have always used email, but what happens if a user wants to change their email for any reason. Could the…

Excellent. To sum up. For Row Owner throughout an app, use email address For linking data across sheets use RowID, regardless of whether you are also taking across email address for row owner.

[image] Mishta_P: but what happens if a user wants to change their email for any reason. I ventured down this rabbit hole a few months ago. I got to the point where I had a semi-working solution, but it was very fragile. So in the end I abandoned the idea. If a user asks for their email addre…

I use both, depending on the situation. If Row Owners are needed, I would definitely use email, or at least include it in the data. Otherwise I use Unique ID’s or Row ID’s to link sheets together. If anything, include keys as well as emails in your data until you figure out which works best for y…

Currently the only restriction with RowID is not being able to delete the column via set column. Changing the logged-in-users’ email address is only possible if you create an input to edit. I recommend you don’t, because user-specific columns might get messed up.

[image] Jeff_Hager: If Row Owners are needed, I would definitely use email, or at least include it in the data. Otherwise I use Unique ID’s or Row ID’s to link sheets together 100% agree

@Darren_Murphy I will have a look at that rabbit hole shortly. Although it sounds as though I shouldn’t. @Jeff_Hager @Robert_Petitto On that basis if I am sending data to a new sheet, forward RowID from user profile sheet, and then use lookup to bring over email, as I am typing this I am thinking y…

Good work everyone. Pretty much what I was doing, just nice to have the dream team confirm as such. Hopefully this thread will prove useful for others. Thank you all.

Bumping into this tricky issue now (I am very new to Glide) It does look like the current design of row owner makes it impossible for users to change their email. And on top of this - for some use cases - it also forces the app to pass though the email PII publicly. For instance if a user A wants …

I think the only way that would work would be to utilize the Role setting in user profiles and point it to the Row ID column. Then whenever you create a new row in your tables, you would write the Row ID instead of the email and apply row owners to that column. The scenario you described with priv…

Row Owner - RowID v Email, or other options - discuss

Ask for Help

Jeff_Hager February 5, 2021, 4:54pm 7

Correct. A lookup won’t work for Row Owners, so better to write it to the sheet to begin with.

Row Owner Question

Topic		Replies	Views
Row Owner Question Ask for Help	15	1088	February 11, 2021
Challenges applying Row Owner freely, without formulas - thoughts? Ask for Help	10	502	February 23, 2021
🤔 Row Owners vs. User Specific Columns Community Resources tutorial	6	1761	July 4, 2023
Allowing users to change their email address Ask for Help	22	2740	October 7, 2023
RowID of the Users Table as an alternative email when enabling row owners Feature Requests row-owners	0	242	November 11, 2023

Row Owner - RowID v Email, or other options - discuss

Related topics