Need help with loop and concatenating values for email

Ask for Help
1

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

1 Like
2

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.

2 Likes
3

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

1 Like
4

Do your journal entries have a Date column?
If so, you can use that in a filter on the Query.

3 Likes
5

Can you show us some screenshots on what you have so far?

2 Likes
6

image
image935×124 13.8 KB

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!

1 Like
7

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!

1 Like
8

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.

You don’t need a lookup column. A Joined List can directly pull from the relation or query without any steps in between.

3 Likes
9

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
image567×687 37.4 KB

1 Like
10

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!

2 Likes
11

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.

2 Likes
12

Ah sorry, what do you mean by there? In the wfl or in the journal table? THX

1 Like
13

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.

2 Likes
14

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?

1 Like
15

Can you show us how you’re adding the “link”?

16

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
image359×470 18.8 KB

17

THX for stepping in!! - answer see above!

18

Does the link appear in the cell values of this template column?