Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Trying to place some text into from a table into a text object. I need all text (from 2 fields) from the table in the text object.
Something like
= field1 & ' ' & field2
But I need all text not just based on a selection. So something like:
= {1} field1 & ' ' & {1} field2
But I am getting errors.
Any ideas?
Regards
Revlin
You'll need an aggregation function here, like concat:
=concat( {1} field1 & ' ' & field2, ', ')
Yes that works. Thank you.