Anyone know how to return more than 1000 character...
# generalt
Tom Galvin
10/30/2019, 8:03 PMAnyone know how to return more than 1000 characters in the result of a saved search using a text formula? Or maybe to break it up into separate formulas returning the first 1000 then the next 1000 etc;?
g
Gregory Jones
10/30/2019, 8:07 PMare you having a specific field get truncated when it's in your results?
Gregory Jones
10/30/2019, 8:07 PMI think just putting that field ID in a formula text field as the formula works.
s
scottvonduhn
10/30/2019, 8:10 PMaccording to SA id 62885 there is an Enhancement to show more than 1000 characters for a long text or rich text field. It implies that using a formula is a workaround for this, so it sounds like a formula should not be truncating after 1000 characters. But NetSuite may have changed something.
k
KevinJ of Kansas
10/30/2019, 8:16 PMI think the formula to work around is to split it up into multiple columns.
KevinJ of Kansas
10/30/2019, 8:16 PMi.e. substring
t
Tom Galvin
10/30/2019, 8:30 PMThanks all. @KevinJ of Kansas I tried doing this but it is returning nothing! 1)This particular value is 3824 characters. 2) Here are the formulas I am attempting to return. 3) The second formula is blank. 4) I try to get the character count of the field. 5) It says it is only 1000. I am not sure where I am going wrong. It is a rich text field if that helps.
3 Views