InfoPath Dev

Hey team, it's been a few days and no response.  I can see this forum gets a lot of activity but can anyone help point me in the right direction ? 

 I don't know if we've tested with permissions to only tables and views - I'll check w/ the test team.

 You could use a decimal field that has a default value of number(field) as the formula - with your string field in the number function.

Some additional testing I did with the TestConnectionString service revealed that the connection string to the database resolves correctly, so I pasted it straight from the web.config into Query Builder. Also the QdabraSamples now works after resetting IIS a couple of times. Without the Initial Catalog value set, the form worked, but it ...

Hi Hilary, Thanks for replying. I need to display and publish the string as currency to SP.

 Do you just need to display the string as a decimal value with the currency format? If so you can use a calculated value (expression box) for that.

You can add conditional formatting to the table to hide the row if the user name doesn't equal the formula function userName(). Watch out for casing - XPath is case sensitive. :)

 Patrick was suggesting hiring Qdabra to write the code for you - that would be custom code work, not a product that we sell. Sorry about the confusion.

Jimmy, Thanks for responding! This is more of a discussion question as I am trying to better understand how InfoPath uses XPath. Take a look at this StackOverflow question about "current" vs. "context" node. When referring to the "current" node, I don't actually mean the "current()" function but ...

Hi, Help, please. I need to convert a string to decimal with currency format. How can I do that? Thanks in advanced.