Cognito-forms – Send to Ms SharePoint

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.

Well, here is how you'd do it if you can get to the Site Administration under site actions:

Site Actions>>Manage Content and Structure>>View:Checked out to me>>Slect items and check in

OR

Site Actions>>Under Site Administration>>Manage Content and Structure>>View:Checked out to me>>Slect items and check in

https://kis.kellogg.northwestern.edu/Pages/SharePointMassCheckIn.aspx

You should be able to get to the "Manage Content and Structure" even if you were just a sharepoint member user.