# Collection not showing in Published App

**URL:** <https://community.glideapps.com/t/collection-not-showing-in-published-app/55863>\
**Category:** Report a Bug\
**Created:** [December 19, 2022, 8:28am UTC](https://community.glideapps.com/t/collection-not-showing-in-published-app/55863 "2022-12-19T08:28:57Z")\
**Posts on this page:** 18\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [December 19, 2022, 8:28am UTC](https://community.glideapps.com/t/collection-not-showing-in-published-app/55863/1 "2022-12-19T08:28:57Z")

</div>

Hi, I have created Public Glide Page without any sign in options.

> **[Compliance List](https://compliance.glide.page/dl/submissions)**
>
> An App to show all compliance list for your business entity.

When looking in editor, it shows the entries.  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/1/c10392e28b4ca5ce49deae2de756152b67c8accf.png)

Whereas when we go to actual published app, its not showing any entry.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/7/c720a646d74a8cae026f5b63ec52ffdc041e2bc6.png)

Am I missing something?

Flow of my Page is, User will fill up certain values in Form, on Submit, it will add Row in Submission Table, Clears the value of “this item”.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/a/fafc4ee1e81eb5cee740211cc775dd945c27935e.png)

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/2/82683f1bd8e58e4cf164b84fe159773b009453c4.png)

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/f/af1a475da6051a89724419b33c32ac710675df46.png)

Is this something I am not doing correct?

