InfoPath Dev

 Creating a unique key isn't so much the impossible challenge.  The fact that basic and short identifiers are even a challenge is annoying.  Form numbers are simple, succinct, and not distracting.  It'd be nice to be able to make them without slowing down performance or requiring huge file names. 

I would still like to know if anyone has any thoughts on why this type of data connection so significantly decreases performance...but I came up with a half workaround by completely eliminating the data connection.   Here was my formula to generate a random number. Step 1:  number(concat(substring(string(today()), 6, 2), ...

Here was my formula to generate a random number. Step 1:  number(concat(substring(string(today()), 6, 2), substring(string(today()), 9, 2)))       This formula will return the month and day so 3-06-2012 is returned as a number (not a date) as 306. Step 2:  string-length(CreatedBy) * Step 1       This ...

Background: This form library is large.  Users enter a high number of forms in a row many times a day.  Within 1 year you can expect to have about 8,000 records, which then closes the library.  Because of the large number of records, the default SharePoint view for the list needs to be grouped and limited to only recent ...