InfoPath Dev

Nevermind on the Excel. We decided that csv would be fine, so I am reading the existing csv, then rewriting it with the new data appended, and mark a field in the form to note that the data has been written to the csv file. Dim varNewDirectoryName As String = ...

This solution worked perfectly! Thanks! However, after I instituted it, the other developer indicated that his app using this information (Autodesk Vault) does not work well with a text file... - He would like me to provide the same information in an Excel file, instead... Is it possible, using VB in Infopath to write a new row to an ...

Thank you so much! I will give this a go this afternoon.

I am looking to automatically export a couple fields to a text or XML file on a local hard drive whenever a form is submitted. I have done a lot of searching online, including this forum, for ideas, and due to my lack of coding knowledge, I am not having much luck. I currently have VB code attached to a button to generate folder on the local ...

Genius! ...and so easy. Thanks!

I may be showing by relative ignorance... The search results are displayed in a drop-down list box, with the secondary data source providing the list box entries. I don't see where you can set a default value?

How to I get a selection list from a secondary data source to ignore the blank row at the top of the list? I am working with a people picker. When the user enters the search name, many possibilities are returned as expected. But the user sees just the blank top row of and then never clicks the box to see that there truly are many more ...

The sub-lists are formed in 9 different fields (representing work disciplines). The user selects from a "people picker", or from a fixed list for each discipline; and the same personnel may be selected for multiple disciplines. Each of the nine sub-lists is built from using rules. So I don't think the double eval would work for ...

Very nice! This works perfectly when each field is identical, but it does not seek and destroy individual duplicate email addresses that are nested among different strings that are concat'd. e.g. works when field1="fred@email.com", and field2 also = "fred@email.com" result: fred@email.com but does not work ...

Here is the current double eval formula: substring(eval(eval((EDG-EEEmail | EDG-MEEmail | EDG-DD1Email | EDG-PlasticsEmail | EDG-EETEmail | EDG-MTEmail | EDG-DD2Email | EDG-TWEmail)[. != ""], 'concat("; ", .)'), ".."), 3, 10000) Note: Each of the fields in this formula, may have multiple emails ...