How to mail data best (with table and header with parts of data)
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dear Community,
I tried to find a solution already in the forum, unfortunately without success. I am quite new here and I hope I do not bother you with too simple questions.
I have an excel table with some rows, each row containing some data (like incident number and date, ...). Now I want to mail these data. I use the "Table Tool", which put all data in one table. This table appears in the mail body.
So far so good. Now I want to use some of the data for creating the email header. But I am not able to access to the data any more because they are all in the table now. The "Header field" in "Mail Tool" allows me to enter regular text but when I check "Use field" it says [no valid fields]
What would be the best way to build a mail header like:
"New: Incident [incident number] happend on [date]"
Many thanks in advance 🙂
Stephan
Solved! Go to Solution.
- Labels:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can use a technique like this.
Join your table back to your data. This way the original fields are available in the email tool. In this simple example I only have one record in the input. If you have multiple you'll want to summarize your data before joining to avoid sending multiple emails.
Dan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
We all started somewhere. For myself, it was the weekly challenges that taught me the most.
Dan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @danilang,
I tried to use your solution today. Unfortunately without success. Maybe I have overseen a detail?
The problem is that I cannot connect both branches correctly.
in join(?) tool (Toolname in German: Mehrere Verknüpfen, English: ???) I have for Input_#1 the choice of all fields of the data set e.g. number. As Input_#2 I only have table. Using number and table will lead to an error message:
German: Zeichenfolgefelder können nur mit Zeichenfolgefeldern verknüpft werden
English: Type mismatch between table and not table data (like number, ...)
I Hope I could explain clearly. Is there some advice for me?
Many thanks in advance
Stephan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I found the detail by myself ... 🙂
In the tool i need to group something.
All grouped data will become a possible input in addition to table.
Now It works. Great.
Thanks again
Stephan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It sounds like your trying to join a string field to a number field. My original solution was a guide to how you would do it and not meant to be used as-is. Here's a new version with multiple incidents in the input. The table is grouped by incident number and then joined to the input table using the incident number. Since the join uses the same field as the key, you won't get the error message.
Edit: Good job, finding the solution.
Dan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @danilang
Thanks for your effort!
Meanwhile I found an alternative too:
All data (except table) which will be needed later has to be grouped.
I grouped number only which worked very well.
Maybe there are some side effects when lots of data will be grouped...???
Stephan
