InfoPath Dev

 Yes, exactly, the web service talks to the SQL table. My preference would be to  use the web service to update the tables.   regards, David 

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?

 Hello Hilary, The custom code does the really basic CRUD operations... - Insert a single record, delete a single record and update a single record. (All using secondary data sources) and the data source is an SQL Table. So essentially I use the "Change REST URL" rule to query the source using ODATA, and then need ...

You are THE BEST, thank you! P.S. I will try InfoPathDB...

I would like to create a button on a InfoPath form that would allow user to publish as PDF (similar to the process of going to a InfoPath form, selecting File ==> Export ==> Publish as PDF. If you have a solution that does not require Visual Studion or other please respond with step-by-step instructions.

I would like to create a Print Button on the InfoPath form (next to the Submit button) that would allow the user to print the form. Can I do this without using Visual Studio and code. I have read where I can insert some code behind the button but I do not know how to do that. If you have a solution please provide a response in a step by step ...

 Glad to help! Have a great week! -Reema 

Thanks again! Another one of those simple mistakes. Now that I see it, I'm doing the DOH!

SubmitToSharePointList is specifically meant for submitting items to SharePoint Lists, I'm afraid. What does your current custom code do? I can maybe help you find a combination of qRules commands that could do what you need....

Hi Jason, You are using the wrong field in the formula. It should be LineTotal instead of Total.  Thanks, Reema Reema Daga Qdabra® Software / InfoPathDev.com / FormsQuo / 425 999 4597 direct Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™