Write to email column (in users table) via relation possible?

[nathanaelb]

I believe this is expected behavior but I just want to check:

In the users table, I have a list of people with empty emails (which I’ll call “people” or “person”) and a list of users with emails with no other information (which I’ll call “user”). Usually one user email will need to be merged with one of the people.

Do we agree that once a link/relation is established between a user and person to be merged (the person’s row ID in the row of the user to be merged with), we cannot write the user’s email to the person’s via the relation?

The way around this would be to copy-paste the user’s email to the person’s, either in a table or via text entry component?

[Jeff_Hager]

Are you saying “cannot write” because of the protected status of emails and roles in the user table? If so, then yes I agree you probably couldn’t update the email…at least within the app itself. Possibly through external ways though.

Would it be better to merge the other way and move all of the people data in the user row?

[nathanaelb]

@Jeff_Hager

Would it be better to merge the other way and move all of the people data in the user row?

Indeed indeed, I’ll try that, and hopefully it’ll work that way.

(And yes that’s what I meant, that I cannot write to an email column through the app.)