InfoPath Dev

Hi, I am trying to find out whether there is a way to do advanced calculations/transformations in Infopath using something like a WHERE or IF statement. I have a repeated section, I want to say: - Where field X in repeated section = a, add these values and display in a field - Where field X in repeated section = b, add these values and display ...

Have found that this problem occurs with all field types except text fields. It saves the data in the database (e.g. true/false - for a radio button), however the field's default value is displayed in Sharepoint not the correct data value. For example, I have a list box. It can save information in the database, however when I open the form again ...

The exercise you refer to is one of the tasks that I tried. I cannot bind the data to a data source. This is when I am getting the error. I select the data source, and then should be able bind the infopath field to a database field - as I have done in all other types of infopath fields. However I get error messages. I am only able to enter the ...

I had a second copy of the template where i was testing fixes for this. I suspect that this may have been causing the issue described above (duplicated entries). I have also reverted back to on old archived copy of the template - rebuilt the data connections and the error disappeared. I am not comfortable with this as I still don't know what ...

I cannot populate the values of drop down lists from a database. I can enter the values manually and this updates to the database but cannot display the current value in the database. It just displays the default value. I try to use the 'lookup in data connection' option, however I cannot point it to either the data field or query field. The ...

*****Just noticed somethig that may point to a problem***** or might be an additional problem? The database from where the data is populated and is written is now a mess. Infopath has stopped updating the existing records and started to add new records and linked fields each time I submit a form. For example: I opened an existing form, then ...

I am submitting using inbuilt rules in a custom button. I have not written any code. I just tell it to submit to the main data connection. This has worked fine in the past, I have no idea what changed to make this start happening in more than one fields -- Jay Whittaker --

I am using a custom button with rules. The rules allow me to use one button to submit to different sources. I have not written the code myself, just used inbuilt rules (submit data by database connection). The changes I made were small, I changed the binding of a field in the form. Changing it from a number to text. I have done similar stuff many ...

Hi, Yet another issue with Infopath. This seemed to randomly start happening one day and I can't get it to stop. Fields sumbitting to the database are getting a lot of &nbsp (spaces) appended to the end of the text. This is mucking up my formatting. In the past the same fields would just have the text that I entered. Then this started happening - ...

Hi, I get the following error when submitting the contents of a form to a database (update): ''The query method on the Document object failed. InfoPath cannot run the specified query. Connection object cannot be explicitly closed while in a transaction.'' I have rebuilt the data connections in the form, restarted the SQL server, and created a ...