-
By "IP" I meant InfoPath - the button itself shows the SQL InfoPath is using. What I'm trying to suggest is a way to get the form to let you set up the data connection - my understanding of your description was that the form is timing out when you try to create the data connection.
But it sounds like you are already directly ...
-
When you initially create the data connection to SQL there should be a button in one of the dialogs that you can click to show the actual SQL IP is using. I'm wondering about adding a "top x" to the query - do you have an idea of the max number of rows your ModifySQLQuery command might return? You could probably limit the results ...
-
Hi - you should be able to use qRules Insert to insert the repeating groups.
Then, on the repeating group, you could have a rule that sets the data for that group to the start date to the date you need - you can use a count of preceding sibling to figure out which instance you are on.
-
Oh, super excellent. Glad you found it, and glad you found a fix - thanks so much for posting!
-
Jim suggested this was possibly security settings in Internet Explorer also suggested checking event logs on the machine....
I would also suggest adding custom code to a simple form and trying that on the machine in question (unless you have other forms with custom code that do work as anticipated?). Let me know if you need a form with a few ...
-
Wow - I haven't seen this before - nice job of narrowing things down tho.
Can you try opening the form in design mode on the machine in question and previewing the form? Same results?
I'm going to ask Jim to take a look at this post and chime in with any ideas as well.
-
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. ...
-
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....
-
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?
-
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?