InfoPath Dev

Hello    I am stuck on this one and need help urgently.. I have an Infopath 2007 form developed with InfoPath Designer 2010.. I have created a button that builds a huge SQL string then submits it via a SQL connection already existing in the form.. The problem I am having is when the user hits the button the SQL string is being run twice ...

I'm using the trial version of qrules and trying to use the SubmitToSharePointList command but one step tells me to create a data connection and use the Mappings (secondary) data source but I don't have the Mappings (secondary) data source.  How do I install that? Thanks, Joyce

it's a different query for each view with different filters.  Each view has a picture button with 1 rule and 2 actions. First it queries the data connection (to SharePoint list with 400 + items) and than swicthes the view. Its like 4 phases with each phase has its own list of questions in the tasks(workflows), that displays each ...

 I've actually found what I need using filters. Thanks anyway...

Hi, Hilary Thanks for your reply again, tried the data connection 2(ID), datafields/created by/pc:person/DisplayName, only showed a repeating section, with a long list got my name(I m the current user) and my boss' name on it. if Account ID, will be my login and my boss' login. Cheers

I am trying to write a system to calculate annual leave days remaining. I have a list with each holiday being an entry. I want to add together the amount of days used previously. I have a textbox in which I want to store the number. I have got it to work so far by using the formula sum(WorkDays0) where 'WorkDays' is the column in the list ...

Hi, What I am trying seem pretty basic, I would like to have a "template" excel file included in the form from the beginning. I cannot find the option but should be possible? The idea is then to have the possibility to update the excel file by access from the form.  Is this possible? Best regards, Andreas

A NullReferenceException here will almost always mean that the node you are trying to select was not found.  Is my:AllReq a field from before or from after the modifications?  We have tentatively looked into adding custom version upgrade feature to qRules, but unfortunately haven't come up with a good way to do it so far.

Is it the same query (set of data) for each view, just filtered differently in each one?  If so, are you rerunning the query (i.e. do you use an "Execute Query" rule) every time you switch views?

Without taking business days into account, the following validation rule should work:Condition: date [Is less than] (Use a formula...) addDays(submissionDate, 10)To take business days into account, I think you'd need something like the DateDiff command in qRules (which has support for business days).  Let me know if you'd like to give ...