"HTML Script" on custom table

[sumeet_n]

Hello All,

I would like to have a field of type "HTML Script" - similar to what we have on Email templates table on a custom table. This will be dependent on another custom table so that I can use ${field_name} notation to substitute the values dynamically while sending emails. Emails? - I am using Notification activity in workflow on this table to send the content of this HTML field.

Currently I am using "HTML" type field which works fine without dynamic substitution.

These developments are in a scoped application.

Any other way to do this?

[gauravbhandari]

Hi Elias,

I know i am late but i found the solution to your problem.

What i understood from your issue that you are able to make field on your custom table like notification but now you need to trigger notification which takes contents from the custom table field. if my understanding is correct so solution is pretty straight.

Solution: You need to create a email script and call the email script in notification, below is example:

email script:Your_email_script_name

var xyz = current.'your_custom_field';
template.print(xyz);

In Notification:

In Message HTML: ${mail_script:Your_email_script_name}

I hope this will help, we tried and it worked perfectly for our case.

Regards

Gaurav

[gauravbhandari]

Hi Elias,

I know i am late but i found the solution to your problem.

 What i understood from your issue that you are able to make field on your custom table like notification but now you need to trigger notification which takes contents from the custom table field. if my understanding is correct so solution is pretty straight.

Solution: You need to create a email script and call the email script in notification, below is example:

email script:Your_email_script_name

var xyz = current.'your_custom_field';
template.print(xyz);

In Notification:

In Message HTML: ${mail_script:Your_email_script_name}

I hope this will help, we tried and it worked perfectly for our case.

Regards

Gaurav

[aptk]

Hello Chuck,

Could you please tell me what is the difference between "HTML" and "HTML Script" type?

Thanks,

AP

[Chuck Tomasi]

HTML script gives you a list of fields on the right, like a notification. When you click a field it uses the ${fieldname} notation to represent the value of that.

[aptk]

Hello Chuck,

I need to make video enable on knowledge article. it was not happening earlier when type was "HTML" for field "text" on knowledge article form. But once i changed type from "HTML" to "HTML Script", i was able to save video on knowledge article.

So my question is why requirement was not getting fulfill by using type as "HTML"?   What is the difference between "HTML" and "HTML Script" type?

Regards,

AP