InfoPath Dev

Also when I use the xml approach with the 2 files I get blank so must be doing something wrong? Here is your Data source entry /Statuses/Status[. = xdXDocument:get-DOM()/my:myFields/my:field1 or . = xdXDocument:GetDOM("StagePaths")/StagePaths/StagePath/Path[../Stage = xdXDocument:get-DOM()/my:myFields/my:field1]] and here is ...

Hi Hilary I never used the xml resource files before but might have to go that way as I can't get the one SharePoint list with two columns Stage and Path to work?! The field is just blank, I assume I don't need the expressions and just need your 4th filter condition => field1 is equal to Path[Stage = field1] I assume it's ...

There isn't a way to override this behavior, that I know of. I suppose you could provide a button in the form that sets the date picker to today for last year or something....

Hi Hilary, Thanks for that. I am now cleared with your point which you conveyed for my first question. For Second question, what i asked is how will the user be able to see previous years by navigation of data time control. Red color highlighted area -> i used to click the button navigate back and front to select previous and upcoming ...

That's why you're the best Hilary ;-) Worked perfectly. Thanks very much for your help. Always seems obvious in hindsight!

Oh, got it. So you should probably just add the status field to the repeating table itself. Default to New, use that in your formatting rule. Then, on submit, if you set the repeating field to submitted, all instances will get set. Does that work for you?

Thanks for the quick response Hilary! You know what, I have done it like this many times before. It did just escape me this time for some reason... I do also need to check though that any additional items added to the table have not been taken by another Employee when the form is being edited. So along with checking the FormStatus + ...

SharePoint is storing dates as DateTimes. It displays them formatted based on the user's regional settings. We can't override the way they are displayed - so if you have specific display needs, you'll need to use a calculated column. I don't understand your other question - that is just how date pickers work? You can always type in ...

Why not add a "status" field to your form? It doesn't have to show on the form, just be in the main data source. It can default to New. Then, the first time a user submits a form, in the submit rules, set it to Submitted (or whatever, just change it). Then your validation rules can be exactly what they are with the addition of ...

Yeah, and it could probably be done with a single list - the stage dropdown would need to only show unique items - I just added a second XML because it was faster for me than re-doing the initial work :)