Filling in Forms & Changing Text in Protected Document

[Expando1]

Is there a way to allow two types of different protections in a
template--"Filling in Forms" & "Comments"?

My template has areas with fill in fields to be populated by client
information & on database info. I then have to alter the accompanying
boilerplate text based on that data acquired--meaning some phrases/sentences
needs to be modified or deleted and additional text inserted for
clarification.

 

[Expando1]

Is there a way to allow two types of different protections in a
template--"Filling in Forms" & "Comments"?

My template has areas with fill in fields to be populated by client
information & on database info. I then have to alter the accompanying
boilerplate text based on that data acquired--meaning some phrases/sentences
needs to be modified or deleted and additional text inserted for
clarification.

Oh, simple section breaks won't suffice as the fillable fields and the
related text are not separated from each other discretely. That is, a
paragraph will have both fillable fields and the related text which will be
modified conditional on the information those fields contain.

 

[macropod]

Hi Expando1,

If there are clear rules as to what text is required when, then a formula field that references the relevant formfield (whose
properties you'd set to 'calculate on exit') can be made to automatically vary the text. For example, say you have a dropdown
formfield named 'Dropdown1', with options, 1 & 2. For such a scenario you could code your formula field(s) as:
{IF{Dropdown1}= 1 "Text when dropdown = 1"}
{IF{Dropdown1}= 1 "Text when dropdown = 2"}
or
{IF{Dropdown1}= 1 "Text when dropdown = 1" "Text when dropdown = 2"}

You can use as many of these as you need, each one having different text output if you like.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

 

[Expando1]

Thanks macropod. I've writen the formula based on the dropdown field but it
doesn't auto-update the dependent text even though i have 'calculate on exit'
checked for the dropdown field. Instead I have to manually click at the
appropriate place in the document where the text should be and click F9 to
have the text inserted. Shouldn't it auto-update to the appropriate text
without me clicking F9? { IF { Dropdown37} = describes "The patient
ruminates and worries when attempting to sleep and is fearful about being
unable to sleep." }

Also, do you know of a way to prevent a page from a document from printing
in the final report. Basically we have one page that's a check box form and
based on which check boxes are selected it determines the appropriate text to
be inserted into the final report. But that check box form doesn't need to
be included in the final hardcopy printout of the document. I guess I can
simply discard that page when it does go to printer, but i'm just wondering
if there's a better approach.

Hi Expando1,

If there are clear rules as to what text is required when, then a formula field that references the relevant formfield (whose
properties you'd set to 'calculate on exit') can be made to automatically vary the text. For example, say you have a dropdown
formfield named 'Dropdown1', with options, 1 & 2. For such a scenario you could code your formula field(s) as:
{IF{Dropdown1}= 1 "Text when dropdown = 1"}
{IF{Dropdown1}= 1 "Text when dropdown = 2"}
or
{IF{Dropdown1}= 1 "Text when dropdown = 1" "Text when dropdown = 2"}

You can use as many of these as you need, each one having different text output if you like.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[MVP - Microsoft Word]

Oh, simple section breaks won't suffice as the fillable fields and the
related text are not separated from each other discretely. That is, a
paragraph will have both fillable fields and the related text which will be
modified conditional on the information those fields contain.

 

[Suzanne S. Barnhill]

Have you protected the document for forms? Also, note that "exit" requires
that you tab out of the form field; just clicking somewhere else with the
mouse won't do it.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Thanks macropod. I've writen the formula based on the dropdown field but
it
doesn't auto-update the dependent text even though i have 'calculate on
exit'
checked for the dropdown field. Instead I have to manually click at the
appropriate place in the document where the text should be and click F9 to
have the text inserted. Shouldn't it auto-update to the appropriate text
without me clicking F9? { IF { Dropdown37} = describes "The patient
ruminates and worries when attempting to sleep and is fearful about being
unable to sleep." }

Also, do you know of a way to prevent a page from a document from printing
in the final report. Basically we have one page that's a check box form
and
based on which check boxes are selected it determines the appropriate text
to
be inserted into the final report. But that check box form doesn't need
to
be included in the final hardcopy printout of the document. I guess I can
simply discard that page when it does go to printer, but i'm just
wondering
if there's a better approach.

Hi Expando1,

If there are clear rules as to what text is required when, then a formula
field that references the relevant formfield (whose
properties you'd set to 'calculate on exit') can be made to automatically
vary the text. For example, say you have a dropdown
formfield named 'Dropdown1', with options, 1 & 2. For such a scenario you
could code your formula field(s) as:
{IF{Dropdown1}= 1 "Text when dropdown = 1"}
{IF{Dropdown1}= 1 "Text when dropdown = 2"}
or
{IF{Dropdown1}= 1 "Text when dropdown = 1" "Text when dropdown = 2"}

You can use as many of these as you need, each one having different text
output if you like.

Note: The field brace pairs (ie '{ }') for the above example are created
via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[MVP - Microsoft Word]

:

Is there a way to allow two types of different protections in a
template--"Filling in Forms" & "Comments"?

My template has areas with fill in fields to be populated by client
information & on database info. I then have to alter the accompanying
boilerplate text based on that data acquired--meaning some
phrases/sentences
needs to be modified or deleted and additional text inserted for
clarification.

Oh, simple section breaks won't suffice as the fillable fields and the
related text are not separated from each other discretely. That is, a
paragraph will have both fillable fields and the related text which
will be
modified conditional on the information those fields contain.

 

[Expando1]

Thanks Suzanne! I was using the mouse to click elsewhere.

Here's another bit I've been struggling with:
I have two text fields that will contain numbers, eg., Text11 & Text12. I
want to show the difference between those numbers in another field, Text13.
I've tried writing { Text13=SUM(Text11-Text12)\#0 } , but I get "Error in
Syntax!" Any ideas what I'm doing wrong and how to write this formula
properly?

Have you protected the document for forms? Also, note that "exit" requires
that you tab out of the form field; just clicking somewhere else with the
mouse won't do it.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Thanks macropod. I've writen the formula based on the dropdown field but
it
doesn't auto-update the dependent text even though i have 'calculate on
exit'
checked for the dropdown field. Instead I have to manually click at the
appropriate place in the document where the text should be and click F9 to
have the text inserted. Shouldn't it auto-update to the appropriate text
without me clicking F9? { IF { Dropdown37} = describes "The patient
ruminates and worries when attempting to sleep and is fearful about being
unable to sleep." }

Also, do you know of a way to prevent a page from a document from printing
in the final report. Basically we have one page that's a check box form
and
based on which check boxes are selected it determines the appropriate text
to
be inserted into the final report. But that check box form doesn't need
to
be included in the final hardcopy printout of the document. I guess I can
simply discard that page when it does go to printer, but i'm just
wondering
if there's a better approach.

Hi Expando1,

If there are clear rules as to what text is required when, then a formula
field that references the relevant formfield (whose
properties you'd set to 'calculate on exit') can be made to automatically
vary the text. For example, say you have a dropdown
formfield named 'Dropdown1', with options, 1 & 2. For such a scenario you
could code your formula field(s) as:
{IF{Dropdown1}= 1 "Text when dropdown = 1"}
{IF{Dropdown1}= 1 "Text when dropdown = 2"}
or
{IF{Dropdown1}= 1 "Text when dropdown = 1" "Text when dropdown = 2"}

You can use as many of these as you need, each one having different text
output if you like.

Note: The field brace pairs (ie '{ }') for the above example are created
via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[MVP - Microsoft Word]


:

Is there a way to allow two types of different protections in a
template--"Filling in Forms" & "Comments"?

My template has areas with fill in fields to be populated by client
information & on database info. I then have to alter the accompanying
boilerplate text based on that data acquired--meaning some
phrases/sentences
needs to be modified or deleted and additional text inserted for
clarification.

Oh, simple section breaks won't suffice as the fillable fields and the
related text are not separated from each other discretely. That is, a
paragraph will have both fillable fields and the related text which
will be
modified conditional on the information those fields contain.

 

[Suzanne S. Barnhill]

Because your calculated form field IS Text 13, you don't need to reference
it. The formula should be { = Text 11-Text 12 \#0 }

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Thanks Suzanne! I was using the mouse to click elsewhere.

Here's another bit I've been struggling with:
I have two text fields that will contain numbers, eg., Text11 & Text12. I
want to show the difference between those numbers in another field,
Text13.
I've tried writing { Text13=SUM(Text11-Text12)\#0 } , but I get "Error in
Syntax!" Any ideas what I'm doing wrong and how to write this formula
properly?

Have you protected the document for forms? Also, note that "exit"
requires
that you tab out of the form field; just clicking somewhere else with the
mouse won't do it.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Thanks macropod. I've writen the formula based on the dropdown field
but
it
doesn't auto-update the dependent text even though i have 'calculate on
exit'
checked for the dropdown field. Instead I have to manually click at
the
appropriate place in the document where the text should be and click F9
to
have the text inserted. Shouldn't it auto-update to the appropriate
text
without me clicking F9? { IF { Dropdown37} = describes "The patient
ruminates and worries when attempting to sleep and is fearful about
being
unable to sleep." }

Also, do you know of a way to prevent a page from a document from
printing
in the final report. Basically we have one page that's a check box
form
and
based on which check boxes are selected it determines the appropriate
text
to
be inserted into the final report. But that check box form doesn't
need
to
be included in the final hardcopy printout of the document. I guess I
can
simply discard that page when it does go to printer, but i'm just
wondering
if there's a better approach.

:

Hi Expando1,

If there are clear rules as to what text is required when, then a
formula
field that references the relevant formfield (whose
properties you'd set to 'calculate on exit') can be made to
automatically
vary the text. For example, say you have a dropdown
formfield named 'Dropdown1', with options, 1 & 2. For such a scenario
you
could code your formula field(s) as:
{IF{Dropdown1}= 1 "Text when dropdown = 1"}
{IF{Dropdown1}= 1 "Text when dropdown = 2"}
or
{IF{Dropdown1}= 1 "Text when dropdown = 1" "Text when dropdown = 2"}

You can use as many of these as you need, each one having different
text
output if you like.

Note: The field brace pairs (ie '{ }') for the above example are
created
via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[MVP - Microsoft Word]


:

Is there a way to allow two types of different protections in a
template--"Filling in Forms" & "Comments"?

My template has areas with fill in fields to be populated by client
information & on database info. I then have to alter the
accompanying
boilerplate text based on that data acquired--meaning some
phrases/sentences
needs to be modified or deleted and additional text inserted for
clarification.

Oh, simple section breaks won't suffice as the fillable fields and
the
related text are not separated from each other discretely. That is,
a
paragraph will have both fillable fields and the related text which
will be
modified conditional on the information those fields contain.