General

Re: SP/InfoPath - Duplicate Values

Hilary Stoupa — Fri, 25 Apr 2014 18:14:35 GMT

So - your Dup 2 rule is comparing on CrewMem3? And it is doesn't turn the font red when there is a match? Your Conf condition isn't true in that instance, is it? Conditional formatting is applied in the order listed. Try moving Dup 2 up as the top condition. What we are doing here is testing the condition individually to see if it works. You can also change the fields pane to "Show Advanced view" and drag the data fields from your secondary data connection onto the form to see if the data values are what you'd expect.

I apologize that I'm not quite keeping up with what you have replied - but did the individual condition I originally helped you with work on its own?

Re: SP/InfoPath - Duplicate Values

bradypreston — Fri, 25 Apr 2014 17:50:43 GMT

Sure thing Hilary, I appreciate it. You don't have to do this, so of course do it when it's convenient for you! I've been at it all day trying different configurations, I really have no clue what to do :( Deadline is monday for this project to be done, yikes!

Re: SP/InfoPath - Duplicate Values

Hilary Stoupa — Fri, 25 Apr 2014 17:45:57 GMT

It is most likely just something in the XPath - can you attach your latest form and I'll take a look? It will be a bit later in the day....

Re: SP/InfoPath - Duplicate Values

bradypreston — Fri, 25 Apr 2014 16:27:57 GMT

Ah ok got it :)

I made a new rule on two fields, crewmem1 and 2 - it still doesn't format. It doesn't like that field for some reason?

I've tried deleting and recreating the field, making adjustments to the code, trying the rule on different fields... So weird!!

Re: SP/InfoPath - Duplicate Values

Hilary Stoupa — Fri, 25 Apr 2014 16:16:44 GMT

I should have been more clear.

I think you should add a new rule to your field (just for now, to test) and try your conditions individually.

Don't worry about the weird name. This is the internal name of the field - you picked it using the UI field picker, right?

Re: SP/InfoPath - Duplicate Values

bradypreston — Fri, 25 Apr 2014 16:03:14 GMT

Something is wrong with the Field 6 check. The field name is '_x0045_mp6' - I didn't name the field this, must be a defaul of sorts? Would this cause an issue?

I also tried rearranging the formula, so it would be Check field 5 or Check field 6 and Check Date... Doesn't work.

xdXDocument:GetDOM("Planning - Job Entry and Archive")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:CrewMem7 = current()/dfs:dataFields/my:SharePointListItem_RW/my:CrewMem1 and d:Date_x0020_of_x0020_Job = current()/dfs:dataFields/my:SharePointListItem_RW/my:Date_x0020_of_x0020_Job] or xdXDocument:GetDOM("Planning - Job Entry and Archive")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:x0045mp6 = current()/dfs:dataFields/my:SharePointListItem_RW/my:CrewMem1 and d:Date_x0020_of_x0020_Job = current()/dfs:dataFields/my:SharePointListItem_RW/my:Date_x0020_of_x0020_Job]

Re: SP/InfoPath - Duplicate Values

Hilary Stoupa — Fri, 25 Apr 2014 15:52:01 GMT

It sounds like you are making progress.

You can use and or or and it looks like you have used or correctly (lower case). Can you try the conditions individually to verify them? One turns it green, one turns it yellow or something?

Re: SP/InfoPath - Duplicate Values

bradypreston — Fri, 25 Apr 2014 15:46:02 GMT

I can't get it to do the same for Emp 6... I edited the code a few different ways, trial and error... What am I missing? Most recent edit:

xdXDocument:GetDOM("Planning - Job Entry and Archive")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:CrewMem5 = current()/dfs:dataFields/my:SharePointListItem_RW/my:CrewMem1 and d:Date_x0020_of_x0020_Job = current()/dfs:dataFields/my:SharePointListItem_RW/my:Date_x0020_of_x0020_Job] or xdXDocument:GetDOM("Planning - Job Entry and Archive")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:x0045mp6 = current()/dfs:dataFields/my:SharePointListItem_RW/my:CrewMem1 and d:Date_x0020_of_x0020_Job = current()/dfs:dataFields/my:SharePointListItem_RW/my:Date_x0020_of_x0020_Job]

Can I not use an And an Or in one expression!

So close!!

Re: SP/InfoPath - Duplicate Values

bradypreston — Fri, 25 Apr 2014 11:22:54 GMT

Hilary thanks so much! Just getting into the office I'll give it a go soon :) Do you do this voluntarily?! On your free time? I do have a question though, this is going to have to check if Emp 1-6 is in any of the slots of Emp 1-6 - Can I just edit this code to do that? (Testing it now) Edit: It works! You have alleviated a great deal of stress for me, I owe you! Edit:

I added 4 more expressions, changing the second Crewmem1 in your code to 2,3,4,5, respectively. Doesn't seem to be working. The other road block is that it only allows for 5 rules :S

Another Edit:

I spoke too soon :) By changing the crewmem fields in the code it is now working !!! But how do I get a sixth expression in there?

Re: SP/InfoPath - Duplicate Values

Hilary Stoupa — Thu, 24 Apr 2014 22:26:10 GMT

Okee doke. I'm a little confused... But let's try this for your conditional formatting on the Emp 1 field.

You have two conditions on your expression right now.

Remove one of them.

Change the first drop down in the remaining condition to "the expression" - you'll see a text box with some XPath. Delete the XPath in the text box.

Replace it with this:

xdXDocument:GetDOM("Planning - Job Entry and Archive")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:CrewMem1 = current()/dfs:dataFields/my:SharePointListItem_RW/my:CrewMem1 and d:Date_x0020_of_x0020_Job = current()/dfs:dataFields/my:SharePointListItem_RW/my:Date_x0020_of_x0020_Job]

This XPath is looking at your Planning - Job Entry and Archive data connection and basically saying "Is there a row there where the CrewMem1 = this CrewMem1 and the Date of Job = this Date of Job.

Can you try this?

Re: SP/InfoPath - Duplicate Values

Hilary Stoupa — Thu, 24 Apr 2014 22:08:40 GMT

I can look at it in design mode, that's what I need to do to see what your question is. :)

Re: SP/InfoPath - Duplicate Values

bradypreston — Thu, 24 Apr 2014 18:13:38 GMT

Attached :) Are you able to open the form seeing as how it is linked to a corporate sharepoint domain??

Re: SP/InfoPath - Duplicate Values

Hilary Stoupa — Thu, 24 Apr 2014 18:11:10 GMT

So, I see you attached screenshots, but what I would like to see is the actual form - can you attach that?

Re: SP/InfoPath - Duplicate Values

bradypreston — Thu, 24 Apr 2014 16:58:43 GMT

You are a god send! Thank you, attaching momentarily

Re: SP/InfoPath - Duplicate Values

Hilary Stoupa — Thu, 24 Apr 2014 16:53:18 GMT

Hey - looks like you need a little help with some conditional formatting - it would be a lot easier to visualize for me if I could see your form. Do you mind attaching under the Options tab of a reply? I'll take a look sometime today.