[BrittaniMV]

I have a letter with fillable fields I have been trying to perfect. This
letter has several drop downs listing items enclosed with the letter. If
multiple selections are made, I would like the letter "s" added to different
words making the letter read like there are multiple itmes included. Does
anyone have any suggestions on how this could be done?

I considered a user prompt asking if there were multiple enclosures but
couldn't make this work correctly. I also thought about an IF field referring
to a dropdown that was in white font so it couldn't be seen when printed. I
didn;t have success with this either.

Any ideas??? Thanks so much.

[Graham Mayor]

A variation on the following should work. This checks each of three dropdown
fields named Dropdown1-3 for a result "A". Each of the results is then added
to the previous. If the total amounts to more than 1 the calculated field
types "s", otherwise nothing

{ IF{ =({ IF{ Dropdown1 } = "A" 1 0 } + { IF{ Dropdown2 } = "A" 1 0 } + {
IF{ Dropdown3 } = "A" 1 0 })} 1 "s" "" }

See also http://www.gmayor.com/formatting_word_fields.htm


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



BrittaniMV wrote:
I have a letter with fillable fields I have been trying to perfect.
This letter has several drop downs listing items enclosed with the
letter. If multiple selections are made, I would like the letter "s"
added to different words making the letter read like there are
multiple itmes included. Does anyone have any suggestions on how this
could be done?

I considered a user prompt asking if there were multiple enclosures
but couldn't make this work correctly. I also thought about an IF
field referring to a dropdown that was in white font so it couldn't
be seen when printed. I didn;t have success with this either.

Any ideas??? Thanks so much.

[BrittaniMV]

Am I required to do a Mail Merge to get this to work correctly? I am not
intending to do a Maile Merge so I need a solution that will function on a
stand alone basis.

"Graham Mayor" wrote:

A variation on the following should work. This checks each of three dropdown
fields named Dropdown1-3 for a result "A". Each of the results is then added
to the previous. If the total amounts to more than 1 the calculated field
types "s", otherwise nothing

{ IF{ =({ IF{ Dropdown1 } = "A" 1 0 } + { IF{ Dropdown2 } = "A" 1 0 } + {
IF{ Dropdown3 } = "A" 1 0 })} 1 "s" "" }

See also http://www.gmayor.com/formatting_word_fields.htm


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



BrittaniMV wrote:
I have a letter with fillable fields I have been trying to perfect.
This letter has several drop downs listing items enclosed with the
letter. If multiple selections are made, I would like the letter "s"
added to different words making the letter read like there are
multiple itmes included. Does anyone have any suggestions on how this
could be done?

I considered a user prompt asking if there were multiple enclosures
but couldn't make this work correctly. I also thought about an IF
field referring to a dropdown that was in white font so it couldn't
be seen when printed. I didn;t have success with this either.

Any ideas??? Thanks so much.

[Graham Mayor]

This has nothing to do with mail merge! It is a conditional field
construction. If you set the property of the last dropdown field (here
Dropdown3) to calculate on exit the calculation will run. What the
calculation does as shown is check each of three dropdown fields and when
the content is equal to A it adds 1 to the calculation (otherwise it adds
0). If the count adds to more than 1 (ie more than one field meets the
criteria) it iserts 's'.

The brackets {} are inserted with CTRL+F9 and you must change the dropdown
field names and results to match what you have and what you wish to achieve.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



BrittaniMV wrote:
Am I required to do a Mail Merge to get this to work correctly? I am
not intending to do a Maile Merge so I need a solution that will
function on a stand alone basis.

"Graham Mayor" wrote:

A variation on the following should work. This checks each of three
dropdown fields named Dropdown1-3 for a result "A". Each of the
results is then added to the previous. If the total amounts to more
than 1 the calculated field types "s", otherwise nothing

{ IF{ =({ IF{ Dropdown1 } = "A" 1 0 } + { IF{ Dropdown2 } = "A" 1 0
} + { IF{ Dropdown3 } = "A" 1 0 })} 1 "s" "" }

See also http://www.gmayor.com/formatting_word_fields.htm


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



BrittaniMV wrote:
I have a letter with fillable fields I have been trying to perfect.
This letter has several drop downs listing items enclosed with the
letter. If multiple selections are made, I would like the letter "s"
added to different words making the letter read like there are
multiple itmes included. Does anyone have any suggestions on how
this could be done?

I considered a user prompt asking if there were multiple enclosures
but couldn't make this work correctly. I also thought about an IF
field referring to a dropdown that was in white font so it couldn't
be seen when printed. I didn;t have success with this either.

Any ideas??? Thanks so much.

[BrittaniMV]

Each of the three dropdowns has 8 different items in the dropdown list. Does
the letter A in the field you suggested refer to any entry or does it need to
be replace with each of the 8 options?

"Graham Mayor" wrote:

This has nothing to do with mail merge! It is a conditional field
construction. If you set the property of the last dropdown field (here
Dropdown3) to calculate on exit the calculation will run. What the
calculation does as shown is check each of three dropdown fields and when
the content is equal to A it adds 1 to the calculation (otherwise it adds
0). If the count adds to more than 1 (ie more than one field meets the
criteria) it iserts 's'.

The brackets {} are inserted with CTRL+F9 and you must change the dropdown
field names and results to match what you have and what you wish to achieve.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



BrittaniMV wrote:
Am I required to do a Mail Merge to get this to work correctly? I am
not intending to do a Maile Merge so I need a solution that will
function on a stand alone basis.

"Graham Mayor" wrote:

A variation on the following should work. This checks each of three
dropdown fields named Dropdown1-3 for a result "A". Each of the
results is then added to the previous. If the total amounts to more
than 1 the calculated field types "s", otherwise nothing

{ IF{ =({ IF{ Dropdown1 } = "A" 1 0 } + { IF{ Dropdown2 } = "A" 1 0
} + { IF{ Dropdown3 } = "A" 1 0 })} 1 "s" "" }

See also http://www.gmayor.com/formatting_word_fields.htm


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



BrittaniMV wrote:
I have a letter with fillable fields I have been trying to perfect.
This letter has several drop downs listing items enclosed with the
letter. If multiple selections are made, I would like the letter "s"
added to different words making the letter read like there are
multiple itmes included. Does anyone have any suggestions on how
this could be done?

I considered a user prompt asking if there were multiple enclosures
but couldn't make this work correctly. I also thought about an IF
field referring to a dropdown that was in white font so it couldn't
be seen when printed. I didn;t have success with this either.

Any ideas??? Thanks so much.