Inconsistencies in Relation Columns and Phone Data Entry Issues

Team ID:

  • In the Glide dashoard URL, e.g.
    https://go.glideapps.com/o/qtZ1asZBpzDVxNNaKSld

App ID:

  • In the Glide builder URL, e.g.
    https://go.glideapps.com/app/yCkgUemCXTtzepHwV4R8/layout

Description

  1. Relation Column Issue:
  • In the Data Editor, multiple relation columns appear correctly in a table. However, when viewing the same table in the Data Tab, one of the relation columns appears empty. This inconsistency is random and affects specific relation columns in other tables too.
  • This issue also impacts how data is displayed in components that rely on these relation columns.
  • I have observed this behavior across multiple apps. However, I was unable to replicate the issue in a new app.
  1. Phone Data Entry Issue:
  • Starting around December 21, a Phone column in one of my tables stopped accepting data for some users.
  • For example, when a user submits a form, all other details are captured successfully except for the phone number. This behavior occurs inconsistently, with some users affected and others not.
  • I switched to a custom form and checked the Action History, which shows the phone field having data and the value being set correctly to the column, yet the phone number does not appear in the table.
  • I’ve been unable to identify any differences between users where the phone data is captured successfully and those where it isn’t.

Expected Behavior:

  • Relation columns should display consistent data across the Data Editor, Data Tab, and associated components.
  • The Phone column should accept data reliably for all users when set correctly through forms or actions.

Are you relating to a table under row ownership?

Is the phone number column a user specific column?

1 Like

Hi Jeff,

Thank you for your prompt response and insights!

  1. Relation Column Issue:
    You’re absolutely right, the tables referenced in the affected relation columns now have row owners enabled. I recently restructured parts of the app, and this change must have caused the behavior I was observing. That clears up the mystery; thank you for catching it!
  2. Phone Data Entry Issue:
    Unfortunately, the phone number column is not a user-specific column.

Let me know if there’s anything else I should check or provide to help pinpoint the issue.

Thanks again for your help!

1 Like

I’m not sure what could be happening with the phone number.

Is there anything different about the format of the phone number being entered by users where it works compared to users where it doesn’t work?

Try switching the column to a text column instead of a phone column. There really isn’t anything special about a phone column since it can still works just like a text column.

You could also try creating a new column in case something is weird with the one that is giving you problems.

1 Like

Are you using Glide Tables, Google Sheets or something else? Are edits to other columns saved?

1 Like

Is there anything different about the format of the phone number being entered by users where it works compared to users where it doesn’t work?

Nope, the format is exactly the same.

Try switching the column to a text column instead of a phone column. There really isn’t anything special about a phone column since it can still works just like a text column.

You could also try creating a new column in case something is weird with the one that is giving you problems.

I’ve tried both of these and it is still not behaving as expected. I’m using Glide tables and edits to other columns are saved. I’ve also tried creating a custom action where I set the column values to the user profile row and all the values are set correctly except from the phone number, even in the newly created column.

In the action history, I can see that the action ran successfully and when I inspect the action and expand on the data sent by the “set column values” the phone number is there.

Can you show me your User Profiles configuration please? It should look something like the below:

Of course, here it is :slight_smile:

Okay, thanks. I just wanted to rule out the possibility that you might have inadvertently set the Phone Number column as the Role column, which might have explained the behaviour.

Other than that, I don’t have any suggestions or ideas. If you are on a paid plan, it might be worth your while escalating directly to Glide Support from the chat in the builder.

2 Likes