Hi,
I am currently using Infopath 2013 which is connected into a SQL server Db, My Infopath Form has three fields:

Start_Time - DateTime
Stop_Time - DateTime
Duration - Integer

I am having trouble referencing these fields in visual studio using VB as it doesn't seem to recognise these as actual fields within the Infopath Form as the Duration field just stays blank with no errors?

Basically i'm looking to do this as an After Change event set on Stop_Time:

Duration = DateDiff("s", Start_Time, Stop_Time)

Select all Open in new window

Very very basic VB knowledge here so any help you can give me will be much appreciated.

I have an InfoPath form with a repeating table which has a dropdown.  I can add rows and set different values per row dropdown and save and reload the xml document and the rows and values are there.

I need to be able to do three things with the repeating table:
Read the rows and specifically the value of the dropdown
Add rows and set the value of the dropdown
Modify a row and set its value of the dropdown

I need to do all this within a Nintex Workflow.

Please advise.

Hi all Am working on SharePoint 2010. I have created a InfoPath form through list. I am trying to implement "Save and Continue" while the form is open and continue my work saving the information I have entered in the form. Everything works fine for the first click on Save and Continue. But when I try to do some changes and click on the "Save and Continue" it throws me the below error. " The form cannot be submitted. Save Conflict. Your changes conflict with those made concurrently by another user. If you want your changes to be applied, click Back in your Web browser, refresh the page, and resubmit your changes." Can some one suggest me on this. I am not a pro in InfoPath forms and trying to explore more and learn things. thanks all.

I have an InfoPath form with a section with repeating tables and it works up to a point.  But some of the columns share the same values when I change them on a row.

Here is the design view:

Here is at runtime:

Please advise/point me to some useful samples/tutorials on this.

I have a "Start Date" column that is a single line of text and displays a value from an InfoPath date control .
In a workflow, I need to compare that value with "now" and if it is greater than or equal to "now" initiate a task.

The Now workflow variable gets it's value at the start of the WF as follows:
Set "CurrentTime" to Current Item:Modified and has the value in the format m/d/yyyy hh:mm A.
The "Start Date" column show the date string as yyyy-mm-dd

As a result of these differences, they never compare equal.

So,  I tried to build a Year variable, a Month variable and a Day variable from the Current Item:Modified column as follows:

1. Copy from Current Item:Modified, starting at 1 for 4 characters (Output to Variable:CurrentYear)
2. Copy from Current Item:Modified, starting at 6 for 2 characters (Output to Variable:CurrentMonth)
3. Copy from Current Item:Modified, starting at 9 for 2 characters (Output to Variable:CurrentDay)

Thinking I can build a string in the format yyyy-mm-dd and then use that for compares.  I don't find a way to build this string nor am I sure if my approach will work.

Any advise on this would be appreciated.

I have a document library ("A")  and an InfoPath form that saves .xml files to that document library.  This works fine.  So,  I want to have a secondary library that I will transition xml files to via a workflow.

My first step was to create a template from the document library "A" and use that to create document library "B".  I have done that and I have the second library ("B") with the same columns as "A".  I can create xml files in either "A" or "B" and info path works as expected saving the document to the library where it was created (that's the key...).

Now I added a Workflow (SharePoint 2013) which looks at Modified documents in "A".  If a column has the value "Move to B",  the workflow copies the xml file to "B" and deletes it from "A".  That works.  Here comes the problem...

If I go to library "B" and edit the moved document in IE and change that column value to "Whatever",  the document in library "B" shows no change to that column and the xml document is being saved back to Document Library "A" with the column value set to "Whatever".

What is going on? What am I missing? How do I fix this?

When starting to use infopath, the idea was to ensure that information was submitted so that only a selection of people can view the data on a database. The database is located on another folder that has to have access granted by IT. The issue is that no one but those who had access to the database folder could submit data. I have had to move the database into an accessible area which was not the reason I went along the infopath route.
Any help??

I have been looking hi and low to auto populate user name and department in InfoPath browser form from several sources available
I tried User Profile Service but since Microsoft made it difficult in 2013 version and I am not an admin on the host I can't use this.
 I also tried User Information list. It worked perfectly in InfoPath preview but came up empty when I published the form.

So I tried to use JQuery and SP services. I captured all info in alarms correctly but cant figure out how actually place it in form controls. I use text boxes for all.
<script src="/sites/MySite/SiteCollectionDocuments/jQuery/jquery-1.8.2.min.js" type="text/javascript"></script><script src="/sites/MySite/SiteCollectionDocuments/jQuery/jquery.SPServices-2014.01.min.js" type="text/javascript">
</script><script type="text/javascript">

$(function() {        
     var thisUsersValues = $().SPServices.SPGetCurrentUser({
      fieldNames: ["Title", "EMail", "Office", "WorkPhone"],
      debug: false
});
alert(thisUsersValues.EMail);


alert(thisUsersValues.Title);
alert(thisUsersValues.Office);

alert(thisUsersValues.WorkPhone);

$('textarea[title="WorkPhone"]').thisUsersValues.WorkPhone;
$('input[title="WorkPhone"]').thisUsersValues.WorkPhone;
});
</script>

hi!
There are a lot of info on Internet about auto populating the InfoPath form with information pulled via SOAP Web Server from UserProfileServices. Unfortunately I get error message:
An error occurred accessing a data source.

An entry has been added to the Windows event log of the server.

Log ID:5566

Looking for a solution I found that I need to change data in Administration of the site which I can't do.

I tried to auto populate user information (Name, phone, email) by using User Information List from my site. It does populate my info in the NewForm but everybody else gets my name too instead of theirs.

Why does it happens?

I need to create a set of InfoPath forms and upload them with updated data to a document library.  I have put together some JavaScript which accomplishes this, but the upload of the document (InfoPath doc) is async and the code works fine when I run it in the debugger, but if I run the loop with no breakpoints, the browser hangs on the create/upload of the file.

I am not sure if it is that the function is async or that it appears to be CSOM whereas all my other code is using REST.  

Any help/ideas on this would be greatly appreciated.

Using a web part query filter and a connected InfoPath webpart/form, I can pass a query param from the URL to the web part.  There are two problems from there:
1) When the form first loads, it doesn't show the query param value.  If I add a button to the form and after the form appears click the button, I can then see the value does get passed in.  I can't use a button for this and why doesn't it appear when the form load rule says to show it?
2) On that form I have a dropdown tied to a SharePoint listbox with the display equal to title and value = ID.  How can I have the dropdown on load show one of it's items as the selected one?

I would like to redirect InfoPath to a menu page on my SharePoint Site.  At the moment, when it closes it goes to the list which can be okay, but not in my case.

I notice the the URL has a List=some string of values and then the ID=some number for the list item if it's an edit,  and some other parameter that looks sort of like a link to where to go after the form closes.

Any help on this would be appreciated.

I have a SharePoint 2016 Site Collection.  In this collection I created a custom content type with Item as the parent.  To that custom type I added a couple of choice columns.

Now I go to a list and list/settings/advanced and turn on Managed Data. After that I go into the list settings again and add this content type.  So, now I see other columns which I can then use on the list.  Ok, that seems to work.

But,  when I launch InfoPath to create a form to Create/Edit list items for this list, none of the custom content type columns show up.

Any advise on this would be appreciated.