# Collection component disapear randomly from some devices

**URL:** https://community.glideapps.com/t/collection-component-disapear-randomly-from-some-devices/72495
**Category:** Ask for Help
**Created:** [April 11, 2024, 5:08pm UTC](https://community.glideapps.com/t/collection-component-disapear-randomly-from-some-devices/72495 "2024-04-11T17:08:54Z")
**Posts on this page:** 10
**Page:** 1

<div class="post-metadata">

### Author: ![bryan\_julon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bryan_julon/32/62555_2.png) [@bryan\_julon](https://community.glideapps.com/u/bryan_julon)
#### Post date: [April 11, 2024, 5:08pm UTC](https://community.glideapps.com/t/collection-component-disapear-randomly-from-some-devices/72495/1 "2024-04-11T17:08:54Z")

</div>

I have a page where there are 2 collection components. The first filtered so that only this week’s deliveries appear. And the other filtered so that next week’s deliveries appear.  
The error that appears randomly is that the first collection keeps disappearing from some devices. For example, there are 5 users who use the app, and when the error occurs there are 2 or 3 who no longer see the first collection while the others see everything normal.

Support no longer responds to me because they can’t find the reported error, I don’t even check it from my smartphone or PC, but there are users I’ve seen that it doesn’t work for them and it does for me. We have updated and modified the table and filters in various ways but the same problem still arises.

Has something similar happened to anyone?

 ![bug collection table randomly disapear](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e0fc5a52d0db46ce6499c16cb62e14c0b31bec62.jpeg)

---

<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: [April 11, 2024, 5:21pm UTC](https://community.glideapps.com/t/collection-component-disapear-randomly-from-some-devices/72495/2 "2024-04-11T17:21:22Z")

</div>

How do you determine whether deliveries are this week or next week?

For those users that have the problem, are they all using the same type of device?

---

<div class="post-metadata">

### Author: ![bryan\_julon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bryan_julon/32/62555_2.png) [@bryan\_julon](https://community.glideapps.com/u/bryan_julon)
#### Post date: [April 11, 2024, 5:47pm UTC](https://community.glideapps.com/t/collection-component-disapear-randomly-from-some-devices/72495/3 "2024-04-11T17:47:58Z")

</div>

Hi Darren!

To determinate the week i use the type “formate date”:  
\*\*Name: thisWeek \*\*  
**Date:** Current date time  
**Format:** yyyyW  
 ![thisWeek](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/5/5505195d7b247746eaa2be7d57ca1cf1255b7b66.png)

To determinate next week, i use the type “Math”:  
thisWeek+1  
 ![nextWeek](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/465771766059d4d3695273585bb342c6bd432458.png)

Users who have the problem always are 3:  
1°: Used on Desktop device, with windows 11.  
2°: Used on Desktop device, with macOS  
3°: Used on Mobile device iphone 12 pro, with iOS.

When the problem is on, i can’t see the problem from my devices:  
Me: Used on Desktop device, with windows 11.  
Me: Used on Mobile device iphone 15, with iOS.

---

<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: [April 11, 2024, 6:32pm UTC](https://community.glideapps.com/t/collection-component-disapear-randomly-from-some-devices/72495/4 "2024-04-11T18:32:11Z")

</div>

That’s probably it. Those built in date manipulation plugins don’t play well on all devices. You are better off using a math column to get what you need. I’ve never trusted the Format Date column.

This week  
`Year(Date)10^4+Weeknum(Date)`

Next week  
`Year(Date+7)10^4+Weeknum(Date+7)`

---

<div class="post-metadata">

### Author: ![bryan\_julon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bryan_julon/32/62555_2.png) [@bryan\_julon](https://community.glideapps.com/u/bryan_julon)
#### Post date: [April 11, 2024, 6:47pm UTC](https://community.glideapps.com/t/collection-component-disapear-randomly-from-some-devices/72495/5 "2024-04-11T18:47:57Z")

</div>

Yes, i used this way before. I dind’t use math because that get me this kind of problem.

Sunday week number is different.  
 ![weekNum](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/0/203f5d8d961cf923e628c45dfaefeac40e3c9686.png)

I think if I go back to using this route.

---

<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: [April 11, 2024, 6:56pm UTC](https://community.glideapps.com/t/collection-component-disapear-randomly-from-some-devices/72495/6 "2024-04-11T18:56:21Z")

</div>

Weeks are typically structured as Sunday first, where Sunday is day 1 and Saturday is day 7 in a single week. Let me think about this for a bit. I’m sure there is a way to structure the math to account for a Monday first week, but I want to test out some ideas first.

---

<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: [April 11, 2024, 7:40pm UTC](https://community.glideapps.com/t/collection-component-disapear-randomly-from-some-devices/72495/7 "2024-04-11T19:40:55Z")

</div>

I think this will work, but I’m a little leary about how it will react at the beginning or end of the year since week numbering is heavily reliant on Sunday being the first day of the week. Sunday may fall into the wrong year. (I did not test this thoroughly.)

This Week

```auto
Year(Date-Mod(WeekDay(Date),2))*10^2
+
WeekNum(Date-Mod(WeekDay(Date),2))

```

Next Week

```auto
Year(Date+7-Mod(WeekDay(Date+7),2))*10^2
+
WeekNum(Date+7-Mod(WeekDay(Date+7),2))

```

The alternative is probably some javascript to handle it, or breaking it down into multiple columns…a math column to get YYYYW, another math column to get the weekday number, an if column that returns if Sunday and 0 for other days, and another math column to subtract that IF column value from the YYYYW value.

---

<div class="post-metadata">

### Author: ![bryan\_julon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bryan_julon/32/62555_2.png) [@bryan\_julon](https://community.glideapps.com/u/bryan_julon)
#### Post date: [April 11, 2024, 8:19pm UTC](https://community.glideapps.com/t/collection-component-disapear-randomly-from-some-devices/72495/8 "2024-04-11T20:19:32Z")

</div>

Really interesting your solution,

i guess i’ll get the second one. Because as you say, at the beginin and the end of the year surly there will be some bug.

I’ll use 3 col to get sunday on the same week.  
On the table with the dates, i’ll use these 3 coll to put sunday and the other days on the same week.

1° col: Type math (Get all weeks -1)

Math

> Year(date)\*10^2+WeekNumb(date)-1

2°col: Get the name of every day to filter by sunday

Format Date

> Format(cccc)

3°col: Filter sundays

> If (date name=Sunday) then (weekNum-1)  
> else (weekNumb)

In this way i get sundays in the same week for every day, without bugs at the end of the year. (theoretically😥)

---

<div class="post-metadata">

### Author: ![bryan\_julon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bryan_julon/32/62555_2.png) [@bryan\_julon](https://community.glideapps.com/u/bryan_julon)
#### Post date: [April 15, 2024, 7:55am UTC](https://community.glideapps.com/t/collection-component-disapear-randomly-from-some-devices/72495/9 "2024-04-15T07:55:03Z")

</div>

Even using only math col the problema appear again. Someone have the same problem?

It’s local the problem, when it happens i see how the table disappear on my client devices but in my devices i see all ok.

My client

 ![bug client side](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/e/7e4481767de05d54c414bf7baea5df34e0f6274d.jpeg)

My device when the problem happpens

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/c/7cf2617c03781dfbae6554a3961bf0b357432766.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: [April 15, 2024, 11:56am UTC](https://community.glideapps.com/t/collection-component-disapear-randomly-from-some-devices/72495/10 "2024-04-15T11:56:27Z")

</div>

Show us how everything is configured. Show us the configuration for the filter for each collection. Show all the table columns used in each of the filters, and how each of those columns are configured.

This should just work but something is being overlooked and we probably won’t see it until we have screenshots or a video of everything and how it’s all configured.
