Dear Colleagues,
I started working on the email that can be sent from alteryx to people who are in the report.
The report looks like this (fake data)
| Full name | User email | Training title | Training hours | training link |
| John, Kowalski | john.kowalski@ | training 1 | 0.70 | http://.......1 |
| John, Kowalski | john.kowalski@ | training 2 | 0.50 | http://.......2 |
| Anna, Smith | anna.smith@ | training 1 | 0.70 | http://.......1 |
I want to send one email to each person with list of courses that are missing. I managed to add a report text to adjust my email, but I still need to some changes. Therefore I have following questions.
1. How to set up the email based on the report above so there is only one email to John, Kowalski with information about both courses in the table.
2. How to change the link so the address is not that long (maybe there is an option to change a link to an icon, or add a training link on the training title)
3. How to insert a table (or maybe there is some other solution) so it is clear what is training title , what is the training length and what is the link. Currently I see this in my final email:
Training Tittle Training length in hours Training link
2019 fake name training curriculum 2.00 https://link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link link While it would be great to have sth like this (training title is also a link to the course) for John, Kowalski
Training Title Training length in hoursTraining 1 0.70
Training 2 0.50
or like this:
| Training Title | Training length in hours | link |
| Training 1 | 0.7 | link1 |
| Training 2 | 0.5 | link2 |
Thank you in advance for any advice!
Asia