Nested Merge Fields

17 messages Options
Embed this post
Permalink
Mark Stevens (Steve) Willis

Nested Merge Fields

Reply Threaded More More options
Print post
Permalink
Is this possible?

If I have a properly-defined merge field A defined within some text in  
a text field B, and then place text field B as a merge field in a  
report, will both merge fields work or will only the outer one work?

If not, is there an easy workaround that will get the same job done?

Thanks!

Steve
--
Mark Stevens (Steve) Willis
stevewillis at mac.com

It is a general popular error to suppose the loudest complainers for  
the public to be the most anxious for its welfare- Edmund Burke

http://homepage.mac.com/stevewillis/
(520) 891-3721 (cell)









--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/


Jonathan Fletcher

Re: Nested Merge Fields

Reply Threaded More More options
Print post
Permalink
Steve,

Can you show us what you mean?

Do you mean this:

<<Text B <<TextA>>>>

I doubt that would work.

What are you trying to accomplish? Perhaps there's an easier way.

j.


On Jul 1, 2009, at 1:06 PM, Mark Stevens (Steve) Willis wrote:

> Is this possible?
>
> If I have a properly-defined merge field A defined within some text  
> in a text field B, and then place text field B as a merge field in a  
> report, will both merge fields work or will only the outer one work?
>
> If not, is there an easy workaround that will get the same job done?
>
> Thanks!
>
> Steve
> --
> Mark Stevens (Steve) Willis
> stevewillis at mac.com
>
> It is a general popular error to suppose the loudest complainers for  
> the public to be the most anxious for its welfare- Edmund Burke
>
> http://homepage.mac.com/stevewillis/
> (520) 891-3721 (cell)
>
>
>
>
>
>
>
>
>
> --
> This list is a free service of LassoSoft: http://www.LassoSoft.com/
> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
> Manage your subscription: http://www.ListSearch.com/FileMaker/
>
>


--
Jonathan Fletcher
FileMaker 9 Certified Developer
FileMaker 10 Certified Developer

Project Foreman
NewMedia Construction Co.
[hidden email]

Instigator
The BB&J Network
The "Go-To Guys" for
FileMaker Development in Louisville
www.thebbandj.net

FileMaker Louisville Blog and Podcast:
www.filemakerlouisville.posterous.com


--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/


bfr00

Re: Nested Merge Fields

Reply Threaded More More options
Print post
Permalink
In reply to this post by Mark Stevens (Steve) Willis
> Is this possible?
>
> If I have a properly-defined merge field A defined within some text in
> a text field B, and then place text field B as a merge field in a
> report, will both merge fields work or will only the outer one work?
>
> If not, is there an easy workaround that will get the same job done?
>
> Thanks!
>
> Steve

Why don't you tell us what happens when you try it?



--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/


Colin MacGregor

Re: Nested Merge Fields

Reply Threaded More More options
Print post
Permalink
In reply to this post by Mark Stevens (Steve) Willis
That sounds like a job for a calculation field, rather than a text  
merge.

Kind regards,

Colin

+++

Colin MacGregor

Resolute Systems (UK) Limited
9 Marlow Road
High Wycombe
Bucks
HP11 1TA
UK

www.resolutesystems.co.uk

tel:    01494 520088
cell:    07974 152733
Skype: resysuk

registered in England and Wales
company registration number 3826934
VAT registration number 776 3622 04

FileMaker Business Alliance member
FileMaker TechNet member




On 1 Jul 2009, at 18:06, Mark Stevens (Steve) Willis wrote:

> Is this possible?
>
> If I have a properly-defined merge field A defined within some text  
> in a text field B, and then place text field B as a merge field in a  
> report, will both merge fields work or will only the outer one work?
>
> If not, is there an easy workaround that will get the same job done?
>
> Thanks!
>
> Steve
> --
> Mark Stevens (Steve) Willis
> stevewillis at mac.com
>
> It is a general popular error to suppose the loudest complainers for  
> the public to be the most anxious for its welfare- Edmund Burke
>
> http://homepage.mac.com/stevewillis/
> (520) 891-3721 (cell)
>
>
>
>
>
>
>
>
>
> --
> This list is a free service of LassoSoft: http://www.LassoSoft.com/
> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
> Manage your subscription: http://www.ListSearch.com/FileMaker/
>
>


