Private chat & signed-in user

I am trying to enhance my app for the private chat function and I found a similar example in the web. (How to build private chat on Glide) I tried to implement it in the similar way. Although it worked, I am not sure why it works in the way it worked. It checked who are signed in and the flag (true/false) is automatically judged based on the users are signed in or not. However, it seems that the flag got a different data in each user. One has true and another has false at the same time.
Does the glide allocate a column for each user so that each user can have different value for the column in the same spreadsheet? Also does the signed-in user validation differs by each user. For example UserA is signed in and the column is recognized as UserA is signed in if it looked from UserA. On the other hand from UserB, UserA is not a signed-in user even though UserA is signed in at that time. Is there such possibility?

Can anyone hlep me on this please?


I think you might be looking for User Specific Columns


Thx for very useful information.
Having said that, the specific column I am referring is not Text, but “If-Then-Else” column type and there is no “Column is user-specific” in the configuration screen. It check if the user in a different column is signed-in or not.

Does it mean “If-then-else” column type is always “user-specific”?

If you can still help me it is great.


It depends.
If an if-then-else column references a user specific column, then yes it will be user specific.

Thx. Unfortunately none of them is “user-specific column”.

My question is

  • there is two columns. One contains the email of sender of chat. The other has the email of receiver.
  • there is another column (let’s say ColumnX) which checks these users are signed-in user or not using If-Then-Else column type with “is signed-in user” condition.

for example the value the row in sender is User-1 and the receiver is User-2. There is another user User-3. When three of them are signed in. if I look the sheet as User-1, then the ColumnX is true which is correct. However if I check as User-3, the ColumnX is false although User-1 is actually signed in by a different device.

Do you know why it is like this?


I think I understand.

When you are viewing the app as User 3, then User 3 becomes the “signed-in” user.
If the if-then-else column is comparing the “signed-in user” to each of your sender and receiver columns (user 1 and user 2), then it should return only return true if you are viewing as either of those 2 users. But as you are viewing as User 3, there is no match and so it returns false.

Does that make sense?

Yes, it answered my question. Thx.
It seems that if any column that uses signed-in user condition is a user-specific column based on your explanation. Is my understanding correct?

mm, yes, I suppose so. Although I’d never really thought of it that way :slight_smile:

Thx a lot! it was very helpful. Many many thx!!