-
Hi -
Yes, the qRulesLastModified attribute would be an issue with using CopyTable.
While not a step by step for your particular solution, we have this document that covers how to use RefreshSharePointListItems. The delete command won't affect your SharePoint list - it is only for use in deleting items from the main data source. If you could ...
-
I wonder if you could try this method to get the number of days between the two dates. It seems that if you could get that, you'd be able to then divide by 7 and take the substring of everything before the "." to effectively round down.
Otherwise, you'll need to write custom code, or you could try qRules - which has a date diff ...
-
In you TotalLandValue field, use the sum() function in a default value. When you select the "Value" field, sum will sum all instances of the field.
sum(Value)
-
You were patient too as I kept hacking up that XPath. :-)
Glad it is all working now!
-
And again, I had it in my first sample, then went awry and dropped the "not" - sorry, my brain seems to have rolled under my desk this week. Try this:
not(xdXDocument:get-DOM()/my:myFields/my:group1/my:StatusSelection[. = current()/d:OrderStatus] )
-
Okay - I led you astray. I tried this in my environment, and what finally worked was this:
not(xdXDocument:get-DOM()/my:myFields/my:group1[my:field1 = current()/d:Employee])
Which, for your list and data source, would be a condition like this for your repeating table from your secondary data ...
-
You have Query fields in your SharePoint list connection, so I'm assuming you are using ShP 2010. Query fields are only for equivalency, but if you have SharePoint 2010, you may have OData set up (http://ShPServerName/_vti_bin/listdata.svc - replace the bold text with your ShP Server). OData allows for complex REST queries - and then you ...
-
Do you happen to be using InfoPath 2010 / SharePoint 2010? And have Excel services installed on your SharePoint server? If so, you can actually use your Excel sheet to return the data to your form via web services instead of needing to write code for this...
-
Did you try what I was showing in the screenshot in the post above this? Where in the first drop down for the conditional formatting you select any occurance of the field bound to the list box, then "is equal to" and then, in the third field, you select the OrderStatus from the repeating table data source? Attach a copy of the form with ...
-
You didn't allow much time for answers, did you? :-)
Have you thought about just disabling Save / Save As from under the form options? Then the user has to Submit, which requires the form to be in a valid state.