--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/


Mark Stevens (Steve) Willis

Re: Nested Merge Fields

Reply Threaded More More options
Print post
Permalink
In reply to this post by Jonathan Fletcher
I tried it and it didn't work.

Here's what I want to do:

I have 4 types of campuses and each type can receive multiple letters,  
each letter having verbiage unique to that campus type. I know I could  
do this with a calc fields, but I cannot for the following reasons:

1. There are WAY too many letters, so I would end up with a gazillion  
calc fields.
2. Hard-coding the verbiage into calc fields precludes the school  
administration from editing them as needed in the future.

So I created a table called LetterContents that has a record structure  
as follows:

ID = unique ID#, serial
Letter Title
Page 1 - Text Block 1
Page 1 - Text Block 2
Page 1 - Text Block 3
Page 2 - Text Block 1
Page 2 - Text Block 2
Page 2 - Text Block 3

Each text block field has 4 repetitions, 1 corresponding to each  
campus type. When the letter is printed, the campus type automatically  
selects the correct version.

Not every letter uses all 3 text blocks, some require only 1, some 2  
because there's a small list portal between the 2 blocks, etc.  
Occasionally, there is a second page, hence the blocks available for  
that.

Each letter has merge fields for the Letter Title and for each block  
necessary for that letter.

Sometimes the text in a block needs to have one or more merge fields  
within it to insert, say, the campus director's name, address, city,  
state, and zip, all of which come from another table.

I know I can add more Text Block fields in the LetterContents table  
record and string together a series of merge fields to insert the data  
from other tables. I was just hoping to find something more elegant.

And I still have a second issue of formatting individual words and  
phrases into boldface, italics, and underline within the text block  
when it is inserted via a merge field.

Any thoughts on either?

Thanks!

Steve

On Jul 1, 2009, at 10:24 AM, Jonathan Fletcher wrote:

> Steve,
>
> Can you show us what you mean?
>
> Do you mean this:
>
> <<Text B <<TextA>>>>
>
> I doubt that would work.
>
> What are you trying to accomplish? Perhaps there's an easier way.
>
> j.
>
>
> On Jul 1, 2009, at 1:06 PM, Mark Stevens (Steve) Willis wrote:
>
>> Is this possible?
>>
>> If I have a properly-defined merge field A defined within some text  
>> in a text field B, and then place text field B as a merge field in  
>> a report, will both merge fields work or will only the outer one  
>> work?
>>
>> If not, is there an easy workaround that will get the same job done?
>>
>> Thanks!
>>
>> Steve
>> --
>> Mark Stevens (Steve) Willis
>> stevewillis at mac.com
>>
>> It is a general popular error to suppose the loudest complainers  
>> for the public to be the most anxious for its welfare- Edmund Burke
>>
>> http://homepage.mac.com/stevewillis/
>> (520) 891-3721 (cell)
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> --
>> This list is a free service of LassoSoft: http://www.LassoSoft.com/
>> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
>> Manage your subscription: http://www.ListSearch.com/FileMaker/
>>
>>
>
>
> --
> Jonathan Fletcher
> FileMaker 9 Certified Developer
> FileMaker 10 Certified Developer
>
> Project Foreman
> NewMedia Construction Co.
> [hidden email]
>
> Instigator
> The BB&J Network
> The "Go-To Guys" for
> FileMaker Development in Louisville
> www.thebbandj.net
>
> FileMaker Louisville Blog and Podcast:
> www.filemakerlouisville.posterous.com
>
>
> --
> This list is a free service of LassoSoft: http://www.LassoSoft.com/
> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
> Manage your subscription: http://www.ListSearch.com/FileMaker/
>
>

--
Mark Stevens (Steve) Willis
stevewillis at mac.com

