InfoPath Dev

I did just that and I created a rule to run when Submit is actioned to fill in a hex code for that field. We don't use it so it shouldn't be a problem. It submits just fine now. Thank you so so much Hilary as always you have been a great help. I promise to get out of your hair now. : ) Have a great day.

You'll want to take the now() function out of the rowstamp field. The only fields that will be submitted to the database are in /dfs:myFields/dfs:dataFields - the other fields that you've added don't seem to be required. I'd encourage you to drag the repeating group in the datafields onto your form to see what the values are after ...

I did actually see that, it's not being set in the form anywhere. But the reason I mention the empty field is because I did manage to submit the form twice but deleting that empty field (although for some reason it's not letting me do that anymore) also just to add some interger in there I put as default the now() function in that rowstamp ...

Actually - see the error message? It says in it what the issue is - it is with the rowstamp field (see attached screenshot). Is that being set in the form anywhere? You may need to check with your DBA on this ...

Thank you very much for the clarification Hilary. Moving on from that (and I know this should be another post but I only ask here because I know you already have a copy of the form that I sent you) I'm getting the attached error when trying to submit. My guess is that for some reason when the form loads that list box's first line is blank. ...

Contains or does not contain are used for things like checking a string for a substring. So - you could see if an instance of a field contained "abc" or "def" or "ABC" or "DEF".

Here's a simple sample of the technique. Save the attached file locally. Right click and select design to open in design mode. From there you can preview and try it out.

 I thought I had this one licked, Hilary Stoupa had helped me get it to work on a different form, so I tried to repeat it on a new one and I'm not getting any results.  I have a people picker where when a user selects a person should populate other fields. I've set up rules on  'selectedaccount' field. ...

I tested with Office 365. You may want to open a ticket with Microsoft - see if they can figure out what's going on....

 Hi Hilary, Still having issues with this - can I ask, are you using sharepoint online or on-premis? Thanks Kenny