# I dont want the choice to be Monday,Tuesday..i want it like the second pic,how can i do it?

**URL:** <https://community.glideapps.com/t/i-dont-want-the-choice-to-be-monday-tuesday-i-want-it-like-the-second-pic-how-can-i-do-it/78279>\
**Category:** Ask for Help\
**Created:** [December 1, 2024, 2:20pm UTC](https://community.glideapps.com/t/i-dont-want-the-choice-to-be-monday-tuesday-i-want-it-like-the-second-pic-how-can-i-do-it/78279 "2024-12-01T14:20:35Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tobi\_D.Uchiha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tobi_d.uchiha/32/82362_2.png) [@Tobi\_D.Uchiha](https://community.glideapps.com/u/Tobi_D.Uchiha)\
**Post date:** [December 1, 2024, 2:20pm UTC](https://community.glideapps.com/t/i-dont-want-the-choice-to-be-monday-tuesday-i-want-it-like-the-second-pic-how-can-i-do-it/78279/1 "2024-12-01T14:20:35Z")

</div>

[grid]

 ![Screenshot 2024-12-01 221259](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/e/5e66477b0e7c8ff79d3fc9423799de860125a8d2.png)  
 ![Screenshot 2024-12-01 221328](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/0/708c9659c04d36e04137605612305a371ed6bc1c.png)  
 ![Screenshot 2024-12-01 221230](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/8/d8ba97d1542095bede58ece6d2ee6314b0a7d67a.png)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 1, 2024, 2:50pm UTC](https://community.glideapps.com/t/i-dont-want-the-choice-to-be-monday-tuesday-i-want-it-like-the-second-pic-how-can-i-do-it/78279/2 "2024-12-01T14:50:44Z")

</div>

I assume this is you letting users pick a day to book your service, not the service provider choosing days when they are available?

If that’s the case, I think the easiest way for you is to have a table where you have all 7 days in 7 rows.

Then filter the choices by day is included in “OpenDays”.

---

<div class="post-metadata">

**Author:** ![Tobi\_D.Uchiha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tobi_d.uchiha/32/82362_2.png) [@Tobi\_D.Uchiha](https://community.glideapps.com/u/Tobi_D.Uchiha)\
**Post date:** [December 2, 2024, 7:04am UTC](https://community.glideapps.com/t/i-dont-want-the-choice-to-be-monday-tuesday-i-want-it-like-the-second-pic-how-can-i-do-it/78279/3 "2024-12-02T07:04:55Z")

</div>

it’s the service provider choosing days when they are available,and user only can choose days choose by the provider

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 2, 2024, 8:51am UTC](https://community.glideapps.com/t/i-dont-want-the-choice-to-be-monday-tuesday-i-want-it-like-the-second-pic-how-can-i-do-it/78279/4 "2024-12-02T08:51:27Z")

</div>

Yes, then does the solution above fit your use case?

---

<div class="post-metadata">

**Author:** ![Tobi\_D.Uchiha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tobi_d.uchiha/32/82362_2.png) [@Tobi\_D.Uchiha](https://community.glideapps.com/u/Tobi_D.Uchiha)\
**Post date:** [December 2, 2024, 9:06am UTC](https://community.glideapps.com/t/i-dont-want-the-choice-to-be-monday-tuesday-i-want-it-like-the-second-pic-how-can-i-do-it/78279/5 "2024-12-02T09:06:45Z")

</div>

cant filter it because the the source is from other (Day) tables,the OpenDays is from User table

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [December 2, 2024, 3:26pm UTC](https://community.glideapps.com/t/i-dont-want-the-choice-to-be-monday-tuesday-i-want-it-like-the-second-pic-how-can-i-do-it/78279/6 "2024-12-02T15:26:59Z")

</div>

Where are the “days chosen by the provider” stored in your database?

---

<div class="post-metadata">

**Author:** ![Tobi\_D.Uchiha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tobi_d.uchiha/32/82362_2.png) [@Tobi\_D.Uchiha](https://community.glideapps.com/u/Tobi_D.Uchiha)\
**Post date:** [December 2, 2024, 3:40pm UTC](https://community.glideapps.com/t/i-dont-want-the-choice-to-be-monday-tuesday-i-want-it-like-the-second-pic-how-can-i-do-it/78279/7 "2024-12-02T15:40:04Z")

</div>

![Screenshot 2024-12-02 233751](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/ec63d75616551e19c9fd7a7b396f7cde31ed6120.png)  
 ![Screenshot 2024-12-02 233806](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/9/792d9e0217634436d10c24ecb4aa7e7ebb87a6b5.png)  
first pic is from User table,second is Day table,the source for the choice should be from Day table,and filtered by OpenDay in User table.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [December 2, 2024, 8:27pm UTC](https://community.glideapps.com/t/i-dont-want-the-choice-to-be-monday-tuesday-i-want-it-like-the-second-pic-how-can-i-do-it/78279/8 "2024-12-02T20:27:02Z")

</div>

It’s still not clear what you’re trying to achieve.

Are you saying that you want users to ultimately select a date and not a weekday?

If the open days is Monday, Tuesday, Wednesday, do you want them to choose “Monday, December 2”, “Tuesday, December 3”, “Wednesday, December 4”?

---

<div class="post-metadata">

**Author:** ![Tobi\_D.Uchiha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tobi_d.uchiha/32/82362_2.png) [@Tobi\_D.Uchiha](https://community.glideapps.com/u/Tobi_D.Uchiha)\
**Post date:** [December 2, 2024, 11:34pm UTC](https://community.glideapps.com/t/i-dont-want-the-choice-to-be-monday-tuesday-i-want-it-like-the-second-pic-how-can-i-do-it/78279/9 "2024-12-02T23:34:36Z")

</div>

yes

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [December 3, 2024, 12:36am UTC](https://community.glideapps.com/t/i-dont-want-the-choice-to-be-monday-tuesday-i-want-it-like-the-second-pic-how-can-i-do-it/78279/10 "2024-12-03T00:36:10Z")

</div>

You can have a setup like this.

 ![CleanShot 2024-12-03 at 07.34.01](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/f/3f50df931e15b9fcdab81362040c9e4e93dc8e9e.png)

 ![CleanShot 2024-12-03 at 07.34.31](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/e/6ed6aad3abed94d68677244691bae74924b5dbdc.png)

 ![CleanShot 2024-12-03 at 07.34.40](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/f/7f64e3ea656843ce0d77a74c88bfa5cc1c08422f.png)

 ![CleanShot 2024-12-03 at 07.35.45](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/1/31591aaadc50c0886be2ab5bd0f06e7a1bfdd5bf.png)

```auto
N-HOUR(N)/24-MINUTE(N)/24/60-SECOND(N)/24/60/60-WEEKDAY(N)+2+I

```

Extra: You only need to do this if you need the weekday in your data, which I think you need to connect with the availability of providers.

 ![CleanShot 2024-12-03 at 07.35.02](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/a/2ab46988824282beb2db6cb2519bafbf9167ce4b.png)

```auto
const daysOfWeek = ['Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday'];

return daysOfWeek[p1]

```