Qdabra qRules

Re: Qrules SetValue

BejeweledOne — Fri, 17 Aug 2012 17:57:16 GMT

That is correct. I have it working now. My row had 2 columns and it wasn't populating the second column but I have that working also. I have however added a 3rd column. Should I populate the 3rd column the same way I populated the 2nd column by triggering it when the first column is populated?

Re: Qrules SetValue

Hilary Stoupa — Tue, 07 Aug 2012 15:37:20 GMT

Oh, I think I may have misunderstood here.

So - I originally put in a formula that would set the value of the last instance of the row.

concat('SetValue /xpath=/my:myFields/my:grpReplacement/my:grpReplacementIssue/my:Replacement[last()]/my:strReplacementIssued /value=', strIssuedBy)

Your form logic inserts a new row, and then this should populate the newly inserted row. I'm sorry, I am kind of confused as to what is not working correctly for you?

Re: Qrules SetValue

BejeweledOne — Tue, 07 Aug 2012 11:10:28 GMT

So if I understand this correctly, I should create the rule to populate the second field on the first field (condition: when field changes)?

Re: Qrules SetValue

Hilary Stoupa — Mon, 06 Aug 2012 19:10:57 GMT

Here's another post where this same scenario just came up, see if it helps you - if not, let me know. :-)

Re: Qrules SetValue

BejeweledOne — Mon, 06 Aug 2012 18:48:11 GMT

One other question. I did get this partially working. The first action to copy infomation into the first field in the repeating table row works, but the second action to copy data into the second field in the same repeating row did not work. Is there something special that I need to do when copying data into the second field on a repeating row?

Re: Qrules SetValue

BejeweledOne — Fri, 03 Aug 2012 17:20:10 GMT

I noticed the space as well and checked that and still received the error, so I don't know what that was about. When I copy what you put here however I can save it without an error.

Re: Qrules SetValue

Hilary Stoupa — Fri, 03 Aug 2012 16:54:16 GMT

Your error indicates that in your command you don't have a space between "SetValue" and "/xpath" - although in the command above, you seem to - could you check that first?

I think you may want to use "last()" here as well, since your inserted row is probably going to be the last one, and you'll need a concat formula, so that you are passing in the actual value:

concat('SetValue /xpath=/my:myFields/my:grpReplacement/my:grpReplacementIssue/my:Replacement[last()]/my:strReplacementIssued /value=', strIssuedBy)

You'll use the field picker to select strIssuedBy when you create the concat formula. So, the command takes the XPath to the node who's value you want to set, and then the actual value (not XPath to the value field).

Qrules SetValue

BejeweledOne — Fri, 03 Aug 2012 16:18:47 GMT

I am trying to setup a 'History' table in one of my forms. I have the repeating table and have setup the Insert to insert a blank row on resubmit if a certain field is not blank.

My next rule needs to be to populate that blank row (2 fields) with the data from 2 other fields on the form. I am using qRules (4.1) for the very first time with this so I am very, very new to it.

I am trying to follow the guidelines in the user guide but am not sure my syntax is right nor if I am doing it right.

So to do this I should do an action rule, with 'Set a fields value' and select Qrules - command. Then in the function box, enter this: (I think it might be right)

SetValue /xpath=/my:myFields/my:grpReplacement/my:grpReplacementIssue/my:Replacement/my:strReplacementIssued /value=/my:myFields/my:grpIssued/my:strIssuedBy

Here is my structure: Reference datastructure.png

When I try to set this rule though I get this error: "SetValue/xpath" does not point to a valid location path of a field or group.

Help!