InfoPath Dev

Hi All, I have a browser enabled form that is based on a web service and uses that web service to connect to a SQL database. The form is publised to Sharepoint and can be filled in by our users there, and when submitted the form is submitted to the Database and also to Sharepoint, but all the data is pulled from the database by the forms ...

Ha, Success. Thank you both very much for your help and patience. This form is very nearly finished now and I'm not sure I'd have got there without this forum.

no, the repeating group is called clients. Data structure on page 1 if you need to see how it looks

count(preceding-sibling::Clients) = 0 Hi Jimmy, Thanks for your reply. I placedthe above in the expression field of the conditional formatting dialog and set it to hide the control. Unfortunately, whilst this hid the control fine, it didn't appear wen I added a second client. I tried placing the control inside and outside of the repeating ...

On the same button, but with a different problem, I've been asked to place this button in the repeating section so it's intuitive as to what client it will work with, but I need to come up with a way of hiding the button for the first instance of my client section. First of all I thought the count function might work, but without ...

Thanks Hilary, I have used the concat function before, but purely on text and field uses, I've not built formulas into them before. There were just a couple of small changes I've had to make, but for anyone interest the formula is as below concat("SetValue ...

Sorry to be a pain but I'm getting this error when I check the formula Expected value type: , Actual value: name concat("SetValue /xpath=dfs:myFields/dfs:dataFields/tns:GetFormDatasetResponse/tns:GetFormDatasetResult/ns1:dsForms/ns1:Clients[, " -->count<--(preceding::ns1:Clients) + 1, "]/ns1:CustAddress1 /value=", ...

Thanks for that, I didn't realise that about the error node. It's giving me this An error has occurred executing the rule. Invalid command specified: concat

So I have the following Action - Set a fields value Field - Command Value - concat("SetValue /xpath=</dfs:myFields/dfs:dataFields/tns:GetFormDatasetResponse/tns:GetFormDatasetResult/ns1:dsForms/ns1:Clients[," <count(preceding::ns1:Clients) + 1>, "]/CustAddress1 /value=", ...

Tada! Thanks