🤔 Row Owners vs. User Specific Columns

[Darren_Murphy]

@KPT

I thought I could just do a lookup on the user email address in every table and make that a row owner, but thats not possible.

Correct. This is because computed columns (eg. lookup columns) are evaluated on the client device after all data has been downloaded. And by that time it’s too late to apply row owners.

@KPT

I thought I could just do a lookup on the user email address in every table and make that a row owner, but thats not possible. I’m wondering what will happen if I add all the email addresses from each user automatically during creation created, and the user then decides to change his or her email address? I imagine that is a no-go as they would loose the rows with their old email in or is there another strategy for that?

Yes, if a user changes their email address then they would lose access to all owned rows. You’d need to update all rows with their new email address. But, how often do your users change their email address? (I haven’t changed mine in 30+ years )