There is nothing in the world that someone cannot make a little worse  
and sell a little cheaper, and he who considers price only is that  
person's lawful prey.- John Ruskin

http://homepage.mac.com/stevewillis/
(520) 891-3721 (cell)









--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/


Jonathan Fletcher

Re: Nested Merge Fields

Reply Threaded More More options
Print post
Permalink
Steve,

Try this:

Assemble your paragraphs into a variable, then run a substitute on the  
data in the variable, replacing faux merge field with the correct  
data. Then set your page contents to the modified variable and print.

This should enable your two-level merging.

j.

On Jul 1, 2009, at 3:26 PM, Mark Stevens (Steve) Willis wrote:

> I tried it and it didn't work.
>
> Here's what I want to do:
>
> I have 4 types of campuses and each type can receive multiple  
> letters, each letter having verbiage unique to that campus type. I  
> know I could do this with a calc fields, but I cannot for the  
> following reasons:
>
> 1. There are WAY too many letters, so I would end up with a  
> gazillion calc fields.
> 2. Hard-coding the verbiage into calc fields precludes the school  
> administration from editing them as needed in the future.
>
> So I created a table called LetterContents that has a record  
> structure as follows:
>
> ID = unique ID#, serial
> Letter Title
> Page 1 - Text Block 1
> Page 1 - Text Block 2
> Page 1 - Text Block 3
> Page 2 - Text Block 1
> Page 2 - Text Block 2
> Page 2 - Text Block 3
>
> Each text block field has 4 repetitions, 1 corresponding to each  
> campus type. When the letter is printed, the campus type  
> automatically selects the correct version.
>
> Not every letter uses all 3 text blocks, some require only 1, some 2  
> because there's a small list portal between the 2 blocks, etc.  
> Occasionally, there is a second page, hence the blocks available for  
> that.
>
> Each letter has merge fields for the Letter Title and for each block  
> necessary for that letter.
>
> Sometimes the text in a block needs to have one or more merge fields  
> within it to insert, say, the campus director's name, address, city,  
> state, and zip, all of which come from another table.
>
> I know I can add more Text Block fields in the LetterContents table  
> record and string together a series of merge fields to insert the  
> data from other tables. I was just hoping to find something more  
> elegant.
>
> And I still have a second issue of formatting individual words and  
> phrases into boldface, italics, and underline within the text block  
> when it is inserted via a merge field.
>
> Any thoughts on either?
>
> Thanks!
>
> Steve
>
> On Jul 1, 2009, at 10:24 AM, Jonathan Fletcher wrote:
>
>> Steve,
>>
>> Can you show us what you mean?
>>
>> Do you mean this:
>>
>> <<Text B <<TextA>>>>
>>
>> I doubt that would work.
>>
>> What are you trying to accomplish? Perhaps there's an easier way.
>>
>> j.
>>
>>
>> On Jul 1, 2009, at 1:06 PM, Mark Stevens (Steve) Willis wrote:
>>
>>> Is this possible?
>>>
>>> If I have a properly-defined merge field A defined within some  
>>> text in a text field B, and then place text field B as a merge  
>>> field in a report, will both merge fields work or will only the  
>>> outer one work?
>>>
>>> If not, is there an easy workaround that will get the same job done?
>>>
>>> Thanks!
>>>
>>> Steve
>>> --
>>> Mark Stevens (Steve) Willis
>>> stevewillis at mac.com
>>>
>>> It is a general popular error to suppose the loudest complainers  
>>> for the public to be the most anxious for its welfare- Edmund Burke
>>>
>>> http://homepage.mac.com/stevewillis/
>>> (520) 891-3721 (cell)
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>> This list is a free service of LassoSoft: http://www.LassoSoft.com/
>>> Search the list archives: http://www.ListSearch.com/FileMaker/ 
>>> Browse/
>>> Manage your subscription: http://www.ListSearch.com/FileMaker/
>>>
>>>
>>
>>
>> --
>> Jonathan Fletcher
>> FileMaker 9 Certified Developer
>> FileMaker 10 Certified Developer
>>
>> Project Foreman
>> NewMedia Construction Co.
>> [hidden email]
>>
>> Instigator
>> The BB&J Network
>> The "Go-To Guys" for
>> FileMaker Development in Louisville
>> www.thebbandj.net
>>
>> FileMaker Louisville Blog and Podcast:
>> www.filemakerlouisville.posterous.com
>>
>>
>> --
>> This list is a free service of LassoSoft: http://www.LassoSoft.com/
>> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
>> Manage your subscription: http://www.ListSearch.com/FileMaker/
>>
>>
>
> --
> Mark Stevens (Steve) Willis
> stevewillis at mac.com
>
> There is nothing in the world that someone cannot make a little  
> worse and sell a little cheaper, and he who considers price only is  
> that person's lawful prey.- John Ruskin
>
> http://homepage.mac.com/stevewillis/
> (520) 891-3721 (cell)
>
>
>
>
>
>
>
>
>
> --
> This list is a free service of LassoSoft: http://www.LassoSoft.com/
> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
> Manage your subscription: http://www.ListSearch.com/FileMaker/
>
>


