Display whole row from linked table in email

User Talk
1

Good morning,

I have two tables with an 1:n releationship.
I want to send an automatical email where specific values from all n-rows linked to the 1-entry are displayed.

Example Mail:

Hello User,
your have 10 entries:

  1. street, postcode, city [data from row 1]
  2. street postcode, city [data from row 2]
    and so on…

With lookUp ein only managed to get single values and not the whole row.

How can I reach this?

2

Hi @endition and welcome to the forum !
Based on the information you’ve provided, here’s a solution that might work for you:

  • In base 2 (containing the addresses data), create a new column with data summary (formula type column) with the following formula (you’ll have to modify the formula depending on your columns’ names): {street} & ", " & {postcode} & ", " & {city} (so this column will contain street, postcode, city). Call it for example “Data summary”
  • In base 1, create a link formula / lookup to get the data from the “Data summary” column (you can also create a formula column with formula {Base 2.Data summary})

Bests,
Benjamin

3

Thank you very much. That works. This solution did not come to my mind.

Follow on question:
How do I format the output in my mail in an proper way. Standard is a comma separated list. Proper way = One entry per line or unsorted / sorted list.

I tried \n in the formular, but that did not work. I tried a manuell line break, between two “”, because the documentations says it is possible.
That messes up with the automatically added comma.

4

The result type in the formula column is “string”. This result type does not support line breaks or (ordered/unordered) lists.

This is not supported. Please point to the documentation where you found this information. We’ll correct.

5

Interesting that there seems to be no better solution than the formular. I though displaying 1:n is a requirement a lot of solutions need. If you use the page designer, it is possible.

This is not supported. Please point to the documentation where you found this information. We’ll correct.
I interpreted the documentation wrong.

6

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.