InfoPath Dev

Hi Hilary,  Thanks for your response. The fiscal year I'm dealing with is different than the calendar year. It begins on 10/1 and ends on 9/30. So the formula would have to know that.Right now the fiscal year is 2013 so  up until 10/1 of this year the Current Fiscal Year field wouldd show 2013. Then on 10/1 it would need to show ...

Okay - so, the short answer is "yes" - you can submit data from an InfoPath form to one or more SharePoint Lists. It is not a built in feature, however, and it will require code or qRules. We use qRules because it is easier than writing custom code for every form & cheaper to maintain. If you are committed to separate lists, you ...

So - is your fiscal year the same as the actual year? I know some companies - their FY may start the beginning of June or some such. I'd use default values for this - they'll update when ever the form is opened - but if the formula is right, they won't change until the year changes - for example, substring(today(), 1, 4) would always ...

Thank you Hilary, you are awesome. That worked perfectly.

Thanks - that made it easier for me - just needed a second condition: my:field1 = ../../preceding-sibling::my:Delivery/my:Plans/my:Plan/my:field1

I have a 2007 IP form where I show two fields. One is labeled This Fiscal Year and the other is labeleld Next Fiscal Year. I want these fields to show the current and next fiscal years and calculate them as well when the fiscal year hits. So the field label This FY will always show the current FY, in this case 2013. Then when th FY changes it ...

Here ya go! Thank you!

 Very nice and concise. I find a lot of scripts around that do this, but none that take into account a list of holidays. Any ideas on mods for this script that would allow a list of dates for holidays?  

I hope I explain this properly and thouroughly enough that someone can assist or tell me that it can't be done.  I have created an IP 2010 Filler form.  The main view is a checklist.  Subsequent views are reports reflecting the deficiencies generated from the data from the checklist. The deficiencies are ...

I have a bunch of data in my Sharepoint List (combination of let's say 10 different fields).  I put two dropdowns on my form, and want to load only the rows that the user selects into a repeating table.  So for example, customers.  The user selects State and City, I want the repeating table to populate information ONLY for ...