Issue with .caption.value.#text.value

Avatar

Avatar

edgar65234674

Avatar

edgar65234674

edgar65234674

23-08-2019

Hi all,

I have a Formcalc code to concatenate several fields together at the end of the form but I want to have the field caption text and field caption value in the final text. As example:

concat(TextField1.caption.value.#text.value," ",TextField1)

I hope you can help me!

Thanks...

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

_Bruce_Robertson

MVP

Avatar

_Bruce_Robertson

MVP

_Bruce_Robertson
MVP

28-08-2019

That should work, maybe try

TEXTFIELD1.caption.value.oneOfChild.value

Otherwise, maybe a screenshot of your form structure would help, or even a link to your form

Has the caption any rich text formatting ... bold, italic, colours, etc

Answers (6)

Answers (6)

Avatar

Avatar

radzmar

MVP

Avatar

radzmar

MVP

radzmar
MVP

27-08-2019

What kind of object is HEADER_TXT? When it's a separate text object and not a text field with a caption, the script would be more this:

concat(HEADER_TXT.value.oneOfChild.value, …)

Avatar

Avatar

_Bruce_Robertson

MVP

Avatar

_Bruce_Robertson

MVP

_Bruce_Robertson
MVP

28-08-2019

Good to hear, I think that means you caption had some rich text formatting, not that it was a text field ... just something to be aware of as you could end up with the same problem with your drop down.

Avatar

Avatar

edgar65234674

Avatar

edgar65234674

edgar65234674

28-08-2019

Excellent, the oneOfChild option did work!!!

Avatar

Avatar

edgar65234674

Avatar

edgar65234674

edgar65234674

27-08-2019

Great, HEADER is a text object, this code works!!!!

My only problem at this point is with TextFields, the ".caption.value.#text.value" works perfect with other objects like DropDownLists but for some reason is not working with TextFields captions. Every time I try with TextFields I get an error: "accessor 'TEXTFIELD1.caption.value.#text.value' is unknown"

Any idea?

Avatar

Avatar

edgar65234674

Avatar

edgar65234674

edgar65234674

26-08-2019

Hi,

Is not working for all fields, the concatenate function is only showing the field value but not the captions. My smartform is looking to concatenate several Text Captions, Text Field Captions and Text Field Values into a text that can be copy-paste in another platform.

Here is one example:

//HEADER (just a text box in the form with some captions): Data to concat

//TextField1 (field with a caption and space to capture input): Enter name

//DropDownList1 (list with a caption and options to capture input): Select title

var HEADER_TXT

var TEXTFIELD1_TXT

var DROP1_TXT

concat(HEADER_TXT.caption.value.#text.value,"\u000a",TEXTFIELD1_TXT.caption.value.#text.value," ",TEXTFIELD1,"\u000a",DROP1_TXT.caption.value.#text.value," ",DROPDOWNLIST1)

I was expecting to get as result the text all together:

Data to concat

Enter name: Edgar

Select tile: Mr.

But is only working with the drop downs menus, not with text fields or text boxes.

Thanks for your time!

Avatar

Avatar

radzmar

MVP

Avatar

radzmar

MVP

radzmar
MVP

25-08-2019

The script should work. What problems are you facing with?