Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / September 2006

Tip: Looking for answers? Try searching our database.

Designing new form from existing sample

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
decoderman - 08 Sep 2006 04:52 GMT
Hi,

I am very new to infopath. I am trying to design a form from an existing
sample; the Invoice (Single Tax Rate) sample to be exact.

The sample form comes pre-set with a repeating table. That repeating table
has such items as quantity, unit price and discount rate, which are
calculated and displayed in a Pre-tax Total Price field once the values are
input into the required fields that generate it. I am trying to add another
field to this repeating table, called 'Flat Discount Rate'. This field is an
alternative to a % discount in the situation that a whole dollar amount needs
to be discounted from the calculated Pre-tax Total Price.

I am able to add the field to the form layout and tie the field to a
datasource I create "flatDiscRate". I also am able to modify the layout to
place the field where I want it to be.

My problem comes in when I want to tie this new value into the calculation
of the Pre-tax Total Price field. I have looked everywhere, but I am unable
to find the underlying function script doing the calculations for the
existing items. Logically, I would think the script would be inside of the
field tied to the Pre-tax Total Price, but it is not, as far as I can see.
Are the function scripts that exist in the default fields of the existing
sample form hidden somehow? I just need to tie my new field into the existing
calculation, but I cannot find the existing calculations.

Any help would be greatly appreciated!!!

Signature

best regards,

Stephen

S.Y.M. Wong-A-Ton - 08 Sep 2006 10:39 GMT
Go to Tools > Programming > Microsoft Script Editor. Once in the editor, look
for a function called "calcTotals". This performs the calculations.
---
S.Y.M. Wong-A-Ton

> Hi,
>
[quoted text clipped - 23 lines]
>
> Any help would be greatly appreciated!!!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.