Customer experience | Sales, Customer Insights,...

Record URL(Dynamic) creates wrong url of the task

(0) Share

Report

Posted on by David Choi

Hello,

I created a workflow which should send an email automatically to the owner of the task, when a new task record is created or assigned to the new owner.

The workflow itself is working, but the direct url of the task is somehow wrong.

The 'Record URL(Dynamic)' creates this sort of a link:

crmserver01:80/crmserver01/main.aspx?etc......

But the direct url of our CRM is: crmserver01.domain.com/crmserver01

When I copy the part of the generated URL "main.aspx?etc..." into the working direct url, I will directed to the record of the created task.

Basically this manually adjusted url is working:

crmserver01.domain.com/.../main.aspx

I made a custom url field, which the Record URL(Dynamic) should be generated there and for the email I placed the custom url field.

Any advice how do I fix this? Many thanks!

I have the same question (0)

All responses (15)

Answers (0)

David Choi 20 on at

Like (1)

Report

RE: Record URL(Dynamic) creates wrong url of the task

Thank you, now I got the values of the columns in the database.

I will try to change the url directly from the columns in the SQL database and see if the function "Record URL(Dynamic)" finally generates the correct url in the email.

Was this reply helpful? Yes No
erhan.keskin 2,253 on at

Like (1)

Report

RE: Record URL(Dynamic) creates wrong url of the task

Hi David,

"ColumnName" is the field name, and you will look for the values i mentioned above in it.

Please run this SQL statement to see the values;

SELECT [Id]

,[ColumnName]

,[NVarCharColumn]

FROM [MSCRM_CONFIG].[dbo].[DeploymentProperties]

WHERE ColumnName in (

'ADDeploymentSdkRootDomain'

, 'ADDiscoveryRootDomain'

, 'ADSdkRootDomain'

, 'ADWebApplicationRootDomain' )

Was this reply helpful? Yes No
David Choi 20 on at

Like (0)

Report

RE: Record URL(Dynamic) creates wrong url of the task

Thanks, but for some reasons I can not find the mentioned columns in the SQL database.

Also when I try to run a query to read the value of them, It can't find the columns.

Was this reply helpful? Yes No
erhan.keskin 2,253 on at

Like (0)

Report
RE: Record URL(Dynamic) creates wrong url of the task

Sorry, i just got what you meant. My bad. You can change these settings in the config db.

[MSCRM_CONFIG].[dbo].[DeploymentProperties]

ColumnName values;

ADDeploymentSdkRootDomain

ADDiscoveryRootDomain

ADSdkRootDomain

ADWebApplicationRootDomain

Was this reply helpful? Yes No
David Choi 20 on at

Like (0)

Report

RE: Record URL(Dynamic) creates wrong url of the task

I tried both ways, make a hyperlink from the custom url field and hyperlink directly from Record URL(Dynamic).

The custom field to display the direct URL in the record itself.

Was this reply helpful? Yes No
erhan.keskin 2,253 on at

Like (0)

Report

RE: Record URL(Dynamic) creates wrong url of the task

But you say "I made a custom url field, which the Record URL(Dynamic) should be generated there and for the email I placed the custom url field."

Why wouldn't you insert an Hyperlink as i described above? Populating the link into a field and using the field to generate an hyperlink may cause it?

Was this reply helpful? Yes No
David Choi 20 on at

Like (0)

Report

RE: Record URL(Dynamic) creates wrong url of the task

Yes, this is what I exactly did.

Some how the CRM url is not right. I don't know why.

In the browser while I'm in the crm, it says "crmserver01.domain.com". I can connect to the crm with the same url.

But the crm generates the url "crmserver01:80/...." for the direct record.

Maybe because of wrong configuration of the crm url, I don't know where to check and can't find the setting for it.

Was this reply helpful? Yes No
erhan.keskin 2,253 on at

Like (0)

Report

RE: Record URL(Dynamic) creates wrong url of the task

Thanks David. Not sure if i understand what you are doing there.

Let me tell what i did and saw;

- I added a hyperlink by clicking "Insert Hyperlink" button

- Typed the text in the "Text to display" box

- Provided the URL in the "URL" box by selecting "Record URL(Dynamic)" option on the right pane

- It showed the text like this;

<hyperlink><name>[name i typed]</name><value>{[name i typed]Task-{Record URL(Dynamic)}}</value></hyperlink>

Regards,

Was this reply helpful? Yes No
David Choi 20 on at

Like (0)

Report

RE: Record URL(Dynamic) creates wrong url of the task

Hi Erhan,

it sounds similiar, but I don't think it's the same issue. My code for the hyperlink almost look the same.

I tried both codes:

<hyperlink><name>Please click here</name><value> {Record URL(Task)}</value></hyperlink>

and

<hyperlink><name>{Subject(Task)}</name><value>{Record URL(Dynamic)(Task)}</value></hyperlink>

Both give me the not working url "crmserver01:80/crmserver01/main.aspx...."

It would work when the CRM generates the url "crmserver01.domain.com/crmserver01/main.aspx...", but it doesn't.

Was this reply helpful? Yes No
erhan.keskin 2,253 on at

Like (0)

Report

RE: Record URL(Dynamic) creates wrong url of the task

Is this discussion related to yours?

community.dynamics.com/.../745859

Was this reply helpful? Yes No

Community site session details

Record URL(Dynamic) creates wrong url of the task

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Mansi Soni – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Record URL(Dynamic) creates wrong url of the task

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Mansi Soni – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates