Field Type: Two Line Text Area - How do I create?

sdtimb
Giga Expert

I'm working on a new table I just created. I need to add a field for a venue street address. On the Locations table [cmn_location] there is a field with a type of "Two Line Text Area." However, when I attempt to create this same field on my new table, I don't see the field Type. Any ideas how to create this field type on a different table?

 

Street.jpg

 

StreetDict.jpg

1 ACCEPTED SOLUTION

solutioningnow
Giga Guru

Hi Tim,



You can enable "Two Line Text Area" type by following below steps:



1) Go to table "sys_glide_object"


2) Search name as "multi_two_lines"


3) set Visible to True



Just FYI, In OOB write Access for this table is restricted to "maint". To update the record, you first need to update write ACL.



Please mark answer as correct/helpful, if it was helpful



Regards,


Solutioner


Logo.png


Enhance Knowledge NOW@ www.solutioningnow.com


http://www.solutioningnow.com/


View solution in original post

7 REPLIES 7

solutioningnow
Giga Guru

Hi Tim,



You can enable "Two Line Text Area" type by following below steps:



1) Go to table "sys_glide_object"


2) Search name as "multi_two_lines"


3) set Visible to True



Just FYI, In OOB write Access for this table is restricted to "maint". To update the record, you first need to update write ACL.



Please mark answer as correct/helpful, if it was helpful



Regards,


Solutioner


Logo.png


Enhance Knowledge NOW@ www.solutioningnow.com


http://www.solutioningnow.com/


I have full admin access and HI Security admin access and still can not see or edit the table to show the muilti_two_lines.   I see in ServiceNow it says that role "maint" is reserved for ServiceNow use.  


Hi Julia,



You need to modify the write ACL for the sys_glide_object table.



1. Elevate elevated privileges


elevatedPerm.jpg


2. Navigate to System Security --> Access Control (ACL)


3. Search for "Name *sys_glide_object" --> Select the ACL with the "write" Operation


ACL1.jpg


4. Add "Admin" to the Requires role section


ACL2.jpg



5. In the Type filter text enter (without pressing the enter key!): sys_glide_object.list


6. Search the list for Name *two


7. You can now check the "Visible" checkbox


acl3.jpg


When I get to the sys_glide_object write ACL, I do not have the option to add a role. The 'insert a row' is not there. I am a system admin, have the security role and elevated permissions. I am on a Helsinki developer instance. Any idea why I am not able to add the role?