InfoPath Dev

Hi, Could you try using the formula: substring-before(field1, "T") where field1 is the field which holds tne date and time value. What this formula will do is return all values before "T" and should return the date value only. Hope this helps. 

Thank you so much, because it was becoming complicated. This strategy worked great! However, I am also using the form to view data from a list while using the InfoPath form. The Microsoft SQL only has the date and time format as (5/15/2014 8:00 PM) and output in the InfoPath form as 2014-05-15T20:00:00 What would be another ...

Hello patchoo, Sorry for my misinterpretation. For this part you may want to use an external list on SharePoint, as the users that should have access may change. I would use a people picker column in the list, and add an entry for each user. Then in your form, create a data connection to the lit and query on load. You'll then want to run the ...

Hi Bre, I thank you for trying to help, but again, the document you've attached and the explanation above is already working - the comparison between viewing user and submitting user already works. I need to get the 2nd part working - here's the logic I'm looking for if it helps STEP 1: Set SUBMITTINGUSER to the ID of who ...

I have a travel form that requires many different parts but some questions only have to be answered if a traveler answers yes to a question first. For example- the question is "Is this a single destination trip?" If the answer is Yes, then the traveler must answer the sub questions linked to that (depart from, arrive to, time frame, ...

Thanks for the additional information. I see that this is indeed a limitation for InfoPath 2007 and will only be possible if you use an owssvr data connection along with some coding. Unfortunately, I haven't tried this method yet but there should be guides out there that shows how this is done via code.

Hello, I have limited knowledge in MS Access. My requirement is to link the SharePoint 2013 site in MS Access 2013. Am able to link SP 2013 site in MS Access 2010 but now in Access 2013. Am getting the below popup when I try to link from Access 2013 "Microsoft Access could not connect to the site you specified. Verify the address ...

 I have a form with a repeating table. One of the form fields is Park. The entire form is auto-populated by required field Work Order Number. All other fields are read only. The query for the repeating table should only bring back list rows where the Park column of the row in the data source matches the Park pushed into the form Park field at ...

Thank you, this solution has saved me many times.  However, now I'm trying to use it in a repeating section that has 17 stacked repeating sections created from referencing the first one.  Now when I run the form my first count shows 18 rows do to the 17 other referenced repeating sections because it references ...