After looking in Editor, looks like, the Row in Submission table is also getting cleared. Don’t know why? Can someone help?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 19, 2022, 9:11am UTC](https://community.glideapps.com/t/collection-not-showing-in-published-app/55863/2 "2022-12-19T09:11:01Z")

</div>

Why are you clearing the values in the current row?

The only time you would normally do that is if you were using a custom form with user specific columns. Is that the case?

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [December 19, 2022, 9:18am UTC](https://community.glideapps.com/t/collection-not-showing-in-published-app/55863/3 "2022-12-19T09:18:49Z")

</div>

> [@Darren\_Murphy](#):
>
> The only time you would normally do that is if you were using a custom form with user specific columns. Is that the case?

Hi Darren, thanks for replying. Yes I am using Custom form but without user specific columns.

I actually created this App using this template. [Glide Templates | Multi-step Form | Create a No Code App](https://www.glideapps.com/templates/multi-step-form-va)

What should I do in that case?

I changed the actions little bit, but it still not showing in published app.

Screenshot of data editor

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/0/40d65586ddeb30a41628c78b68cd57eb20e3e44a.png)

Screenshot of Editor  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e689df6161b9cf8ab6c05dbb7e409dde1ddf1187.png)

Screenshot of published app

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/f/ff8c167fd1fc1ce2f200cb42ce51f6e0ab391062.png)

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [December 19, 2022, 9:33am UTC](https://community.glideapps.com/t/collection-not-showing-in-published-app/55863/4 "2022-12-19T09:33:18Z")

</div>

Hi @Darren_Murphy

I have recorded the video of how it is working.

> **[Compliance List · Glide - 19 December 2022](https://www.loom.com/share/aeed02c5a32542e9870d8352b1bf32a5)**

Looks like a bug.

All those entries which are visible in Editor were added inside of Editor (and not the published app). All entries which are added through Published App are not visible anywhere.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 19, 2022, 9:34am UTC](https://community.glideapps.com/t/collection-not-showing-in-published-app/55863/5 "2022-12-19T09:34:58Z")

</div>

> [@Pratik\_Shah](#):
>
> Yes I am using Custom form but without user specific columns.

Actually, no. Your columns _are_ user specific. You can tell this from your data editor screen shot:

 ![Screen Shot 2022-12-19 at 5.27.35 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/4/a43000a8718eb1ef3a959b630ceefa1f330f97da.png)

Are you viewing the Published App as the same user that submitted the form? If you’re not, then you won’t see anything.

Anyway, you are adding rows to a table that contains all User Specific columns, which is almost certainly not what you should be doing.

I just downloaded that template to take a look. Which table are you adding rows to - the Form table or the Submissions table?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 19, 2022, 9:37am UTC](https://community.glideapps.com/t/collection-not-showing-in-published-app/55863/6 "2022-12-19T09:37:53Z")

</div>

> [@Pratik\_Shah](#):
>
> All those entries which are visible in Editor were added inside of Editor (and not the published app). All entries which are added through Published App are not visible anywhere.

The problem is with your Submissions table.  
Because all those columns are user specific, each user will _only_ see rows that they created themselves.

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [December 19, 2022, 9:39am UTC](https://community.glideapps.com/t/collection-not-showing-in-published-app/55863/7 "2022-12-19T09:39:07Z")

</div>

Thanks @Darren_Murphy .

Got it, I guess it is creating problem because I actually edited existing user-specific columns of template to my use and did not changed the user-specific settings.

> [@Darren\_Murphy](#):
>
> The problem is with your Submissions table.  
> Because all those columns are user specific, each user will _only_ see rows that they created themselves.

That looks correct. My Bad.

Thank you so much for help.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 19, 2022, 9:42am UTC](https://community.glideapps.com/t/collection-not-showing-in-published-app/55863/8 "2022-12-19T09:42:38Z")

</div>

In the original template, the columns in the Submissions table are not user specific.

 ![Screen Shot 2022-12-19 at 5.41.38 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/7/a77b193d5eec5a0a18edd65af496b639a0909789.png)

If you set it up like that, it should work fine.

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [December 19, 2022, 10:30am UTC](https://community.glideapps.com/t/collection-not-showing-in-published-app/55863/9 "2022-12-19T10:30:09Z")

</div>

Thank you. It’s working now perfectly.

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [December 19, 2022, 10:32am UTC](https://community.glideapps.com/t/collection-not-showing-in-published-app/55863/10 "2022-12-19T10:32:21Z")

</div>

@Darren_Murphy I need one more help.

As soon as the custom form is submitted, can I redirect the user to the detailed screen of his/her submitted entry?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 19, 2022, 10:44am UTC](https://community.glideapps.com/t/collection-not-showing-in-published-app/55863/11 "2022-12-19T10:44:38Z")

</div>

You could probably do a Show Details Screen or Show New Screen with your Submissions table as the target, and filter it to show the last row.

That may fall down if you have multiple users submitting at the same time. If that’s the case you’re best adding a “CreatedBy” column in your Submissions table (if you don’t already have one), and use that as an additional filter.

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [December 20, 2022, 7:11am UTC](https://community.glideapps.com/t/collection-not-showing-in-published-app/55863/12 "2022-12-20T07:11:49Z")

</div>

Thank you @Darren_Murphy for this. I will try and let you know.

> [@Darren\_Murphy](#):
>
> adding a “CreatedBy” column

Are you saying to add user-specific column or just adding normal Createdby column?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 20, 2022, 7:26am UTC](https://community.glideapps.com/t/collection-not-showing-in-published-app/55863/13 "2022-12-20T07:26:56Z")

</div>

Just a normal text or email column, and add the users email address or UserID when the form is saved.

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [December 20, 2022, 7:31am UTC](https://community.glideapps.com/t/collection-not-showing-in-published-app/55863/14 "2022-12-20T07:31:20Z")

</div>

But in that case, how do I filter the records by this field? Because since its custom form, I am clearing all values in Form table as soon as it is submitted. Precisely, there are no values in “this item” records for filtering. I may be wrong here, but please let me know in case if that can be done in any way.

I like your suggestions of filtering the records by latest submission date. I understand multiple submission at the same will create issue. However, there will be hardly any such cases where multiple submissions will be done.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 20, 2022, 7:38am UTC](https://community.glideapps.com/t/collection-not-showing-in-published-app/55863/15 "2022-12-20T07:38:58Z")

</div>

> [@Pratik\_Shah](#):
>
> But in that case, how do I filter the records by this field? Because since its custom form, I am clearing all values in Form table as soon as it is submitted.

The column should be added in your submissions table.  
You don’t need it in your form table, as you can use the value from the user profile when the form is submitted.

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [December 20, 2022, 7:48am UTC](https://community.glideapps.com/t/collection-not-showing-in-published-app/55863/16 "2022-12-20T07:48:44Z")

</div>

> [@Darren\_Murphy](#):
>
> You don’t need it in your form table, as you can use the value from the user profile when the form is submitted.

I do not have user profile. App is public without Sign In option.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 20, 2022, 7:50am UTC](https://community.glideapps.com/t/collection-not-showing-in-published-app/55863/17 "2022-12-20T07:50:53Z")

</div>

Okay, well that changes things.

In that case you have no way to know who created the records, so you will just have to navigate to the last row in the submissions table and hope that it is the correct row.

The only time that might not work is if you have two or more users that submit a record at exactly the same time.

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [December 20, 2022, 7:52am UTC](https://community.glideapps.com/t/collection-not-showing-in-published-app/55863/18 "2022-12-20T07:52:35Z")

</div>

> [@Darren\_Murphy](#):
>
> The only time that might not work is if you have two or more users that submit a record at exactly the same time.

I agree. I like the idea of showing latest submission. That is best I feel considering the situation.

Thank you for all your continuous help. Take care.
