Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have a report that has merged fields from a bunch of different tables looking at forms that have been turned in. Basically I scan across the report line and see if a particular employee has turned in all of the forms for a specific project. Each form is from a different data set that I have merged into this one report.
I want to click on an envelope icon an generate an email message that states which of the forms are missing.
I am going to deal with the if/then statements later... right now I am working on just generating an email that by a click on an envelope will call the external desktop email program and insert text into a new email message. I have started with the following code that calls the external email program and generates info in the body section:
GENERATEEMAIL = "mailto:" & [Email] & "?subject=" & [Name] & " :- Forms Due&body=COMPANY%0D
Location, State%0D
%0D
Dear " & [First Name] & ",%0D
%0D
Here are the remaining forms that you need to submit:%0D"
As I said, this works to call the external email program and generate the email message. What I want to do is change the arrow below to a envelope icon.
Is this possible?
Solved! Go to Solution.
Hi @jamiers
Yes, you can change this to an envelope icon.
It appears you have already set the GENERATEEMAIL measure's data category to Web URL.
All that is left to do is:
On your table/matrix visual, go to the Format > Values > URL icon > On
You should then see icons like this in your table/matrix visual:
Regards,
Owen
So, I have that turned on, but you can see the results off to the left are not an envelope. Am I missing a step somewhere?
Would anything else
Hi again @jamiers
The Values > URL Icon setting is correct.
However, the Conditional Formatting > Web URL option is not required, and in fact it should not be available if you have set the measure's Data Category to Web URL.
Can you select the GENERATEEMAIL measure and check that you have set Data Category to Web URL?
Regards,
Owen
Hi @jamiers
Yes, you can change this to an envelope icon.
It appears you have already set the GENERATEEMAIL measure's data category to Web URL.
All that is left to do is:
On your table/matrix visual, go to the Format > Values > URL icon > On
You should then see icons like this in your table/matrix visual:
Regards,
Owen
Thank you. That did the trick. I have this on a column, but that it did the trick. Thanks for the solution!
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |