# Show information exclusively on a specific day of the week

**URL:** <https://forum.adalo.com/t/show-information-exclusively-on-a-specific-day-of-the-week/19573>\
**Category:** Get Help\
**Created:** [November 12, 2021, 4:20pm UTC](https://forum.adalo.com/t/show-information-exclusively-on-a-specific-day-of-the-week/19573 "2021-11-12T16:20:48Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![ionutilie](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ionutilie/32/35498_2.png) [@ionutilie](https://forum.adalo.com/u/ionutilie)\
**Post date:** [November 12, 2021, 4:20pm UTC](https://forum.adalo.com/t/show-information-exclusively-on-a-specific-day-of-the-week/19573/1 "2021-11-12T16:20:48Z")

</div>

Hello.

I need to display some information only on certain days (e.g. if it is Monday, than Monday information, if Tuesday, than Tuesday information etc.).

For this I created an input field with Current Time (Day of week), which takes the date as the name of the day and if the current day real name is identical to the day to be displayed, then everything is ok. This is also here: [Show a video based on the day of the week](https://forum.adalo.com/t/show-a-video-based-on-the-day-of-the-week/19257)

So, this method is functional, **but it has a limit.**  
The input field from Adalo, adds in the input field with Current Time (Day of week) the current **translated** , **depending on the language of the device / browser used.**

So if the user’s device or browser has a default language other than English, then the information in the input field is not recognized and therefore user info is not displayed.

**Do you have any recommendations?**  
Thanks.

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [November 12, 2021, 4:33pm UTC](https://forum.adalo.com/t/show-information-exclusively-on-a-specific-day-of-the-week/19573/2 "2021-11-12T16:33:09Z")

</div>

Hi @ionutilie,

You can search for the post by @karimoo where he explained how to calculate the _number_ of the day of week. I don’t have it at hand right now, the name looked like “calculating days of week by numbers” or something similar.

Just in case, in my experience that way of calculation always returned 0 - 6 (0 is Sunday, 6 is Saturday), though in the example it is 1-7. But I never had time to explore why is that 🙂

Best regards, Victor.

---

<div class="post-metadata">

**Author:** ![ionutilie](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ionutilie/32/35498_2.png) [@ionutilie](https://forum.adalo.com/u/ionutilie)\
**Post date:** [November 12, 2021, 4:51pm UTC](https://forum.adalo.com/t/show-information-exclusively-on-a-specific-day-of-the-week/19573/3 "2021-11-12T16:51:21Z")

</div>

Hi @Victor  
**Thank you** for your answer.

If this is the post you are referring to [How to derive weekdays from a date](https://forum.adalo.com/t/how-to-derive-weekdays-from-a-date/2374) I did not manage to apply it in my case. And also, I guess that will translate the name of the day.

> [@Victor](#):
>
> Just in case, in my experience that way of calculation always returned 0 - 6 (0 is Sunday, 6 is Saturday), though in the example it is 1-7

Yes, I thought of a relationship between numbers and days, exactly as you mentioned, but it is not yet clear for me how to implement it.

**Thank you!**

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [November 12, 2021, 5:04pm UTC](https://forum.adalo.com/t/show-information-exclusively-on-a-specific-day-of-the-week/19573/4 "2021-11-12T17:04:50Z")

</div>

Hi @ionutilie,

Yes, I mean that post (if you don’t mind please correct your link 🙂 ).

This approach works for me pretty well to decide which day is it now. And after that I can filter offers based on this day ID.  
I use current time in a text label (formatted to be displayed as day) to show the day’s name, no need for additional collection.

Best,  
Victor.

---

<div class="post-metadata">

**Author:** ![ionutilie](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ionutilie/32/35498_2.png) [@ionutilie](https://forum.adalo.com/u/ionutilie)\
**Post date:** [November 15, 2021, 8:32pm UTC](https://forum.adalo.com/t/show-information-exclusively-on-a-specific-day-of-the-week/19573/5 "2021-11-15T20:32:12Z")

</div>

Hello @Victor .  
I still have no clear solution.

I am able to know what day is using Current Time (Day of week) from an input field.  
And if the device / browser show the Current Time (Day of week) in German language and my condition is **if** contains **Sunday** in English language, there will be no match, no list displayed.

 ![Screenshot 11-15-2021 22.25.10](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/f/f20504b532e0584d4ace1aa7f748becd7477cfed.png)

**Thank you.**

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [November 16, 2021, 1:11pm UTC](https://forum.adalo.com/t/show-information-exclusively-on-a-specific-day-of-the-week/19573/6 "2021-11-16T13:11:14Z")

</div>

Hi @ionutilie,

Here is the logic:

1. You add a Number property to Users collection, call it, CurrentDayID.
2. Upon entering Home screen, you calculate CurrentDayID using @karimoo’s method. You will get a number in the range from 0 to 6.

- 0 means Sunday
- 1 means Monday  
…

1. You change the visibility of your Group 15: it will be visible if Logged-in User → CurrentDayID is equal to 0 (as you’d like to show this group on Sundays).
2. You do the same for the other “day-based” groups.

Hope it’ll help. The only potential problem I am aware of is that sometimes (I don’t quite understand when) day ID for Sunday will be 7. But this is app-wide, you just need to test your app on Sunday and see which DayID is returned.

Best,  
Victor.

---

<div class="post-metadata">

**Author:** ![ionutilie](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ionutilie/32/35498_2.png) [@ionutilie](https://forum.adalo.com/u/ionutilie)\
**Post date:** [November 16, 2021, 1:33pm UTC](https://forum.adalo.com/t/show-information-exclusively-on-a-specific-day-of-the-week/19573/7 "2021-11-16T13:33:10Z")

</div>

Thank you @Victor ! 🥳

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [November 16, 2021, 1:33pm UTC](https://forum.adalo.com/t/show-information-exclusively-on-a-specific-day-of-the-week/19573/8 "2021-11-16T13:33:59Z")

</div>

You’re welcome! Don’t hesitate to share the result 🙂

---

<div class="post-metadata">

**Author:** ![ionutilie](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ionutilie/32/35498_2.png) [@ionutilie](https://forum.adalo.com/u/ionutilie)\
**Post date:** [November 17, 2021, 2:36pm UTC](https://forum.adalo.com/t/show-information-exclusively-on-a-specific-day-of-the-week/19573/9 "2021-11-17T14:36:20Z")

</div>

Thank you again @Victor! Brilliant solution @karimoo !

![Screenshot 11-17-2021 16.32.23](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/0/02c138757a5a9385e1be6b544649620f765b1509.png)

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [November 17, 2021, 3:45pm UTC](https://forum.adalo.com/t/show-information-exclusively-on-a-specific-day-of-the-week/19573/10 "2021-11-17T15:45:40Z")

</div>

Great that it worked!  
I wonder why dayID is 4 - it’s Wednesday 🤔

---

<div class="post-metadata">

**Author:** ![ionutilie](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ionutilie/32/35498_2.png) [@ionutilie](https://forum.adalo.com/u/ionutilie)\
**Post date:** [November 17, 2021, 3:51pm UTC](https://forum.adalo.com/t/show-information-exclusively-on-a-specific-day-of-the-week/19573/11 "2021-11-17T15:51:11Z")

</div>

Haha! Greeeat question!  
I am making some tests but it is the right solution.

Now it behaves like Sunday = 1.

- the formula is identical even if I copied it without understanding it.
- I also changed the format to the Date Picker (Date & Time, Picker, Text).  
No change.

If it works after the tests, I’ll keep it that way with this anomaly. 🥳

---

<div class="post-metadata">

**Author:** ![ionutilie](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ionutilie/32/35498_2.png) [@ionutilie](https://forum.adalo.com/u/ionutilie)\
**Post date:** [November 19, 2021, 6:46pm UTC](https://forum.adalo.com/t/show-information-exclusively-on-a-specific-day-of-the-week/19573/12 "2021-11-19T18:46:21Z")

</div>

Hello again @Victor !

I thought the topic is closed, but I tested / verified and the result is a little strange.

In fact, every day, at my local time 15:00 the app and the calculation change the current day to the next day.  
So, for example, until 15:00 I am on **Monday** , from 15:00 I am on Moday + 1 = **Tuesday** according to this calculation …

At my local time 15:00 in Sydney is 00:00, which is the place where you actually move to the next day. I don’t know if this info matters.

Do you have any suggestions in this context?  
**Thank you!**

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [November 20, 2021, 10:06am UTC](https://forum.adalo.com/t/show-information-exclusively-on-a-specific-day-of-the-week/19573/13 "2021-11-20T10:06:09Z")

</div>

Hi @ionutilie,

Welcome to the wonderful world of Adalo’s date&time management 🤣

Could you please provide a screenshot of how do you calculate the DayID? Also, what is your timezone (I assume you’re somewhere in America? or not?)

Best regards, Victor.

---

<div class="post-metadata">

**Author:** ![ionutilie](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ionutilie/32/35498_2.png) [@ionutilie](https://forum.adalo.com/u/ionutilie)\
**Post date:** [November 20, 2021, 1:33pm UTC](https://forum.adalo.com/t/show-information-exclusively-on-a-specific-day-of-the-week/19573/14 "2021-11-20T13:33:49Z")

</div>

> [@Victor](#):
>
> Welcome to the wonderful world of Adalo’s date&time management

🙂

Thank you @Victor !  
This is the screenshot.  
 ![Screenshot](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/2/264acb6d31f0c79807647e4bbf6a4dce25635fcb.png)  
And my current timezone is GMT+2 (Bucharest).

Thank you!

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [November 20, 2021, 6:04pm UTC](https://forum.adalo.com/t/show-information-exclusively-on-a-specific-day-of-the-week/19573/15 "2021-11-20T18:04:08Z")

</div>

Hi @ionutilie,

I believe the reason for the problem is that you are taking the value from the DatePicker directly. Is it “date” or a “datetime” type of picker?  
As a workaround, I’d advice add a “TempDate” property to Users collection, make it a “Date” type. With the first action, update this property by setting the value taken from the DatePicker (this should result in storing the start-of-that-day in GMT+0) format.  
And after use that property as a source for dayID calculation.

Please let me know about the result.

Best,  
Victor.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [November 30, 2021, 6:04pm UTC](https://forum.adalo.com/t/show-information-exclusively-on-a-specific-day-of-the-week/19573/16 "2021-11-30T18:04:51Z")

</div>

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