Database join element Desc field -adding multiple entries

[jhweb]

Hi there,

Just a quick question regarding: Database Join Element > Advanced > Description field :

How can I add multiple field names here. I add in firstname which works great, however as soon as I add another one like lastname it doesn't work.

It's obviously the space in between them. Even using a new line doesn't work.
Would need syntax for adding multiple fields? or syntax for the spacing in between?

Can't find any more info in wiki other than what's in the tooltip in fabrik so any help would be appreciated.
Thanks.

Regards,
Ettienne

 

[davez]

I found a trick: I have two fields in the joined table: description, date_time. If I enter: "concat(description, date_time)" into the Advanced > Description field it works.

 

[NickC4555]

In the Or Concat label property enter {thistable}.first_value, " ", {thistable}.second_value