Merge Script

[chadski021]

is there a Script for merge field for example if i click this button it merge the field information

[Manjit Behera]

Yes, we can merge data of multiple field into a single field in Filemaker through Set field step. If you want to show the data of a field in merge field just set the modified data to a normal text field and set a merge data from multiple fields into that  field by using "Set Field" script step.

 

Example-

suppose you are using field-1 ) as the merge field to show data in layout. And you are having 2 other fields whose data to be set into the first field for display on layout.

 

Set Field[Field1] = "Here is the Merge data:  " & Field2 & " " & Field2.

 

Then use the first field in layout to show merge data.

<<Table::Field1>>

 

Thanks,

[chadski021]

can you give me an example how this work. i need two tables for this lets say Table1::Email  and Table2::Merge Codes  i want to merge the email to merge codes  

[Lee Smith]

To concatenate two fields (have more than one Text Field display as the result), your calculation  would look like Table1::Email  & Table2::Merge Codes

 Note that the and needs to be & also, if you want the separated with a space or comma, etc. You need to add Table1::Email  & " " & Table2::Merge Codes

[chadski021]

thanks it works