50 fields into 1

[Laurence]

Hi, how can I have 1 calculation field which automatically enters all of the data from other fields (50) (within the same record). The main field will result in a very long sentence. Also, is it possible to use the 'if' function within the same calculation. I've been away from FM for over a year - & forgotten everything!

[Ocean West]

List ( fieldA ; fieldB ; FieldC ) will give you a return separated list

if you want to have them space separated you can do

Substitute ( List ( fieldA ; fieldB ; FieldC ) ; "¶" ; " " )

[Laurence]

Many thanks, its amazing what you forget!!!

[Laurence]

hi, i'm not sure if anyone will pick up this feed as its been a while, anyhow: regarding this original question:

i need to put a combination of fields and "exact text" into one calculation field, the result will be a long sentence with mixed field contents and fixed text.

How to add a fixed line of text into the calculation field (which sometimes contains inverted comma's) amongst the fields.

Laurence