InfoPath Dev

I have an Excel form that multiple users fill out daily as a status report and email to me. I gather all of the submitted forms and manuall enter the submitted data in a new Excel spreadsheet which serves as the final report of everyone's status. I obviously need to automate this process. What I would like is to have 1 central location or URL ...

Hi Shanty, Hope all is going well with you and your form. Here's one more option...     4.  using "Input Parameters" support in qRules 1.7, create a link in form A using concat that redirects to form B but with input parameters. Form B opens and uses qRules to set the fields based on the input parameters. ...

Yeah, you could code it in Visual Studio. You'll have to create your own Web Service and send a parameter to it that you run your SQL query on. It'll take a few hours, but shouldn't be too bad. There are examples out there of simple Web Services that you can use. Another idea: install DBXL trial and get it working. Provide a nice ...

Hi Harish, Sorry I forgot to put a link in to the download. http://www.qdabra.com/en/products/DBXL.aspx Let us know if you have any issues. We're here to help.

Double click the submit button. Click on Display and Conditional Formatting. Click Add. In the first dropdown select "Select set of signable data" and in the popup select the section you want. Click OK. "is signed" condition should automatically be selected by default. Check disable this control. Click OK. Click OK. ...

Hi Mark, Sorry for the delay. Yes, this is easy to do. There are three ways: Use the batch converter tool in InfoPath 2003 SDK - requires running a task on server and somethings aren't supported. Export the form to PDF (use CutePDF) or MSHTML and save that file to your server - requires a manual operation on submit to do that, or a ...

good idea from Clay, but you know relying on local machine usernames is just bad practice since it is not secure at all

I tried doing it. But when I tried to connect the list to the infopath form using data connection the calculated columns are not listed down in the select column list. I there any way that I can pass through these calculated columns to the form? Thanks,

Hello Craig,  Thx for your answer. Not sure if I was clear enough, because  I need a way to grab the data before they are stored in any way. They way I understad your code you fetch the data from the .xml file that the data is stored in after the form has been submitted?  

Can't do a browser form, so you have to custom code a form or send your data from the form library to some other list and then show that web part.  It would only show the list data (fields promoted to the library) and not the form itself.