--
Jonathan Fletcher
FileMaker 9 Certified Developer
FileMaker 10 Certified Developer

Project Foreman
NewMedia Construction Co.
[hidden email]

Instigator
The BB&J Network
The "Go-To Guys" for
FileMaker Development in Louisville
www.thebbandj.net

FileMaker Louisville Blog and Podcast:
www.filemakerlouisville.posterous.com


--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/


Corn Walker

Re: Nested Merge Fields

Reply Threaded More More options
Print post
Permalink
In reply to this post by Mark Stevens (Steve) Willis
On Jul 1, 2009, at 3:26 PM, Mark Stevens (Steve) Willis wrote:

> Sometimes the text in a block needs to have one or more merge fields  
> within it to insert, say, the campus director's name, address, city,  
> state, and zip, all of which come from another table.
>
> I know I can add more Text Block fields in the LetterContents table  
> record and string together a series of merge fields to insert the  
> data from other tables. I was just hoping to find something more  
> elegant.
>
> And I still have a second issue of formatting individual words and  
> phrases into boldface, italics, and underline within the text block  
> when it is inserted via a merge field.
>
> Any thoughts on either?


<Shameless Plug>

Perhaps something like fmSpark <http://www.seedcode.com/fmSpark> might  
do the trick? I think most people buy it for the email functionality,  
but it does letters and labels too.

</Shameless Plug>

Cheers,
-corn


Corn Walker
The Proof Group
http://proofgroup.com/


--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/


Mark Stevens (Steve) Willis

Re: Nested Merge Fields

Reply Threaded More More options
Print post
Permalink
In reply to this post by Jonathan Fletcher
On Jul 1, 2009, at 12:44 PM, Jonathan Fletcher wrote:

> Assemble your paragraphs into a variable, then run a substitute on  
> the data in the variable, replacing faux merge field with the  
> correct data. Then set your page contents to the modified variable  
> and print.


So I put the paragraphs into a script variable, do my merge  
manipulation on the variable, and then get it into the document how?

This may be venturing into an area of FMP10 I'm not familiar with.

Thanks for responding!

Steve
--
Mark Stevens (Steve) Willis
stevewillis at mac.com

If you do the same thing you've always done, you'll be the same person  
you've always been.-  If you do the same thing you've always done,  
you'll be the same person you've always been.

http://homepage.mac.com/stevewillis/
(520) 891-3721 (cell)









--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/


Mark Stevens (Steve) Willis

Re: Nested Merge Fields

Reply Threaded More More options
Print post
Permalink
In reply to this post by Corn Walker
On Jul 1, 2009, at 12:49 PM, Corn Walker wrote:

> <Shameless Plug>
>
> Perhaps something like fmSpark <http://www.seedcode.com/fmSpark>  
> might do the trick? I think most people buy it for the email  
> functionality, but it does letters and labels too.
>
> </Shameless Plug>



