Cognito-forms – SharePoint “New Task” form

cognito-formssharepoint

Great product so far. I love the fact that you can connect with SharePoint/Office 365.

Interesting challenge:

When I connect a form to a standard task list, all the standard fields are not completed correctly and the custom ones are completed correctly.

Is there something special about working with the Task Content Type?

Form: https://www.cognitoforms.com/DonnellyLandscapes/NewTask

In SharePoint after submission:

Task Name - Blank
Due Date - Blank
% Complete - 50% (huh?)
Description - Blank
Task Status - Pending (huh?  Default is "Not started")
Property Name - works correctly
Email - Works correctly

Best Answer

I am a member of the Cognito Forms development team responsible for the SharePoint integration features.

Thank you for the detailed description of the issue. We are able to reproduce this issue and I will work with our development team to discuss a resolution. The underlying issue relates to the SharePoint "internal" field names for fields associated with the built-in content types. For instance, the SharePoint task content type's "Description" field has an internal field name of "Body". In these scenarios, the SharePoint integration does not properly post the Cognito Form data to the field.

I have created a feature request on the Cognito Form idea board for this request.

We welcome our users to submit features they would like to see and constantly add and update our idea board with the new features. Our users also have the ability to vote on features they would like to see in the future. This helps give us a guide as to what we should work on in our next and upcoming releases.

I hope you are enjoying using Cognito Forms!

Thank you, Kevin

Related Solutions

Sort by IP in Sharepoint list

This is actually pretty easy, I've done this in SQL Server for a long time. You just need to stop thinking of the data as an IP address. There is an old trick called bit twiddling that can be used to convert the value to an integer first. For example, 192.168.0.1 becomes 3232235521. Integers are fast and easy to sort. After doing the conversion, you drop the integer into a hidden computed column and do the sort on that column.

So if you have a text column called IPAddress and a calculated field called Integer, you would add this formula to compute the Integer column - it's really just a little binary math and you only end up storing an additional Int32 by treating each octet as a byte:

=VALUE(IF(NOT(ISBLANK([IPAddress]));(LEFT([IPAddress];
FIND(".";[IPAddress];1)-1)*16777216)+(MID([IPAddress];
FIND(".";[IPAddress];1)+1;FIND(".";[IPAddress];
FIND(".";[IPAddress];1)+1)-FIND(".";[IPAddress];1)-1)*65536)+(MID([IPAddress];
FIND(".";[IPAddress];FIND(".";[IPAddress];1)+1)+1;
FIND(".";[IPAddress];FIND(".";[IPAddress];
FIND(".";[IPAddress];1)+1)+1)-FIND(".";[IPAddress];
FIND(".";[IPAddress];1)+1)-1)*256)+(RIGHT([IPAddress];
LEN([IPAddress])-FIND(".";[IPAddress];
FIND(".";[IPAddress];FIND(".";[IPAddress];1)+1)+1)));0))

Then create a view that sorts by the hidden calcualted field Integer. If you need to sort IPv6 addresses, the concept is the same, but you're converting from hex values to binary to integers and you'll use more storage.

Cognito Forms – Authentication Methods Supported for Connecting to SharePoint

I am a developer for Cognito Forms responsible for the SharePoint integration features.

Unfortunately, Cognito Forms does not currently support authentication with SharePoint web applications that utilize forms-based authentication. Supported authentication methods include Windows authentication for on-premises SharePoint web applications and SharePoint Online/Office 365 cloud-based authentication.

After some research, we believe we will be able to add support for multi-authentication SharePoint web applications by adding a custom authentication header to our web service request to force our system to authenticate using Windows authentication - detailed here. This would require your forms-based SharePoint web application to also have Windows Authentication enabled. Is this the case for your web application?

Best Answer

Related Solutions

Sort by IP in Sharepoint list

Cognito Forms – Authentication Methods Supported for Connecting to SharePoint

Related Topic