formulas, fields & linking

[Tuomo Aho]

Hi!

I have a few short questions that I have a hard time
finding answers to. Any help would be greatly appreciated!

I am trying to make a semi-automatic word template.

My first question:
For the life of me I cant make formulas to work. I have
assigned cells in a table bookmarks (the content of the
cell) But the cell where I want the results to show just
doesnt do anything. My formula looks like this
{=Qty1*unipri1} with both of the variables indicating the
bookmark. Im beginning to wonder if there is a setting in
Word97 that needs to be enable so that formulas calculate
results?
Second question:
The table contains cells that I wish the user to fill,
each fillable cell has a text similar to "fill this". If
the user does not fill them, I would like them to appear
blank when printing. What I tried doing is using the
{MACROBUTTON NOMACRO [fill this]} as the original
templates do but that shows the guide text if not edited
when printing. Any suggestions?
Third and Final question:
If once cell has text that the user has entered, how can I
have another cell to lookup that cells text and copy it to
it? My intention is that the user wouldnt have to type the
same thing twice.

Thank you for any and all help even if its only for one
question!!

br,

Tuomo

 

[macropod]

hi Tuomo Aho,

Q1: Check out the 'tutorial' document at:
http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=365442
(url all one line)
Your formula looks OK, but are you using Ctrl-F9 to create the field braces?
You can't just type them. Also, since your formula appear to be using
numeric values rather than text, you can use simple cell references (eg
=A1*B2) instead of bookmark references.

Q2: You might try using a compound field like:
{QUOTE{ASK BkMrk "Question"}{IF{BkMrk}= "" "Press F9 Here" {BkMrk}}}
prefixed with an empty bookmark named 'BkMrk' at the start of the field to
suppress the 'Error! Bookmark not defined.' message and force the 'Press F9
Here' prompt to display. If your users press F9, then select OK without
entering anything, you'll get a blank output.

Q3: To repeat the contents of a bookmarked value/string in more than one
place in a document, use a REF field. In the above example 'BkMrk' is a
bookmarked value/string and the REF field can be coded as {REF BkMrk} or,
more simply, {BkMrk}.

Cheers

Hi!

I have a few short questions that I have a hard time
finding answers to. Any help would be greatly appreciated!

I am trying to make a semi-automatic word template.

My first question:
For the life of me I cant make formulas to work. I have
assigned cells in a table bookmarks (the content of the
cell) But the cell where I want the results to show just
doesnt do anything. My formula looks like this
{=Qty1*unipri1} with both of the variables indicating the
bookmark. Im beginning to wonder if there is a setting in
Word97 that needs to be enable so that formulas calculate
results?
Second question:
The table contains cells that I wish the user to fill,
each fillable cell has a text similar to "fill this". If
the user does not fill them, I would like them to appear
blank when printing. What I tried doing is using the
{MACROBUTTON NOMACRO [fill this]} as the original
templates do but that shows the guide text if not edited
when printing. Any suggestions?
Third and Final question:
If once cell has text that the user has entered, how can I
have another cell to lookup that cells text and copy it to
it? My intention is that the user wouldnt have to type the
same thing twice.

Thank you for any and all help even if its only for one
question!!

br,

Tuomo