InfoPath Dev

 Hi Hillary, Thank you.  I adjusted the formula like your example, to update the path but the sum is 0 even when multiple rows appear.  Formula doesn't error any more.   Any idea?  number(concat(substring(../d:Date_x0020_Ordered, 1, 4), substring(../d:Date_x0020_Ordered, 6, 2), substring(../d:Date_x0020_Ordered, 9, ...

I've now included my sample form as I realize my entire approach may be flawed.  I am including the entire secondary datasource as a repeating table, and using conditional formatting to only show the rows that meet the date criteria set at the top. Problem is I also can't SUM the totals because I can't filter to only sum the ...

Hello,  I am building a "summary of expenses" form that will allow the user to select "Office", and a range of dates to display a repeating table with purchase information from Sharepoint library.  That all works fine, except now I want to allow the user to "filter" by listbox, the status of each order ...

 No luck on samples or examples....gosh I'm really having trouble understanding how to "manage" the workflow in the form. I create the "3 state workflow" in my document library, and have a choice field called "OrderStatus".  Now how to change this field from the form? 1. The original submitter will ...

 Hello, Actually I have read those articles, and they are helpful.  What I can't find is a good example or tutorial of how to integrate Infopath forms with the workflow.  Like how to trigger the workflow state, etc in a form.  That's what I'm trying to understand.  Until I can "SEE" it, I have a hard ...

Hello, I have never worked with workflows, particularly with Infopath.  I am designing a Purchasing form that will utilize the Three-State Workflow included in WSS 3.0. Pending Approval Approved Complete Can anyone suggest any good reading or examples that will help walk me through this?  I thought at first it looked straight ...

 Hello, and thank you for your assistance.  I guess I'm not 100% sure where the Translate function needs to go.   This was what i had tried translate(WorkZip[Company = Title], "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ") This is a rule to set a fields value (VendorPostalCode) when the ...

Hello, I am aware of how to use the translate function to convert a field to uppercase, but I'm not sure logistically how to do this for a value retrieved from a sharepoint list. In my case I have a Postal Code value retreived from a SP list, into the main data source in  a field "VendorPostalCode".  The value in the SP ...

Hello, I have a form where I there is a calculated field which I want to have available as a column in WSS 3.0.  The field is set as a Decimal type, and formatted for 2 decimal places (it's a currency 29.99).  The problem is when the value appears in the Sharepoint column it appears with 3 decimal places.  So instead of the ...

Hello, I have the following fields: Unit Price, Provincial Tax, Federal Tax, Pre-Tax Price, Total with Tax All in a repeating table.  The tax rate changes between area so the user enters the value as a decimal (7.00).  I already calculate the Pre-tax price easily, but now need to calculate a "Total with Tax" .  That ...