# Need help with loop and concatenating values for email **URL:** \ **Category:** Ask for Help\ **Created:** [June 16, 2025, 6:10pm UTC](https://community.glideapps.com/t/need-help-with-loop-and-concatenating-values-for-email/82533 "2025-06-16T18:10:59Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![szfuer](https://avatars.discourse-cdn.com/v4/letter/s/90db22/32.png) [@szfuer](https://community.glideapps.com/u/szfuer)\ **Post date:** [June 16, 2025, 6:10pm UTC](https://community.glideapps.com/t/need-help-with-loop-and-concatenating-values-for-email/82533/1 "2025-06-16T18:10:59Z")
Hi All, being relatively new to glideapps, ad i would need help with contatenating data across rows to send them via mail. I do have a “journal” table where i collect journal entries with dates. (“DateCreated”, “Title”) I an loop i wanted to collect the titels of all entries from today (“DateCreated”, “Title”) and send them as a daily summary via mail. Could someone please point me in the right direction which “data” action i would need to use (and how) in the loop? Or am i on the wrong track please? THX in advance Stefan ---
**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:** [June 16, 2025, 6:27pm UTC](https://community.glideapps.com/t/need-help-with-loop-and-concatenating-values-for-email/82533/2 "2025-06-16T18:27:52Z")
You can try creating a Query filtered by date, and then a Joined List that joins all entries from that query. No need for a loop. ---
**Author:** ![szfuer](https://avatars.discourse-cdn.com/v4/letter/s/90db22/32.png) [@szfuer](https://community.glideapps.com/u/szfuer)\ **Post date:** [June 17, 2025, 3:32am UTC](https://community.glideapps.com/t/need-help-with-loop-and-concatenating-values-for-email/82533/3 "2025-06-17T03:32:40Z")
Jeff, thank you and I have tried around a bit with joined lists (strange design from glideapps - anyway) - and hint how i get the “joined” into an email based on a time trigger? Under data I did not find anything linke “get data”? thx in advance BR Stefan ---
**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:** [June 17, 2025, 3:42am UTC](https://community.glideapps.com/t/need-help-with-loop-and-concatenating-values-for-email/82533/4 "2025-06-17T03:42:15Z")
Do your journal entries have a Date column? If so, you can use that in a filter on the Query. ---
**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:** [June 17, 2025, 11:10pm UTC](https://community.glideapps.com/t/need-help-with-loop-and-concatenating-values-for-email/82533/5 "2025-06-17T23:10:14Z")
Can you show us some screenshots on what you have so far? ---
**Author:** ![szfuer](https://avatars.discourse-cdn.com/v4/letter/s/90db22/32.png) [@szfuer](https://community.glideapps.com/u/szfuer)\ **Post date:** [June 18, 2025, 2:39pm UTC](https://community.glideapps.com/t/need-help-with-loop-and-concatenating-values-for-email/82533/6 "2025-06-18T14:39:15Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/9/5963b10dddb0f94aa80e61c741fe9044235544c1.png) Sure - this is the Journal table and i need to mail a list of todays activities: Datum(Date) - Kategorie (Categorie) THX for all the help by teh way! ---
**Author:** ![Javieri](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/javieri/32/83005_2.png) [@Javieri](https://community.glideapps.com/u/Javieri)\ **Post date:** [June 18, 2025, 3:30pm UTC](https://community.glideapps.com/t/need-help-with-loop-and-concatenating-values-for-email/82533/7 "2025-06-18T15:30:19Z")
I believe you can achieve this with the following approach: If you need a “daily summary notification” showing which journal entries were created today, I recommend starting by creating a **relation column** in the **User table**. This relation should connect today’s date to the `DateCreated` column in your **Journal table**. Make sure to **convert `DateCreated` and `today's date` into a math date** format to ensure the relation works properly. Also, **enable “Match multiple”** in the relation, since there could be multiple journal entries created on the same day. Still within the **User table** , you can then: 1. Add a **lookup column** to retrieve the `Title` from the related journal entries. 2. Create a **joined text column** based on that lookup, using a “newline” as the separator to ensure each title appears on its own line. With this joined text column, you can now set up a _scheduled workflow_ that loops through the User table and sends an email (or notification) containing that text as the daily summary. Hope this helps! ---
**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:** [June 18, 2025, 3:48pm UTC](https://community.glideapps.com/t/need-help-with-loop-and-concatenating-values-for-email/82533/8 "2025-06-18T15:48:05Z")
> [@Javieri](#): > > creating a **relation column** in the **User table** I think a query would be easier because you can avoid the extra math columns. Just filter the query where the date is within Today. > [@Javieri](#): > > Add a **lookup column** to retrieve the `Title` from the related journal entries. You don’t need a lookup column. A Joined List can directly pull from the relation or query without any steps in between. ---
**Author:** ![szfuer](https://avatars.discourse-cdn.com/v4/letter/s/90db22/32.png) [@szfuer](https://community.glideapps.com/u/szfuer)\ **Post date:** [June 18, 2025, 3:58pm UTC](https://community.glideapps.com/t/need-help-with-loop-and-concatenating-values-for-email/82533/9 "2025-06-18T15:58:37Z")
Hi - ok i am getting confused a bit here. I do have a “query column” which links todays Journal entries to a column in the same table Field called “TodaysEntries” \> currently there are two linked items in that field - sorry, I think i now would need help on how to get the details out of that field (like title and kategorie) into a mail? If i do this with a lookup in the workflow i do only get the linked category term \> “Gedanken Gedanken” is then in the mail. BIG THX again. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/d/1dadf1ba62dcaedda9d67a0ed4f4f0d959da30fb.png) ---
**Author:** ![Javieri](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/javieri/32/83005_2.png) [@Javieri](https://community.glideapps.com/u/Javieri)\ **Post date:** [June 18, 2025, 4:07pm UTC](https://community.glideapps.com/t/need-help-with-loop-and-concatenating-values-for-email/82533/10 "2025-06-18T16:07:03Z")
> [@Jeff\_Hager](#): > > You don’t need a lookup column. A Joined List can directly pull from the relation or query without any steps in between. Thanks a lot for the insights, really helpful! I tried to break it down step-by-step so I could understand how everything connects. I used the relation + lookup + joined list method just to make the logic clearer for myself, but I can see how using a query and going straight to a joined list would simplify things. It sounds much cleaner and saves some columns! ---
**Author:** ![Javieri](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/javieri/32/83005_2.png) [@Javieri](https://community.glideapps.com/u/Javieri)\ **Post date:** [June 18, 2025, 4:12pm UTC](https://community.glideapps.com/t/need-help-with-loop-and-concatenating-values-for-email/82533/11 "2025-06-18T16:12:14Z")
> [@szfuer](#): > > I think i now would need help on how to get the details out of that field (like title and kategorie) into a mail? Yes, you can add a join column there and pull which column you want to use as the body to be sent as a notification. ---
**Author:** ![szfuer](https://avatars.discourse-cdn.com/v4/letter/s/90db22/32.png) [@szfuer](https://community.glideapps.com/u/szfuer)\ **Post date:** [June 18, 2025, 4:19pm UTC](https://community.glideapps.com/t/need-help-with-loop-and-concatenating-values-for-email/82533/12 "2025-06-18T16:19:20Z")
Ah sorry, what do you mean by there? In the wfl or in the journal table? THX ---
**Author:** ![Javieri](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/javieri/32/83005_2.png) [@Javieri](https://community.glideapps.com/u/Javieri)\ **Post date:** [June 18, 2025, 4:33pm UTC](https://community.glideapps.com/t/need-help-with-loop-and-concatenating-values-for-email/82533/13 "2025-06-18T16:33:48Z")
You can do it in either of those places, the workflow or the table. However, the solution described previously is to make the addition to the table. ---
**Author:** ![szfuer](https://avatars.discourse-cdn.com/v4/letter/s/90db22/32.png) [@szfuer](https://community.glideapps.com/u/szfuer)\ **Post date:** [June 18, 2025, 4:46pm UTC](https://community.glideapps.com/t/need-help-with-loop-and-concatenating-values-for-email/82533/14 "2025-06-18T16:46:53Z")
Awesome. thx. works. trying to add a link to the list it seems not getting sent via mail. Any escape charaters i need to use in a template coumn or for the mail function please? ---
**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:** [June 19, 2025, 1:16am UTC](https://community.glideapps.com/t/need-help-with-loop-and-concatenating-values-for-email/82533/15 "2025-06-19T01:16:02Z")
> [@szfuer](#): > > trying to add a link to the list it seems not getting sent via mail. Any escape charaters i need to use in a template coumn or for the mail function please? Can you show us how you’re adding the “link”? ---
**Author:** ![szfuer](https://avatars.discourse-cdn.com/v4/letter/s/90db22/32.png) [@szfuer](https://community.glideapps.com/u/szfuer)\ **Post date:** [June 19, 2025, 4:04am UTC](https://community.glideapps.com/t/need-help-with-loop-and-concatenating-values-for-email/82533/16 "2025-06-19T04:04:26Z")
GM sure - this is how the template field is constrcuted. It’s for the mail HTML body - tried with html markup and without - the link does not appear in the mail (date and category does). ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/5/85c8c9c31edf36c662c9f6c5a73d91f738037c17.png) ---
**Author:** ![szfuer](https://avatars.discourse-cdn.com/v4/letter/s/90db22/32.png) [@szfuer](https://community.glideapps.com/u/szfuer)\ **Post date:** [June 19, 2025, 4:17am UTC](https://community.glideapps.com/t/need-help-with-loop-and-concatenating-values-for-email/82533/17 "2025-06-19T04:17:03Z")
THX for stepping in!! - answer see above! ---
**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:** [June 19, 2025, 10:56pm UTC](https://community.glideapps.com/t/need-help-with-loop-and-concatenating-values-for-email/82533/18 "2025-06-19T22:56:38Z")
Does the link appear in the cell values of this template column?