Forum Discussion
Helper Imailto: dynamic mail's using measure
Hi,
It is possible to creat a measure off mailto: whit the mail adress being dynamic created based on client and team.
I have this 3 tables and are linked between them whit relationships.
Is that possible to creat the link mailto: dynamically depending on client and team?
Project table
| project | client | team |
| project_1 | client_1 | team_1 |
| project_2 | client_2 | team_3 |
| project_3 | client_3 | team_1 |
| project_4 | client_1 | team_4 |
client table
| client | client mail |
| client_1 | cliente_1_user1; client_1_user_2; client_1_user3; |
| client_2 | client_2_user1; |
| client_3 | client_3_user1; cliente_3_user2; |
and team table
| team | team member's |
| team_1 | user_1; user_2; |
| team_2 | user_3; user_4; |
| team_3 | user_1; user_5; |
| team_4 | user_6; |
2 Replies
- v-chenwuz-msft
Community Support
Hi wolfy_ ,
The best way is to unpivot team table and client table. Let the table looks like this:
team team member's team_1 user_1 team_1 user_2 team_2 user_3 team_2 user_4 team_3 user_1 team_3 user_5 team_4 user_6 Then use function CONCATENATE() or CONCATENATEX() to get the result.
But what the link looks like?
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
wolfy_Hi, the link would be a mailto: so when I click on the projectID link it will open a new mail whit all the necessary parties, client, and team menbers mail's
