Unable to create Template Value Type field in Custom table.

may13
Tera Contributor

‎03-05-2025 03:35 AM

There is one requirement: we need to create a custom table called 'Approval.' In that table, we need to create a field named 'Template,' and the type of this field should be 'Template Value.' However, when I try to create this field, I am unable to see this field type. But, in the 'sys_glide_object' table, I can see the 'Template Value' field type."

 

t1.png

 

 

 

t2.png

 

Is anyone know how to resolve this Issue?

 

 

0 Helpfuls
  • 314 Views
1 REPLY 1

Diogo Ramos
Giga Sage

‎03-05-2025 10:01 AM - edited ‎03-05-2025 10:02 AM

Hello Mayur

There are at least 2 ways to go around it. 
1 - You can edit the qualifier of the TYPE field to allow showing invisible field classes, create your record, and then revert the qualifier back to oob. (You would not need to do this when applying the update set, you just need it for the manual creation in dev).
2 - You can go to the sys_dictionary table, find an existing type = template value, open that record.
Modify the end table (I used SN utils extension by double clicking on the field name) to replace the value as it was read only on the client side, I modified both the table and the field name, and I do an insert and stay. After this is done, make sure there is nothing else copied from the original dictionary entry that you don't want like default values and so on, you can see the xml of the record to see which fields are populated. 

There is probably more options, but this is what I used in the past.

Hope it helps.

 

0 Helpfuls