This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I am trying to create an html field in a transaction that has a base url and uses a field value as the suffix. At the same time I need to strip out the white space from that field value prior to adding it to the url. I can do this via a script but am wondering if it is possible to do this as a formula in the field itself.

what exactly is sitting in the field value, single word with space in front?  multiple words? etc

`'baseurl' || replace({fieldid}, ' ', '')` should probably do the trick

Make sure you do not have store value checked in the field definition either

it's actually a tracking number but when it is entered there is a space in between 2 sets of numbers. the tracking url though does  not have the space.

ah - ok. I was doing this as an html but concating the fields would work too.