-
When you enter the value for the rule, you'll click the Fx button to open the formula editor. After you paste in your formula, delete the text that says EquipmentSearch. Click the button that says Insert field or group. Navigate through the main data source to find your Equipment Search field. Select it. Try to verify the formula.
-
You picked the field using the field picker when you set up the rule to change the REST URL? EDITED TO ADD - you should use the field picker to select equipment search, if you did not already.
-
/overwrite=true or /overwrite=false. It should be in the command overview? Under SaveToPath?
-
I understand that you want to use a filter in InfoPath. I am suggesting you create a REST query to the SharePoint listdata.svc, then in InfoPath use the Change REST URL action to add a filter, then query the REST data connection. While this tutorial is for IP 2010, you should be able to follow along with IP 2013: ...
-
If this is NOT an Office 365 Browser form, you could use the SharePoint listdata.svc and a filter - http://www.benstegink.com/sharepoint-list-rest-query-filter-contains/ has an outline.
-
/mapping param is the name of the mapping data connection - generally "mapping". You may be wanting the /mappingName parameter? You only want to submit Project?
-
Were you going to use a repeating structure for your months? Or is your form schema more flat?
-
Generally, when rules fail, it is because there is something wrong with the condition. Can I see a copy of your form? You can attach it under the Options tab in a reply.
-
Okay, sorry, I feel like we are going in circles. :) What is your custom code doing? If you are using a web service to write back to SQL, where does the custom code come in?
-
Hey, David - yah, you have carefully restrict user input with execute SQL - you'd need to use dropdowns or validation rules (or other rules to sanitize input). But I had thought you were asking about submitting to a web service - have you got a web service that talks to your SQL table?