Unable to create Template Value Type field in Custom table.

may13 — Wed, 05 Mar 2025 11:35:35 GMT

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."

Is anyone know how to resolve this Issue?

Re: Unable to create Template Value Type field in Custom table.

Diogo Ramos — Wed, 05 Mar 2025 18:02:00 GMT

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.

question Unable to create Template Value Type field in Custom table. in Community Central forum

Unable to create Template Value Type field in Custom table.

Re: Unable to create Template Value Type field in Custom table.