General

Re: What is best: rules or a calculated value field to achieve a simple goal?

AmsterdamSchool — Thu, 24 Jul 2014 14:43:20 GMT

ah! I get it. I had to take it much more literally than I did. The A ! = "" or B != "" or C !="" is actually entered and results in a true or false (without IF-Then etc), which is in turn the actual value. I would have thought this required the Result field to be a Boolean but apparently it works as well with it being a string field. Learning all the time :-)

Thank you

Re: What is best: rules or a calculated value field to achieve a simple goal?

wilkies0106aw — Thu, 24 Jul 2014 14:22:37 GMT

In my head I put the attached together.

N.B. I'm away for 2 weeks, so maybe somebody else can pick this up.

Re: What is best: rules or a calculated value field to achieve a simple goal?

AmsterdamSchool — Thu, 24 Jul 2014 14:00:22 GMT

Thank you. I'm not sure I quite get it, though.

How can A ! = "" or B != "" or C !="" be a value? This to me is a condition and not a value, and even then, what would be the syntax if I actually wanted to enter such a condition/value? If you could clarify this, that would be great. Thanks for your time.

Re: What is best: rules or a calculated value field to achieve a simple goal?

wilkies0106aw — Wed, 23 Jul 2014 15:32:04 GMT

Create another field i.e. Result. This will be hidden from the view.

Its default value is A ! = "" or B != "" or C !="" (a is blank, b is blank, c is blank). Make sure the option Refresh value when formula is recalculated is ticked.

On the Result field you can have 2 rules.

a. Set field D to true

Condition Result = true, set field D to true. Tick the box Dont run condition if met.

b. reset field D

Action set field d to blank.

What is best: rules or a calculated value field to achieve a simple goal?

AmsterdamSchool — Wed, 23 Jul 2014 11:59:08 GMT

Imagine a simplified form with 3 text fields A, B, and C, and a boolean field D. D functions as a status flag for a work flow. If A or B or C has any input (= not empty) D should be set to true. As far as I can tell there are two way to do this: rules and calculated values. I could create an action rule ‘If A not empty Or B not empty Or C not empty then set D to True’. However, to which field do I attach this rule? If I attach it to field A and leave that field empty and add content to field B, will this rule be triggered? Should I add the same rule to all three fields A,B and C? I’ll probably also need a separate rule to set D to false in case the content of a field is deleted. Maybe making D a calculated value field is better, but I find If then statements in Xpath not very straightforward. What would you suggest as the best approach? Thank you.