InfoPath Dev

Good morning Hilary. I am having a similar issue and found this old thread. I have a start date and end date in SharePoint. Although they are set to Date only, it appears the dates come in with the time portion also. What I am trying to do is take a date picker date (default to today()), and compare to see if the InfoPath date is between ...

Yes, they can all be in form load. Just be careful if you have any form load rules that may change that field's value - you'd want your rules to switch the view to run before it could be changed.

An they can all be in the form load correct?

They each have to be their own rule. So you would need individual rules.

I have 5 views and based on the Request type I want it to load the appropriate view. I know I can use rules to do this, however my question is can I put all of the variables in the Form Load in a single rule or do I break them out into individual rules. Example: If Request Type = AOP Evaluation switch view to AOPEval If Request Type = ...

Disregard it appears it is working now...Thank you again!!

Of course you are brilliant again, now i just need to figure out how to get the Request Type in the submit to work. I am seeing the Request type (second field) showing up in SharePoint, any suggestions on how to get it to work in the submit?

Hilary I don't know how can i thank you? :) its working as like as i want. Thank you so so much. Best Regards

The good news is that the field is being set as anticipated (see screenshot, which shows the value of the field in the XML file). So there must be a different issue. You could try removing the column from the promoted properties and re-adding it, or you could try just re-opening this form and see if the value shows up in the promoted field. You ...

sum(../d:SharePointListItem_RW/d:l8xb[../d:Title = current()/d:Title]) - note how my formula goes up to the repeating node to summarize - ../d:SharePointListItem_RW