-
Oh! Got it. So, what I do is add a text field to the main data source - usually in a group called FormLogic or something (I like to keep my schema organized). It doesn't need to be on the form. Then, you can set its default to calculate true or false. I'm attaching a simple sample for you to look at - save it locally, right click and ...
-
So - this is a SharePoint list form? I wonder if you set the Title query field in the main data source & execute the query if that would bring back all of them for edit.... maybe give that a try?
-
Hi - I'm having a little trouble understanding your question. Can you attach a sample form (under the Options tab) in a reply? Or a mockup?
-
I'm sorry - but you just can't do this. It simply is no longer allowed in SharePoint Online.
https://blogs.msdn.microsoft.com/sharepointdev/2014/01/14/deprecation-of-custom-code-in-sandboxed-solutions/
https://msdn.microsoft.com/en-us/pnp_articles/sandbox-solution-transformation-guidance-infopath
-
Oh man I HATE hard to repro errors - but yeah, see if you can get it to replicate, that is half the battle.
-
Hi! I'm sorry, I'm confused again. :) Can you tell me what you need help with when you say "using the field to create the list of validations"?
-
You bet - glad you got it working the way you need it to. Yeah, if you are already using the data source for something where you need all the rows, you just have to hide the rows you don't need. :)
-
I would be happy to help you - want to attach your form (or a sample form with the same setup) under the Options tab in a reply? That makes it easier for me to understand what you are doing & then I can just modify your form.
-
I would probably just query for the correct rows - so set the data connection to not query data on load, and on the course code drop down, add rules that set the course code query field in the data connection to the selected code, then query the data source. Or, you can add a formatting rule to the repeating section - just hide rows where the ...
-
Here's an update that allows zero padding in the last 4 chars of the serial number