How can I aggregate columns

Ask for Help
1

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!!!

2

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.