-
When I preview your form, I can't connect to your data source (of course) -- but when I manually add items, as you can see in the attached screenshot, everything works as anticipated. This would lead me to suspect the issue is going to be somewhere in your code.
-
Any chance CaseMaster is an external list?
-
I'm not sure what you mean by "nothing is happening" -- which field is supposed to be set to what? Are you setting the value in your Total field in code, perhaps, and overwriting the default value?
-
I am not sure if I understand what the difficulty is with this, but I've attached a sample to this post that does what I think you are saying you need....If I've misunderstood, perhaps you can post your form in a reply so that I can take a look?
-
URI protocol to the rescue again - change it to lower, using the tolower() function:
concat("http://[my server]/_vti_bin/ListData.svc/Clients?$filter=startswith(tolower(LastName), tolower('", Last Name, "')) eq true")
-
Can you attach a copy of your form in the Options tab so I can see what you have for the filter?
-
If your SharePoint field doesn't have data, the row will be returned to InfoPath without the attribute -- thus the mismatch. At least in the offline data, there were no values for "Selected" -- try populating that field in your list and see if you get a different result.
-
Does this work in preview but not in browser? If so, the issue is probably postback (or some other browser related issue) but if it doesn't work in preview the issue will be with the logic in your filter. Are you using IP 2010? Filters in drop down lists are not supported in IP 2007 browser forms....
-
Well, it all looks like it should work from here... can you email me a copy of your form? I'll run it in debug later today, see what's going wrong....
-
Good news, no programming involved.
You'll need to see if the ADO.NET data services are installed on your SharePoint server. The link to the ListData.svc looks like this:
http://YOURSERVERNAME/_vti_bin/ListData.svc
With, of course, YOURSERVERNAME replaced with the SharePoint server you are using.
You should see XML returned on this page - ...