# How can I aggregate columns

**URL:** <https://community.glideapps.com/t/how-can-i-aggregate-columns/83129>\
**Category:** Ask for Help\
**Created:** [July 12, 2025, 9:57pm UTC](https://community.glideapps.com/t/how-can-i-aggregate-columns/83129 "2025-07-12T21:57:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![JB2806](https://avatars.discourse-cdn.com/v4/letter/j/f6c823/32.png) [@JB2806](https://community.glideapps.com/u/JB2806)\
**Post date:** [July 12, 2025, 9:57pm UTC](https://community.glideapps.com/t/how-can-i-aggregate-columns/83129/1 "2025-07-12T21:57:19Z")

</div>

Hello,  
In a table Missions, I have 6 columns (Monday to Saturday) with queries listing the users available on that day. In a 7th column I would like to have all the users available at least one day. Next step is sending them an email. How can I do it (Having each user only once to avoid sending several times the same email to a user)? I tried joined-list but it works on only one column.  
Thanks!!!

---

<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:** [July 13, 2025, 12:26am UTC](https://community.glideapps.com/t/how-can-i-aggregate-columns/83129/2 "2025-07-13T00:26:14Z")

</div>

Assume you have 6 available boolean columns for 6 days, I think you can:

- Add an If-Then-Else column, if “Monday Available” is checked (assuming it’s a boolean) then true, do the same thing until “Saturday Available”.
- Query the Users table and filter where the If-Then-Else column is checked (or insert your own logic here to determine which users are available at least one day).
- Have a joined list column to return a list of emails on top of the query.
- Send the email to that joined list of emails.