S
Shemp
OK, I have a lot of questions about InfoPath (which I just love BTW),
and I will post them here one at a time so I can track them separately.
The overall setup for each of these questions involves a form I've made
to enter sales orders. It's really fast to fill out and gives us much
greater accuracy in writing up orders. There's a section that has a
Repeating Table to enter products and quantity, which also brings up
the unit price and calculates the extended price. Neat stuff. Then
there are Optional Sections for Discount and Sales Tax, but those don't
apply for most customers.
I have a Repeating Table into which you enter Quantity, pick
Description from a dropdown, and it fills in the Unit Price and
Extended Price. There's also an Optional Section, basically the same
thing except that it lets you enter stuff from outside our standard
product line, like custom projects with special pricing etc. Further
down the form, there's a Subtotal which adds up the Repeating Section
and Optional Section sums, then a Optional Section for Discount and
Sales Tax if applicable, then a Grand Total field.
If you show this Optional Section, then decide you don't want to use
it, when you hide it the Subtotal and Grand Total are NaN. If you show
the Optional Section, even if the value is 0 the totals work but not
when the OS has been shown and then hidden.
I have the values for the fields formatted to Decimal(double) as
Currency, and under Tools/Form Options I've selected "Treat blank
values as zero," so I'm stumped.
One thing I want to be able to do but can't figure out is how to create
a normal If...Then statement, like "If this Optional Section is hidden
return zero, else return what's in the rightmost field." No can do.
How bout you?
If you would like to see a copy of this file, email me at:
J E F F (A T) 5 T R E A |V| B 0 X (d 0 t) C 0 |V|
and I will post them here one at a time so I can track them separately.
The overall setup for each of these questions involves a form I've made
to enter sales orders. It's really fast to fill out and gives us much
greater accuracy in writing up orders. There's a section that has a
Repeating Table to enter products and quantity, which also brings up
the unit price and calculates the extended price. Neat stuff. Then
there are Optional Sections for Discount and Sales Tax, but those don't
apply for most customers.
I have a Repeating Table into which you enter Quantity, pick
Description from a dropdown, and it fills in the Unit Price and
Extended Price. There's also an Optional Section, basically the same
thing except that it lets you enter stuff from outside our standard
product line, like custom projects with special pricing etc. Further
down the form, there's a Subtotal which adds up the Repeating Section
and Optional Section sums, then a Optional Section for Discount and
Sales Tax if applicable, then a Grand Total field.
If you show this Optional Section, then decide you don't want to use
it, when you hide it the Subtotal and Grand Total are NaN. If you show
the Optional Section, even if the value is 0 the totals work but not
when the OS has been shown and then hidden.
I have the values for the fields formatted to Decimal(double) as
Currency, and under Tools/Form Options I've selected "Treat blank
values as zero," so I'm stumped.
One thing I want to be able to do but can't figure out is how to create
a normal If...Then statement, like "If this Optional Section is hidden
return zero, else return what's in the rightmost field." No can do.
How bout you?
If you would like to see a copy of this file, email me at:
J E F F (A T) 5 T R E A |V| B 0 X (d 0 t) C 0 |V|