Newbie Questions

Re: Return the first character in a field

Matt Faus — Mon, 04 Jun 2007 07:55:44 GMT

A formula is definitely the way to go here. No need to add extra code when it's unnecessary.

Re: Return the first character in a field

mentalblock — Thu, 31 May 2007 15:39:56 GMT

Thanks for the quick reply.

I didn't end up using your suggestion though, as a co-worker gave me an easier solotion with no coding involved.

I entered the following formula into default value of the text box where I want the result:

concat(textboxone, substring(textboxtwo, 1, 1))

It appears to work like this.

Re: Return the first character in a field

nukkumatti — Thu, 31 May 2007 13:57:36 GMT

Hi,

I would do that in code. See example below:

var contentOfTextBoxOne = XDocument.DOM.selectSingleNode("my:myField/my:textBoxOne").text;

var temp = XDocument.DOM.selectSingleNode("my:myField/my:textBoxTwo").text;

var firstCharacter = temp.substring(0,1);

var concatString = contentOfTextBoxOne + firstCharacter;

Does this help ?

Return the first character in a field

mentalblock — Thu, 31 May 2007 13:31:50 GMT

I am creating a welcome package for new employees in my company. One of my fields needs to be autofilled with the the contents of one text box and the first character of another text box.

I know how to concat. 2 full text boxes together but I need help in returning just the first character of the second text box.

Any suggestions?