"HTML Script" on custom table

sumeet_n · ‎10-20-2016

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?

Chuck Tomasi · ‎10-21-2016

Apologies. I forgot that I disabled the reference qualifier on the type field to show all fields while doing some development earlier.

NOTE: Do not capture this in an update set! Set your application to Global and update set to Default when doing these next steps!

Right click on the Type field and select Configure Dictionary.
Go to the Reference Specification section and set the "Use Reference Qualifier" field to "Simple"
Save the Record
Now you can select HTML Script (and other types of fields)

View solution in original post

Chuck Tomasi · ‎10-20-2016

When you create the field, can you pick the HTML Field type?

Additionally, you need to click Advanced View to see the Dependent form section and point it to the field that has the table name where your fields reside.

sumeet_n · ‎10-21-2016

Hey Chuck,

The Type "HTML Script" doesn't seem to be available in my developer instance.

Can you help me with this? otherwise i am aware of the dependent field.

Thanks.

Chuck Tomasi · ‎10-21-2016

Apologies. I forgot that I disabled the reference qualifier on the type field to show all fields while doing some development earlier.

NOTE: Do not capture this in an update set! Set your application to Global and update set to Default when doing these next steps!

Right click on the Type field and select Configure Dictionary.
Go to the Reference Specification section and set the "Use Reference Qualifier" field to "Simple"
Save the Record
Now you can select HTML Script (and other types of fields)

ngo · ‎09-09-2018

Hi Chuck,

I know it a quite old post but i wanted to know that after following your steps I was able to create HTML script type field, but the form on which it is created is not responding to any reference fields

I keep on clicking the magnifying glass but the pop-up for reference table is not opening, also I am able to see a lot of error on the console after inspecting

FYI - I am doing this on Jakarta & on Targeted Communication table which is part of a scoped application

Thanks & Regards

Nitish Goel