Close but no cigar!


--
Mark Stevens (Steve) Willis
stevewillis at mac.com

For over a thousand years, the Roman conquerers returning from the  
wars enjoyed the honor of the triumph, a tumultuous parade. In the  
procession came trumpeters and musicians and strange animals from the  
conquered territories, together with carts laden with treasure and  
captured armaments. The conquerer rode in the triumphal chariot, the  
dazed prisoners walking in chains before him. Sometimes, his children,  
robed in white, stood with him in the chariot or rode the trace  
horses. A slave stood behind the conquerer holding a golden crown and  
whispering in his ear a warning: that all glory is fleeting. - George  
S. Patton

http://homepage.mac.com/stevewillis/
(520) 891-3721 (cell)









--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/


bfr00

Re: Nested Merge Fields

Reply Threaded More More options
Print post
Permalink
In reply to this post by Mark Stevens (Steve) Willis
> I tried it and it didn't work.

You tried WHAT?
You're not giving us much to go on.

> Close but no cigar!

Do you honestly expect anybody to do anything for you with a response like
that?

What do you want to do?

What EXACTLY did you try?

What EXACTLY is close but not close enough?

Are you getting a commission on wasted time?



--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/


Mark Stevens (Steve) Willis

Re: Nested Merge Fields

Reply Threaded More More options
Print post
Permalink

On Jul 1, 2009, at 1:07 PM, Bruce Robertson wrote:

>> I tried it and it didn't work.
>
> You tried WHAT?
> You're not giving us much to go on.

I tried what you suggested in your earlier email. I inserted a merge  
field within one of my text block fields, put the text block field  
into my letter as a merge field and put it into Preview mode. No joy.

>> Close but no cigar!

His product won't work for me. It may have appeared to on the surface,  
but upon examination, it won't.

> Do you honestly expect anybody to do anything for you with a  
> response like that?
>
> What do you want to do?
>
> What EXACTLY did you try?
>
> What EXACTLY is close but not close enough?

Corn Walker's product

> Are you getting a commission on wasted time?

I have explained myself as thoroughly as I can. If that is  
insufficient data for you, you, of course, don't have to help.

Considering that you helped me tremendously with my missing items list  
problem in the past, I would value your help, though not at the price  
of being yelled at.

Obviously, you are having a bad day. Please don't share it.

Steve Willis
--
Mark Stevens (Steve) Willis
stevewillis at mac.com

Pay no attention to that man behind the curtain! The Great Oz has  
spoken!- The Great Oz The Wizard of Oz

http://homepage.mac.com/stevewillis/
(520) 891-3721 (cell)









--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/


Mark Stevens (Steve) Willis

Re: Nested Merge Fields

Reply Threaded More More options
Print post
Permalink
I've also determined that boldface, italicized, and underlined text in  
the data entry field will retain its formatting when that field is  
used as a merge field.

So that problem is solved, thanks!

Steve
--
Mark Stevens (Steve) Willis
stevewillis at mac.com

The only normal people are the ones you don't know very well.- Joe Ancis

http://homepage.mac.com/stevewillis/
(520) 891-3721 (cell)









--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/


Corn Walker

Re: Nested Merge Fields

Reply Threaded More More options
Print post
Permalink
In reply to this post by Mark Stevens (Steve) Willis
On Jul 1, 2009, at 4:22 PM, Mark Stevens (Steve) Willis wrote:

> His product won't work for me. It may have appeared to on the  
> surface, but upon examination, it won't.

I didn't realize you already own the product, otherwise I wouldn't  
have suggested it. I must be misunderstanding your problem though  
because I can get fmSpark to do what I think you're describing.

Cheers,
-corn


Corn Walker
The Proof Group
http://proofgroup.com/


--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/


Jonathan Fletcher

Re: Nested Merge Fields

Reply Threaded More More options
Print post
Permalink
In reply to this post by Mark Stevens (Steve) Willis
PSEUDOCODE (four script steps):

