Concatenate field
11 April, 2010
How do we add the field name to the URL string for our calculated field?
I found the option to create a calculated field, but it wouldn't let me concatenate text and a field.
I found the concatenate function, but it only lets me concatenate two fields, not text.
How do I concatenate the text "http://www.example.com/view.html?caseref=" to the field [CASE_REFERENCE].
I found the option to create a calculated field, but it wouldn't let me concatenate text and a field.
I found the concatenate function, but it only lets me concatenate two fields, not text.
How do I concatenate the text "http://www.example.com/view.html?caseref=" to the field [CASE_REFERENCE].
You can do by creating a calculated field that just returns the "base URL":
Then use the "Concatenate Columns" advanced function to append the field:
The result will show the concatenation of the base URL and the field data:
Thanks,
Steve
Then use the "Concatenate Columns" advanced function to append the field:
The result will show the concatenation of the base URL and the field data:
Thanks,
Steve