Qdabra qRules

Re: Copy field values in Repeating Section

greenawayr — Tue, 14 Dec 2010 18:36:11 GMT

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.

Re: Copy field values in Repeating Section

Hilary Stoupa — Tue, 14 Dec 2010 16:52:17 GMT

Hi:

I still had a copy of your template on my machine. Try:

count(preceding-sibling::ns1:Clients) = 0

Re: Copy field values in Repeating Section

greenawayr — Tue, 14 Dec 2010 16:27:38 GMT

no, the repeating group is called clients.

Data structure on page 1 if you need to see how it looks

Re: Copy field values in Repeating Section

Jimmy — Tue, 14 Dec 2010 15:01:46 GMT

Are you sure the field isn't actually named my:Clients or something like that?

Re: Copy field values in Repeating Section

greenawayr — Tue, 14 Dec 2010 13:54:17 GMT

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 section, but no change.

Re: Copy field values in Repeating Section

Jimmy — Tue, 14 Dec 2010 11:53:50 GMT

If you hide the button when the following expression is true:

count(preceding-sibling::repeatingGroupNode) = 0

that should work for what you're describing.

Re: Copy field values in Repeating Section

greenawayr — Tue, 14 Dec 2010 09:12:47 GMT

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 succeeding, I have a feeling that doing this will just make the control disappear and then appear in ALL sections when there is more than one instance.

Any ideas on hiding the control on the first instance and then showing it on the rest if they are created?

Re: Copy field values in Repeating Section

greenawayr — Mon, 13 Dec 2010 11:56:10 GMT

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 /xpath=dfs:myFields/dfs:dataFields/tns:GetFormDatasetResponse/tns:GetFormDatasetResult/ns1:dsForms/ns1:Clients[", count(preceding::Clients), "]/ns1:CustAddress1 /value=", Clients[1]/CustAddress1)

Re: Copy field values in Repeating Section

Hilary Stoupa — Fri, 10 Dec 2010 19:36:55 GMT

You have some switched commas and quotes right here:

concat("SetValue /xpath=dfs:myFields/dfs:dataFields/tns:GetFormDatasetResponse/tns:GetFormDatasetResult/ns1:dsForms/ns1:Clients[, "

That should be [",

That being said, it seems like it might be helpful to clarify for you how the concat formula works. The concat formula takes as arguments comma separated values, like:

concat(field1, field2, "Some text")

Anything that is a field or a formula would not be in quotes, anything that is a regular bit of text would be in quotes, like the concat above. So, let's pretend that field1 has a value of "grape" and field2 has a value of "orange" and we are going to display our concat formula in an expression box on our form. We'd see this in our expression box:

grapeorangeSome text

Not too pretty. We can modify our formula to include some spaces!

concat(field1, " ", field2, " Some text")

Now we'd have

grape orange Some text

Mind you, the text makes no sense, but at least it is nicely formatted. For more about basic formulas and functions in InfoPath, check out this Office Online article. And this one, and this one, too.

Re: Copy field values in Repeating Section

greenawayr — Fri, 10 Dec 2010 15:29:56 GMT

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=", dfs:myFields/dfs:dataFields/tns:GetFormDatasetResponse/tns:GetFormDatasetResult/ns1:dsForms/ns1:Clients[1]/ns1:CustAddress1)

I've tried messing around with this and putting comma's in different places around this count function, but as yet, no joy!

Re: Copy field values in Repeating Section

Hilary Stoupa — Thu, 09 Dec 2010 17:42:36 GMT

The formula needs to go into the formula editor. Next to the value box in the rule action is a button that looks like this: fx

Click that button, then paste your formula in the editor box.

Re: Copy field values in Repeating Section

greenawayr — Thu, 09 Dec 2010 17:37:09 GMT

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

Re: Copy field values in Repeating Section

Hilary Stoupa — Thu, 09 Dec 2010 17:06:35 GMT

Your XPaths are incorrect, and I'm seeing some odd characters in them. The original <> marks were to indicate place holders.

concat("SetValue /xpath=dfs:myFields/dfs:dataFields/tns:GetFormDatasetResponse/tns:GetFormDatasetResult/ns1:dsForms/ns1:Clients[," count(preceding::ns1:Clients) + 1, "]/ns1:CustAddress1 /value=", dfs:myFields/dfs:dataFields/tns:GetFormDatasetResponse/tns:GetFormDatasetResult/ns1:dsForms/ns1:Clients[1]/ns1:CustAddress1)

Be sure while testing you have the QdabraRules error node visible somewhere in your form -- you'll want to be able to see any error messages.

Re: Copy field values in Repeating Section

greenawayr — Thu, 09 Dec 2010 16:49:25 GMT

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=", </dfs:myFields/dfs:dataFields/tns:GetFormDatasetResponse/tns:GetFormDatasetResult/ns1:dsForms>/Clients[1]/CustAddress1)

but no joy. Clearly doing something stupid here.

Re: Copy field values in Repeating Section

Hilary Stoupa — Thu, 09 Dec 2010 15:50:12 GMT

count(preceding::ns1:Clients) + 1 will get you the index of the current client section in the rule on your button.