InfoPath Dev

Hilary, you are AMAZING! That was just the nudge I needed to get it! I was able to streamline it once I realized you could change a select "VALUE" (when selecting a multi-select group) to selecting ANY OCCURRENCE OF VALUE or selecting ALL OCCURRENCES OF VALUE... not to mention the "sum" and "count" options! Once I had ...

Great idea. Please see attached. I have inserted a repeating table to simulate the external list (and that needs to be filled-in before you can start testing). I included some commentary at the bottom of the attached form, along with a screen-shot of an example of it not doing what I need. FYI... the attached form in preview mode doesn't ...

Thank you for the reply, Hilary. I have both the comma separated text field and the multi-select field promoted to SharePoint, so we can choose either as the source for the lookups. The question is how to process each value, in turn. So if the multi-select list box (or the comma separated text field version of it) has more than 1 value selected, ...

My apologies in advance for the formatting... I can't keep the line breaks in... I need a codeless solution (i.e., rules-based, tho they can be complex) to the problem I'm having. As a very simplified example of my challenge, suppose I have two lists that contain a CSV (comma separated values) plain text field, and the first table also ...

I had a similar issue and avoided using Hilary's "The Expression" option because I had so many conditions to check before allowing a user to submit the form for certain scenarios, that it would have been very tough to debug and troubleshoot. I also considered a straight sum-based solution because it also made troubleshooting ...