I have an infopath form on my sharepoint server that will be used as an order form. Keep in mind it is a 2007 template.
I have a list of products in a table with text fields where customers can enter in the quantity. I currently have the prices stored in an Excel sheet. I was wondering if there is any way to have infopath pull these prices from excel and do calculations to find the grand total of all quantities of products.
The only way I can see to do it right now is to make a hidden text field which calculates the subtotal, and then the grand total adds these up. However I have hundreds of products and this is very time consuming.