InfoPath Dev

Thanks for the reply! There are 5 corresponding fields that are by default set to blank if no data is entered...right now even if the user does not enter any data into those fields and saves the form it automatically saves the value to the calculated field to zero. So there is no way to set the default value of the calculated field to blank?

Well - how many corresponding fields are there? Maybe you could use rules instead, set rules on the fields that would set the value, with the first rule to clear the field? Then you could have conditions as to when to set the field.

Can someone please help me!

 Hi Hilary, I have deactivated and re-activated the form in central admin - and I still get the same error in when opening with a "standard" user - i.e. just contribute rights. I have created a new library and added the form to the library and I get the same error. I have re-published the form with a new name ...

Post : Is it possible to filter SharePoint list on Created date column based on date range defined(based on From date and To date which item is added to list)? This should be achieved with our using SharePoint designer and using only Client side coding.

Sorry you ended up sort of talking to yourself on this one - but I'm glad you got it figured out & thanks for posting :)

Figured it out, sort of. This XPath fixed the issue for me: concat(xdXDocument:GetDOM("Departments")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID [../d:Title = xdXDocument:get-DOM()/my:myFields/my:grpEmployee/my:ef_Department], ";#", /my:myFields/my:grpEmployee/my:ef_Department) The code highlighted ...

I was able to get an ID number to populate in the formula, however it is the wrong ID number... a static ID number populates regardless of which value in the dropdown list I select. In this example, the value that was selected from the dropdown list control has ID=10 and Title=Budget Office. Here are the two formulas and their ...

Team, I have created a form that allows users to scan barcoded files into a multi line text box. The contents of the multi line text box are saved into a single SP column and within a single record. I created another view to search for files. I can successfully display a result of the search however it contains the entire contents of multi line ...

Hello Everyone, I have a form that I updated from InfoPath 2007 to 2013. After the update, a concat formula is no longer working. I have verified that there are no errors in the formula, it is simply no longer pulling in data the way it used to. In the form I have a field (FIELD_1) which references the ID number of another field which ...