User Specific column broken in table

Issue

  • I have a table called “Messages” and in it I have a column called “Resolved” which is type (bool) & I have it set to be ‘user-specific’. It’s all been working fine when setting the “Resolved” column for the past month, that is, until I updated Glide. In doing so, it broke the user-specific ‘Resolve’ column, & now I can no longer filter properly the way it used to.

How to replicate

  • Im not really sure how to replicate this issue… but if anybody else is having the same problem please share.
1 Like

Broken in what sense?

You mention that it’s used in a filter - can you elaborate on this please? A few screen shots would be useful.

1 Like

Sure… Heres what Im doing…

I have this resolved column on my messages table that is user-specific:

Then I have on the users table a Query that queries the messages table and filters like so…

And im then displaying it in a slide-out like so:

But the query is not respecting the resolve column

1 Like

Basically, I see ‘resolved’ messages that I wasn’t seeing before the glide update. it was working perfectly fine until the other day

Ok, so I think I found out what’s happening… Basically, for some reason, some (a lot) of my messages’ resolved column have been set to “false”. But why would it do this? Is this some bug, because I know we just hit 10000 messages in the message table, does it break user-specific stuff… Im not sure… I could use some help here :slight_smile:

Are you previewing as a different user, compared to the user you previewed as previously?

1 Like

Nah… Im viewing it as my same user, and also I’ve checked on other users in our app, and they have the same problem.

This is whats happening… I think

But It just happened suddenly and with no explanation. I have no workflows that change the resolve column, and nobody has touched the app

So each User is supposed to have their own version of the state of that Boolean column?

1 Like

Yes… And Isn’t that what the user-specific thing does?

Yes, I just wanted to be sure that was your intention.

Okay, so how is that column set? You mentioned that no workflows set it, but something must cause the state to change?

Yes sorry about that, there is a workflow to change the column status, what I meant was its not a loop workflow.

I have a screenshot here of the workflow I use. Its triggered by a menu button.

Just like this

Okay, no worries.

You say it broke after you updated Glide. Just to be clear, do you mean by clicking on the “Update” button that periodically appears in the bottom left corner of the builder?

1 Like

Yeah thats right, I clicked update button, & it refreshed glide, then I saw a big chunk of the messages where unresolved.

Im not 100% sure it was the update, but it seem a bit of a coincidence

Okay. I think my only suggestion at this point would be to reach out to Glide Support via the Intercom chat in the builder (assuming that you have a paid plan). I don’t know for sure that they’ll be able to help, but it’s worth a shot.

1 Like

Ok, I’ll get in touch with them. Thank you for your help.