Change between singular and plural

[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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[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]

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[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?