InfoPath Dev

 Hi Hilary,   the DestinationTextBox (please see my earlier post) content must be filtered. The content will be dynamic. That is, more content will be added by user in the list (where the DestinationTextBox content is filtered by 3 drop down lists) even if it's not dynamic, it will be very difficult to add 18 possible results on ...

I have a requirement to reset the Tracking# field of a list to 1 at the first record for a new fiscal year. The current formula for the Tracking# field is "="FY"&(YEAR(Created+92)&REPT("0",6-LEN(ID))&ID)", example "FY2018000001" would be the first record for fiscal year 2018. Fiscal year is 1 Oct ...

Hi, I have to migrate a InfoPath form from SharePoint 2010 to 2013. The form has code behind but no one knows the code. The InfoPath form is published in SharePoint 2010 with Forms Service. The library points to the Form Service. The InfoPath form also has 2 data connection. One to the library where the form is submit and the other one is the a ...

Thanks, Hillary. Unfortunately (???) it's SPO... and they don't allow me to publish forms with code. That's why I was hoping that jerry-rigging the XSL would do the trick, even if it meant the user wouldn't see it sort until the next time it was opened. Situation Update: After working with Ian K. from Microsoft, and the ...

Is your SharePoint site on premises? Or is it Office 365 / SharePoint Online? If it is on premises, you could use C# code (or qRules) for your sorting in a browser form. In general, browser forms are much less tolerant of manual modification, so I would suspect that you will have trouble with a preserve code block in one - but haven't tried ...

Here's a simple sample - save the attached file locally. Right click the local copy & select design. From there, you can preview / check out the formatting rules on the repeating table in design mode. :)

As to item 2 - sure. In the sample, there is a field called DocsComplete that has a formula to check if docs have been added, so you could have a rule on your submit button to check that all instances of DocsComplete are true (for example) allow submit.... Does data get entered into the RepSecIndividual if the legal status is NOT individual? You ...

 Hi,  I'm using the following two formatting rules to highlights the field when the following is true (i.e. when the field is duplicated within the repeating table) which works fine within the same table Comment_And_Exception  is equal to ...

All, I've a repeating table with a drop down list of options and another column for attachments. Depending on another answer on my form, The users have to attach X number of attachments. They have a list of options. How can I validate that that I have a minimum number of attachments i.e. 2 and that each attachment is of a unique type ...

Hi me again, 1. How could I replicate this when I might have several variants of required documents. i.e. depending on result of another field's entry. For example, I've a legal status drop down, 1 set of documents are required if the legal status is an individual and another set of documents will be required if the legal status is ...