Set Variable [
    $letter ;
    selectedParagraph1 &
       selectedParagraph2 &
       selectedParagraph3 &
       selectedParagraph4 &
       etc.
]

Set Variable [
    $letter ;
    Substitute (
       $letter ;
       [ "<name>" ; TextStyle ( company::name ; bold ) ] ;
       [ "<address>" ; TextStyle ( company::address ; italic ) ] ;
       [ "<city>" ; company::city ] ;
       [ "<other>" ; company::other ]
    )
]

Set Field [ letter::body ; $letter ]

Print

END PSEUDOCODE



Does that make it clearer, Steve?

j.



On Jul 1, 2009, at 3:57 PM, Mark Stevens (Steve) Willis wrote:

> On Jul 1, 2009, at 12:44 PM, Jonathan Fletcher wrote:
>
>> Assemble your paragraphs into a variable, then run a substitute on  
>> the data in the variable, replacing faux merge field with the  
>> correct data. Then set your page contents to the modified variable  
>> and print.
>
>
> So I put the paragraphs into a script variable, do my merge  
> manipulation on the variable, and then get it into the document how?
>
> This may be venturing into an area of FMP10 I'm not familiar with.
>
> Thanks for responding!
>
> Steve
> --
> Mark Stevens (Steve) Willis
> stevewillis at mac.com
>
> If you do the same thing you've always done, you'll be the same  
> person you've always been.-  If you do the same thing you've always  
> done, you'll be the same person you've always been.
>
> http://homepage.mac.com/stevewillis/
> (520) 891-3721 (cell)
>
>
>
>
>
>
>
>
>
> --
> This list is a free service of LassoSoft: http://www.LassoSoft.com/
> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
> Manage your subscription: http://www.ListSearch.com/FileMaker/
>
>


--
Jonathan Fletcher
FileMaker 9 Certified Developer
FileMaker 10 Certified Developer

Project Foreman
NewMedia Construction Co.
[hidden email]

Instigator
The BB&J Network
The "Go-To Guys" for
FileMaker Development in Louisville
www.thebbandj.net

FileMaker Louisville Blog and Podcast:
www.filemakerlouisville.posterous.com


--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/


bfr00

Re: Nested Merge Fields

Reply Threaded More More options
Print post
Permalink
In reply to this post by Mark Stevens (Steve) Willis
>
> On Jul 1, 2009, at 1:07 PM, Bruce Robertson wrote:
>
>>> I tried it and it didn't work.
>>
>> You tried WHAT?
>> You're not giving us much to go on.
>
> I tried what you suggested in your earlier email. I inserted a merge
> field within one of my text block fields, put the text block field
> into my letter as a merge field and put it into Preview mode. No joy.

I made no such suggestion.

>>> Close but no cigar!
>
> His product won't work for me. It may have appeared to on the surface,
> but upon examination, it won't.
>
>> Do you honestly expect anybody to do anything for you with a
>> response like that?
>>
>> What do you want to do?
>>
>> What EXACTLY did you try?
>>
>> What EXACTLY is close but not close enough?
>
> Corn Walker's product

That is a useless answer.
 

>> Are you getting a commission on wasted time?
>
> I have explained myself as thoroughly as I can. If that is
> insufficient data for you, you, of course, don't have to help.
>
> Considering that you helped me tremendously with my missing items list
> problem in the past, I would value your help, though not at the price
> of being yelled at.
>
> Obviously, you are having a bad day. Please don't share it.
>
> Steve Willis

I'm asking you not to waste other people's time.

The way to do this is to provide meaningful descriptions and examples.

We're talking FileMaker; a product that can do almost anything.

What do you want to do? Nobody knows.



--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/


Mark Stevens (Steve) Willis

Re: Nested Merge Fields

Reply Threaded More More options
Print post
Permalink
In reply to this post by Jonathan Fletcher
Yes, it does. Thank you! That explains it very nicely.

I appreciate your assistance.

Thanks again!

Steve

On Jul 1, 2009, at 1:41 PM, Jonathan Fletcher wrote:

