Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Multi line string field is possible to store in database table ?

JG16
Tera Contributor

Hi,

I want to store list of values in Database table field like below

XXXXX

XXXXX

XXXXX

XXXXX

------

is the above format is possible to store ? if so what is the data type i should declare in db. Or any other alternative is there ?

Thanks & Regards

JG

 

1 ACCEPTED SOLUTION

deb27
ServiceNow Employee
ServiceNow Employee

You can use field type

Two Line Text Area

Multiple Line Small Text Area

View solution in original post

7 REPLIES 7

Swathi12
Tera Expert

Hi JG,

 

When you are entering the values in the DB add \n for that you have to use <code> tag and it should be enabled in you servicenow instance.

 

Please mark this helpful or correct if it helped you.

 

Regards,

Swathi

JG16
Tera Contributor

Thank you Swathi for your reply. where I have to enable <code> tag please can you eloberate more .

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

create string field with larger length; inform the end users who will be filling the field to give enter after every line

it should happen

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi,

Thanks for your reply. I am working on report so i am reading records from one table to another table, not from UI

 

Thanks

JG