Combine Fields

[wildbill]

Hi All,

I am new to filemaker and Scripting. Could someone possibly tell me the script i need to combine the text from three separate text fields and insert it into a fourth text field with each result on a new line.

Many Thanks

Giles

[efen]

Set variable [$one;firstfield]

Set variable [$two;secondfield]

Set variable [$three;thirdfield]

Set field [fourthfield; $one & ¶ & $two & ¶ & $three]

[Raybaudi]

Are yoy sure that you need a script ?

Because you could obtain the same result with a calculation field ( or an auto-enter calculation on a normal text field ) using simple the List ( ) function, something like:

List ( Field1 ; Field2 ; Field3 )

[bruceR]

I prefer the list function:

Set variable [$one;firstfield]

Set variable [$two;secondfield]

Set variable [$three;thirdfield]

Set field [fourthfield; List( $one ; $two ; $three) ]

[efen]

Why?

[Raybaudi]

Try your script with an empty field2

[comment]

Why not simply:

Set field [ Field4 ; List ( Field1 ; Field2 ; Field3 ) ]

That's assuming a script is required at all.

[wildbill]

Hey Danielle,

You were right I wanted a calculation not a script.

Thanks very much for your help

Giles

[wildbill]

Hi all,

Thanks for your help.

One other query I had would be:

Say I have a 5 fields I want a seperate field to tell me how many of the 5 have been filled in with text, is there a calculation i could do for that??

Thanks Again

Giles

[comment]

Try =

Count ( Field1 ; Field2 ; Field3 ; Field4 ; Field5 )

[wildbill]

You've all been a great help, I'm all sorted.

Thanks very much for your time

Giles

Edited June 13, 2010 by Guest

[bruceR]

Why not simply:

Set field [ Field4 ; List ( Field1 ; Field2 ; Field3 ) ]

That's assuming a script is required at all.

I was just going along with the original format; and sometimes using variables in a script allows for easier debugging. But of course your suggestion works fine and I agree completely that it's a valid and simpler solution.