> PSEUDOCODE (four script steps):
>
> Set Variable [
>   $letter ;
>   selectedParagraph1 &
>      selectedParagraph2 &
>      selectedParagraph3 &
>      selectedParagraph4 &
>      etc.
> ]
>
> Set Variable [
>   $letter ;
>   Substitute (
>      $letter ;
>      [ "<name>" ; TextStyle ( company::name ; bold ) ] ;
>      [ "<address>" ; TextStyle ( company::address ; italic ) ] ;
>      [ "<city>" ; company::city ] ;
>      [ "<other>" ; company::other ]
>   )
> ]
>
> Set Field [ letter::body ; $letter ]
>
> Print
>
> END PSEUDOCODE
>
>
>
> Does that make it clearer, Steve?
>
> j.
>
>
>
> On Jul 1, 2009, at 3:57 PM, Mark Stevens (Steve) Willis wrote:
>
>> On Jul 1, 2009, at 12:44 PM, Jonathan Fletcher wrote:
>>
>>> Assemble your paragraphs into a variable, then run a substitute on  
>>> the data in the variable, replacing faux merge field with the  
>>> correct data. Then set your page contents to the modified variable  
>>> and print.
>>
>>
>> So I put the paragraphs into a script variable, do my merge  
>> manipulation on the variable, and then get it into the document how?
>>
>> This may be venturing into an area of FMP10 I'm not familiar with.
>>
>> Thanks for responding!
>>
>> Steve
>> --
>> Mark Stevens (Steve) Willis
>> stevewillis at mac.com
>>
>> If you do the same thing you've always done, you'll be the same  
>> person you've always been.-  If you do the same thing you've always  
>> done, you'll be the same person you've always been.
>>
>> http://homepage.mac.com/stevewillis/
>> (520) 891-3721 (cell)
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> --
>> This list is a free service of LassoSoft: http://www.LassoSoft.com/
>> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
>> Manage your subscription: http://www.ListSearch.com/FileMaker/
>>
>>
>
>
> --
> Jonathan Fletcher
> FileMaker 9 Certified Developer
> FileMaker 10 Certified Developer
>
> Project Foreman
> NewMedia Construction Co.
> [hidden email]
>
> Instigator
> The BB&J Network
> The "Go-To Guys" for
> FileMaker Development in Louisville
> www.thebbandj.net
>
> FileMaker Louisville Blog and Podcast:
> www.filemakerlouisville.posterous.com
>
>
> --
> This list is a free service of LassoSoft: http://www.LassoSoft.com/
> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
> Manage your subscription: http://www.ListSearch.com/FileMaker/
>
>

--
Mark Stevens (Steve) Willis
stevewillis at mac.com

I would rather live my life as if there is a God and die to find out  
there isn't, than live my life as if there isn't and die to find out  
there is.- Albert Camus

http://homepage.mac.com/stevewillis/
(520) 891-3721 (cell)









--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/


Mark Stevens (Steve) Willis

Re: Nested Merge Fields

Reply Threaded More More options
Print post
Permalink
In reply to this post by bfr00
This is precisely what you told me to do and what I did.

On Jul 1, 2009, at 10:26 AM, Bruce Robertson wrote:

>> Is this possible?
>>
>> If I have a properly-defined merge field A defined within some text  
>> in
>> a text field B, and then place text field B as a merge field in a
>> report, will both merge fields work or will only the outer one work?
>>
>> If not, is there an easy workaround that will get the same job done?
>>
>> Thanks!
>>
>> Steve
>
> Why don't you tell us what happens when you try it?
>
>
>
> --
> This list is a free service of LassoSoft: http://www.LassoSoft.com/
> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
> Manage your subscription: http://www.ListSearch.com/FileMaker/
>
>

--
Mark Stevens (Steve) Willis
stevewillis at mac.com

There is no substitute for victory!- General of the Army Douglas  
MacArthur

http://homepage.mac.com/stevewillis/
(520) 891-3721 (cell)









--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/