Expanding tables with calculating form fields?

[macropod]

Originally Posted by Father

Is there a way to make a text field {FORMTEXT} appear through an IF condition?

No. A macro would be required for that. See: Word 2010 template form field (If checkbox is checked display another field else do not display)

Alternatively, to simulate a combobox, see: https://www.msofficeforums.com/17071-post2.html

Originally Posted by Father

For the calculations, I was originally using bookmarks for the field. With the drop down example the numbers generated from the IF condition don't have a bookmark associated with them. What do you put in place of a bookmark for expressions from those numbers?

When you insert a dropdown formfield into a document, Word gives it a default bookmark name (e.g. Dropdown1). You can see that when you examine the formfield's properties; you can also delete it or change it to something else.

Originally Posted by Father

For FormFields - Table Row Add.doc example - When I run this macro in another document with nested tables I get this error

Microsoft Visual Basic for Applications
"X Cannot access individual rows in this collection because the table has vertically merged cells."

The nested table doesn't have any merged cells so I'm not sure how to fix this.

Your table does have vertically merged cells. See item 8. Furthermore, the macro isn't designed to work with nested tables, so I don't know how you'll get along with that.

PS: It would be preferred for you to attach files here, rather than linking to them on another site. You can do that via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

[Father]

Originally Posted by macropod

When you insert a dropdown formfield into a document, Word gives it a default bookmark name (e.g. Dropdown1). You can see that when you examine the formfield's properties; you can also delete it or change it to something else.

I'm talking about this:
Dept = { FORMDROPDOWN }
{IF{REF Dropdown1 \* MERGEFORMAT}= "HR" "001"}
When the number, in this case 001, is generated by the IF condition, how do you use that number in a calculation/formula? The "001" has no bookmark to use in another formula. What would be the reference?

I tried just using the same formula and adding the calculation into it
{={IF{REF Dropdown1 \* MERGEFORMAT}= "HR" "001"}*(REF UXOQTY1}} but it doesn't work.

In my form I want the N.E.W. (from the selection made in Dropdown UXONomen01) * UXOQTY1 to be calculated and shown in the TOTAL N.E.W.
Since the TOTAL N.E.W. textfield relies on bookmarks to do a calculation (right?), I'm guessing it would have to be done outside of the field's properties.

I'm not sure how else to explain what I'm trying to do here.

Originally Posted by macropod

Your table does have vertically merged cells. See item 8. Furthermore, the macro isn't designed to work with nested tables, so I don't know how you'll get along with that.

Using this I put the sample into a vertically and horizontally merged table an it still works. Not sure what the difference is between what I'm doing with the sample and my working form.

[macropod]

Originally Posted by Father

I'm talking about this:
Dept = { FORMDROPDOWN }
{IF{REF Dropdown1 \* MERGEFORMAT}= "HR" "001"}
When the number, in this case 001, is generated by the IF condition, how do you use that number in a calculation/formula? The "001" has no bookmark to use in another formula. What would be the reference?

The 001 is simply the displayed output. You don't reference that in a calculation; only whatever Dropdown1 returns. You can also lose the ' \* MERGEFORMAT' - it's quite unnecessary. So, if you want to use th, you'd code along the lines of:
{={IF{REF Dropdown1}= "Finance" 2 {IF{REF Dropdown1}= "HR" 1 0}}*5}
where 5 is whatever you want to multiply the selected item's value by. However, that's really no different than:
{IF{REF Dropdown1}= "HR" 5}{IF{REF Dropdown1}= "Finance" 10}
I suggest you take a look at my Microsoft Word Field Maths Tutorial, available at:
http://windowssecrets.com/forums/sho...Maths-Tutorial
and:
http://www.gmayor.com/downloads.htm#Third_party

[Father]

Originally Posted by macropod

I suggest you take a look at my Microsoft Word Field Maths Tutorial, available at:
http://windowssecrets.com/forums/sho...Maths-Tutorial

I'm sure a lot of it is due to the fact that I have no idea what I'm actually doing, but...

When I am in ALT-F9 view and putting in the code/formula it doesn't always "activate". Is there something else I should be doing? When I go back to normal view the formula is sometimes written out as it is rather than being "invisible".

Forgive my terminology... I'm still learning to speak code.

I'm still struggling the get numbers from a dropdown condition to multiply with a FORMTEXT field number. I've tried various ways explained in the tutorial. Again, I'm sure I'm either doing it wrong or assuming one thing works with another when it doesn't.

[Father]

Originally Posted by macropod

The 001 is simply the displayed output. You don't reference that in a calculation;

Is there a way to use the displayed output in a separate calculation? That's what I've been trying to do.

I tried using the table cell address that contains the output, but I'm guessing that's not an option either.