Found solution thanks to ThinhDinh in private chat.
ThinhDinh in DM:
You can just send a userID over and then use a relation + lookup to get the email
Computed columns are mostly calculated on the client’s side, so if anyone can “hack” your data, they can only get the ID, as far as I aware
Martin_B in DM:
Thanks Thinh. I did exactly that what you said… Save user row ID instead of email and use a relation + look up to display message.
Remaining problem: as long as the user didn’t send a message in this conversation, all the messages are not identified (linked to a user name)… they all appear on the left side of chat view, and under one name…
Workaround=> A button “join chat”, activate visibility for the chat and adds automatically a message in the conversation “username… Just joined”… and then the user can see the chat with properly organised messages.
The messages of the whole conversation appear on the left side of the chat view (not current user side) as we expect.
But without the associated author names…
So the issue here is the author photo? Why do you have it as an image and the author name as a text column? I thought using lookups would make more sense?