# Glide data columns are invisible in data editor

**URL:** <https://community.glideapps.com/t/glide-data-columns-are-invisible-in-data-editor/63219>\
**Category:** Ask for Help\
**Created:** [June 27, 2023, 5:35pm UTC](https://community.glideapps.com/t/glide-data-columns-are-invisible-in-data-editor/63219 "2023-06-27T17:35:56Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![JohnB](https://avatars.discourse-cdn.com/v4/letter/j/4491bb/32.png) [@JohnB](https://community.glideapps.com/u/JohnB)\
**Post date:** [June 27, 2023, 5:35pm UTC](https://community.glideapps.com/t/glide-data-columns-are-invisible-in-data-editor/63219/1 "2023-06-27T17:35:56Z")

</div>

I had several variables with the same prefix name, for arguments sake, club\_user1. There were 2 types, (1) @ variable ie type= email, an input data item (2) variable type = lookup (magnifying glass)  
When renaming the Alpha numeric data columns ie type (1), they have disappeared in the data view. However, they are used in the app, and still appear when using the “where used” function on other columns. The app still works. So the data items are in the background somewhere, just not visible in the data editor!  
The obvious solution is that they’ve been renamed and I’ve just not found them… its definitely not that. It appears that it may be a bug to do with having had data items with the same name but a different data type. HELP!

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [June 27, 2023, 5:40pm UTC](https://community.glideapps.com/t/glide-data-columns-are-invisible-in-data-editor/63219/2 "2023-06-27T17:40:22Z")

</div>

> [@JohnB](#):
>
> The obvious solution is that they’ve been renamed and I’ve just not found them

Check and make sure your search in top right of editor is empty. Having some text in the search could be one reason columns are hidden from view

---

<div class="post-metadata">

**Author:** ![JohnB](https://avatars.discourse-cdn.com/v4/letter/j/4491bb/32.png) [@JohnB](https://community.glideapps.com/u/JohnB)\
**Post date:** [June 27, 2023, 5:42pm UTC](https://community.glideapps.com/t/glide-data-columns-are-invisible-in-data-editor/63219/3 "2023-06-27T17:42:40Z")

</div>

ta for the quick reply. That’s not it. Definitely in “where used” but not in the “data editor”.  
Also in the google sheet behind it!

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [June 27, 2023, 5:43pm UTC](https://community.glideapps.com/t/glide-data-columns-are-invisible-in-data-editor/63219/4 "2023-06-27T17:43:33Z")

</div>

If this is attached to a google sheet, sequentially numbering columns will automatically merge them into an array. Are you seeing an array in your data editor? They will still be accessible as individual columns, but also accessible as an array. If you want to keep them separate, then you will need a different meaning structure, or physically separate them in the google sheet.

---

<div class="post-metadata">

**Author:** ![JohnB](https://avatars.discourse-cdn.com/v4/letter/j/4491bb/32.png) [@JohnB](https://community.glideapps.com/u/JohnB)\
**Post date:** [June 27, 2023, 5:50pm UTC](https://community.glideapps.com/t/glide-data-columns-are-invisible-in-data-editor/63219/5 "2023-06-27T17:50:32Z")

</div>

![data_item_missing](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/a/5ac4720cf246723b1bcc09380a0f06ef3bc36787.png)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [June 27, 2023, 5:55pm UTC](https://community.glideapps.com/t/glide-data-columns-are-invisible-in-data-editor/63219/6 "2023-06-27T17:55:31Z")

</div>

Right, but if you search for club\_user without a number, you will see the array called club\_user. That array is a culmination of all columns that begin with club\_user, and end with a number.

Switch the numbers to letters, or move the columns away from each other in the google sheet, and they will separate in Glide.

---

<div class="post-metadata">

**Author:** ![JohnB](https://avatars.discourse-cdn.com/v4/letter/j/4491bb/32.png) [@JohnB](https://community.glideapps.com/u/JohnB)\
**Post date:** [June 27, 2023, 5:57pm UTC](https://community.glideapps.com/t/glide-data-columns-are-invisible-in-data-editor/63219/7 "2023-06-27T17:57:49Z")

</div>

ah! is that the 3 horizontal lines? What’s thrown me, is that the data items did appear as separate columns before I renamed them. They were previously called Club\_user1\_test and Club\_user2\_test, so you’re saying they weren’t recognised as an array because they didnt end in a number?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [June 27, 2023, 6:01pm UTC](https://community.glideapps.com/t/glide-data-columns-are-invisible-in-data-editor/63219/8 "2023-06-27T18:01:52Z")

</div>

It’s a feature because in the old days, there was no glide data editor and everything, including arrays, had to be defined in the google sheet with specific column heading naming conventions. There is also a few cases where you need sheet based arrays, such as assigning multiple Roles to a user, or multiple Row Owners to your data. Certain things that cannot be done with a normal computed column.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [June 27, 2023, 6:02pm UTC](https://community.glideapps.com/t/glide-data-columns-are-invisible-in-data-editor/63219/9 "2023-06-27T18:02:20Z")

</div>

> [@JohnB](#):
>
> so you’re saying they weren’t recognised as an array because they didnt end in a number?

Exactly.

---

<div class="post-metadata">

**Author:** ![JohnB](https://avatars.discourse-cdn.com/v4/letter/j/4491bb/32.png) [@JohnB](https://community.glideapps.com/u/JohnB)\
**Post date:** [June 27, 2023, 6:02pm UTC](https://community.glideapps.com/t/glide-data-columns-are-invisible-in-data-editor/63219/10 "2023-06-27T18:02:56Z")

</div>

thank you. I owe you a beer. Much gratitude.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [June 28, 2023, 6:03pm UTC](https://community.glideapps.com/t/glide-data-columns-are-invisible-in-data-editor/63219/11 "2023-06-28T18:03:41Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
