InfoPath Dev

In your rule where you run the date diff function, copy the value of the results node to another field. Then you can run additional commands without worrying about it gettng overwritten.

I have been able to extract the URL from a file and I would like to display a clickable link in the form. I am not sure how to go about doing this.  I started to try and build a string using html, but that does not render the HTML in the form. The field that is populated is set to a hyperlink, but all that is rendered is the file location ...

I have a form that has 3 from dates and 3 To dates. I have injected the form with QRules and I am using the DateDiff function triggered by a rule on when users enter the To Field to return the amount of days between the Start and End date. The result of the query returns to the QRules 'Result' field which I have put on my form. Example ...

Yes in fact the columns I have in the video are lookup columns to the other list.

I am looking more for the logic. I cant seem to think this one through. I understand that the ID is not generated until form is submitted initially. I need to retrive the ID and populate a field. I am guessing I can either have a button event or on form load exec code to submit the form and grab the ID, but not really sure how to go about this. ...

Okay, so I ditched the idea of getting the info from the library and instead used managed code and am using a stored procedure in our SQL database to retrieve an auto-incrementing field that resets on the new year :) this has the added benefit that you don't need to worry about having permissions to get into libraries and such PLUS the ...

Thank you very much for your reply.  I watched the video and it was helpful but I have one more question.  Will this work IF the columns in the SharePoint list are "lookup" columns?  I keep getting a number (assuming it is an ID) instead of the value.

Filters is the way to go if you want a no-code solution here. I created a video tutorial should help you out. If you have any additional questions, let me know! http://youtu.be/SH7xUEcQwwg

I'm working on a conference room request form that will work entirely independent of SharePoint (i.e., through email submit). Users company-wide should be able to fill out the form, and when they submit it, it will be automatically emailed to the appropriate facilities team member. What's the correct workflow for this? Currently, when ...

Hi INFOPATHdev community. Quick question on the possibility of using InfoPath to do a couple of things with SQL Server. I have already created a simple form that allows me to update a single table in a SQL Server database. The table is an inventory of certificates with name, contact information, expiration date, active/inactive status ...