Make the concat(,) function work with literal strings.
As it stands the concat(,) function only works to concatenate the content of fields e.g. concat(#{textfield1},#{textfield2}) works, but it would greatly extend the usefulness of this function if it could also do concat(#{textfield1},"literal text").
This would be particularly useful to use with
concat(numToStr(#{numericfield1}),#{textfield2})
so that we can display a number followed by a string, such as "20ml".
see comment
-
Joe commented
@Ben Zwart
Make sure to change "Real result" to "String result". -
Ben Zwart commented
concat('#{amount}','%')
Error: Invalid Double.
"14,0"I tried all possible combinations, but it doesn't work like you suggested.
Regards,
ing.B.W.Zwart -
You can do it: concat('#{textfield1}','literal text').
for string you must use single quotation mark.