-
So - I'm sorry to be confused, but I'm confused. :)
I'm not sure what a WS.Query SQL query is?
If you are trying to set a query field in a custom web service to the select statement in your bullet point, you would want to use a concat formula to include the value from Profit Center:
concat("Select distinct etc....'", ...
-
Here is our process: A user submits a request form with 1 project name and several items that need to be created to support that project (in a repeating table). The requester puts all the information in one form and save/submits it. An email is sent to the support team who will review the request. Once the request is ...
-
Hello softfree,
If you could attach your form, we can take a look at it. Also - please drag on the qRules command, result, error and success nodes onto the view from the secondary data source. This can help with debugging the commands. Are you attempting the command in preview mode, or from the published location in the ...
-
Hello cotton_gin1,
This is a function that can be configured in your forms logic, but first there's a few steps to set up:This method only works with InfoPath Forms (Not SharePoint lists)Make sure that you are using custom logic to submit the form Make sure that you are capturing the FormName used in the submit data ...
-
Hello - relatively new developer in this space, and have a how-to question.
I need to use WS.Query custom control to retrieve a value from a SQL table and populate a field (FieldB) based upon another field's (FieldA) change in value (Run when field changes).
Both fields are on the same InfoPath Form.
FieldA is ...
-
Hello Joy,
In InfoPath forms, there is often a difference in the output of what the user actually views based on InfoPath version, InfoPath Client (preview) and different browsers. As a rule, we recommend optimizing the layout based on what the form looks like in the environment it will live in. This can often mean that a ...
-
Well - remember, the URL to the lists service is http://server/site/_vti_bin/lists.asmx. So, if you set it http://server/site it is going to fail. You'll need to concat in the rest of the URL.
-
Hi Hilary - I was able to create an infopath form with the CAML and Sharepoint Receive and Webservice UpdateList submit data connections. It works great!! What I would like to do now is have the ability for the user to select drop downs and calendar picklist when filling out the form. I think this either has to be done in the CAML or perhaps ...
-
Dang it. I don't think I have my parameters right on ChangeConnectionUrl. Here's what I have:
Field: SiteURL - Value=SharePointSiteUrl() - this is bringing back the correct site url!
Rule on finishedLoading = TRUE
Set command = concat("ChangeConnectionUrl /dsname=GetList /url=", SiteURL)
Getting an error ...
-
I sent you an email w/ your form attached - to get the GUID, you'll need to use a formula with the edits I added - check the template I returned in your enviro and see if that expression box now has a GUID. :)