InfoPath Dev

 Hi Hilary, I'm using SharePoint 2010 on-premise.  Though I want to eventually call a Stored Procedure to display data in the InfoPath form, as a test I've created a simple alert box. I added a reference to System.Windows.Forms in the InfoPath code. I attempted to upload the xsn file in Central Admin but received an error ...

 Hi I have a number of forms that when opened, open in the SharePoint Context (directly in SharePoint), I think this is also known as Form Services. I have a requirement where I need to get external data from SQL but also need to pass SQL a few parameters. According to SQL documentation I cannot pass parameters to Tables nor Views ...

 Thanks Hilary, I've seen that post and was hoping there was a simpler method, a bit of a risk investing more time as the solution may not work for me as I need to used current day. Appreciate your help. 

 Hi There I want to be able to display the duration in days between todays date and a stored date. I am using a secondary datasorce linked to a SharePoint List. In the list I've created 3 columns 1. TimeStamp (date type) 2. TodayDate (Single Line of Text) . Lapsed (Single Line of Text) In InfoPath I've added a repeating ...

HiI want to conditionally set a Field value when a specific dropdown choice is made. In my dropdown I have the following columns ID, Display Name, Type The display name is what’s shown in the dropdown field. I want myTextField to = ‘Cert’ when (Type=’VAC’ and  dropdown field = the secondary source).I think I am ...

 Hi I am able to show/hide a control in a repeating table but how is it possible to show/hide a complete column (so that the header is also removed) ? Thanks 

Hi Hilary, Thanks for your fab assistance.  The data in the sub-record is for display only.  It just tells the tutor which paper(s) the student has already been entered on. If I go with option 1, how can I add a button on the repeating table which calls a data-source and how can I display the results (which control ...

Hi I have a repeating table with a secondary data source attached, this contains student reference. I need a way to display sub-record information of every row such as exam papers (Many) for each student. I have thought of two possible approaches:  1. A button can be placed on each row of the repeating student table and when ...

 Hi Hilary,  I was looking at the section and not the Main Data Source :( Found remaining answer in a previous article. http://www.infopathdev.com/forums/p/26903/93682.aspx Thanks 

HiI’ve created a section where a Repeating Table is added. One of the controls is a dropdown and the user needs to make a selection on at least one row. The section contains the main data source, and also a submission button. I want the submit button disabled unless at least one of the rows dropdown has been selected. I think part ...