InfoPath Dev

How does substring(Date, 0, 5) work for you?

 http://www.infopathdev.com/forums/p/25144/87127.aspx  This is something I've done quite a bit. I end up using SP 2010 calculated columns. As I have to do a fair amount of reporting based on the data entered into a particular form.  Here is one way that you could do it - ...

If it was me, I'd have an Intial Submission View, Approver 1 View, Approver 2 View and read only summary view using the formstatus fields as my open load rules.

I'm having to do something similar to this in not too distant the future. I'm currently looking into whether I can hook directly into my mail server using a web service or something similar so that I can have a 'live' lists of email groups. However, I think I'll take a different approach. Why? In my distribution list OU there ...

 All, To get around this I'm sure I read a post here earlier. In SP 2010, open up your InfoPath form library in Windows Explore, Republish your form. Then open up a form from Windows Explorer. You'll be asked to Svea and update your form. This updates the missing column values. I did have some forms where the values didn't ...

For me I'd hide the ribbon save options. I'd have the following:  two buttons. 1 called Approve, 1 called Reject on the form. A hidden field called FormStatus. I'd have another field called FinalApprovalStatus Each button has several rules to it when the button is pressed. Set the field FormStatus to 2.Submitted to X or ...

 If you have code i.e. VB etc. in the form you might need to publish the form as an admin template.  If you don't have code, make sure, File>Form Options>Programmability (I think of the top of my head). Clear any code reference here.

Are using InfoPath with SharePoint? How do users access the initial form? I'm not a fan of closing forms on a submit button. I'd rather have a rule which switches to a Thank You View and the submission of data happens in the background.  On the Thank You View, you could have a button, which closes the form. I'd hide the ribbon ...

Since you can't use SharePoint (SP) designer your options might be somewhat limited if you want to use InfoPath. I'm not even sure if you can use an InfoPath form to update a SharePoint calendar item. I don't have SP 2007. I use 2010. So this may or may not work.  Yet 2007 does have a calendar list option. Why not use ...

 All, I've just published a field to a SharePoint 2010 library. I've existing forms in my form library. How can I publish, see the field data in my newly published column without opening every form?