"HTML Script" on custom table

sumeet_n
Kilo Guru

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?

1 ACCEPTED SOLUTION

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!


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


find_real_file.png


View solution in original post

20 REPLIES 20

Hi Chuck,

 

 

Is this still working in Orlando? It seems that the HTML script type can't be selected after following the steps. Upon checking it is visible false by default and cant set it to true.

find_real_file.png

Did you change the reference qualifier to Simple? That basically turns off the filter.

Hey Chuck, I have tried your solution and it doesn't work. I am still unable to add the HTML Script Field anywhere even after setting the reference qualifier on 'type' to Simple. I have tried a few other things as well which you can find here: https://community.servicenow.com/community?id=community_question&sys_id=bece70cedb4574506064eeb5ca96...

I'm desperate to find a working solution for this as this is such a powerful and flexible tool in building out custom, flexible solutions. 

I'm thinking the issue is that the field, by default, is set to 'Visible' False and you can't change this.

Hello @Chuck Tomasi ,

 

I have same requirement of creating new field, field type should be "HTML Script". I have seen your reply for enabling "HTML Script" type of field on a custom table, I have replicated same steps but I couldn't achieve what I required. Can you please elaborate.

Thank you in advance.

Hi Chuck,

 

I am trying to do the same as you described but I am stucking with the reference Dependent field.

 

I added the HTML Script Field into my form, I created a Table Field and added per Default the table of the form.

then I have Setup the dependent field on the HTML Field to this table.

 

All good so far. my HTML Field is showing next right to it the referenced fields form that table that I have selected, 

 

I have added then on my html Field some Variables as we do in the notification.

and grab this field from a real notification and put it as the body. but the variables are not getting any values,

 

what I am doing wrong?

 

thanks

Elias